SAP Adaptive Server Enterprise (ASE), legacy vs. Sybase Event Stream Processor (discontinued)

High-performance, high-concurrency transactions are well suited for ASE. ASE is lacking some features in my opinion such as history tables, however there are ways to implement them via workarounds or by using Replication Server. I do think the way the ASE parser and optimizer works are far superior to other products as it is a true cost-based optimizer and the order of the tables in the FROM clause does not really matter although a good SQL coder will place the tables in a meaningful order to make the SQL more readable. ASE is good for applications that require high availability and can be used for mission critical systems.

Incentivized

These complex event processing platforms have the ability to process to multiple streams of data with low latency and ability to scale up well. It provides the ability to analyze streaming data real time and establish/investigate patterns with this streaming data and also deals with high-speed data very well.

Incentivized

• Easy to setup and maintain
• Reliable, rarely has major hiccups requiring reboots or crashes
• Very responsive with complicated queries spanning various tablespaces and hundreds of millions of rows

Incentivized

• Ability to capture data and investigate data for pattern fairly quickly
• Integrates well with Sybase database
• Ability to do data modeling

Incentivized

• Full database encryption - need to utilize external keys vs internal - for better separation of duties.
• History Tables.

Incentivized

• Configuring data streams could be made more intuitive to users
• Sometimes debugger tools are very slow

Incentivized

Our licenses are perpetual. It is the support that we will be renewing. We will renew because we continue to use and receive value from the product.

Incentivized

It does almost everything we need and for the things it doesn't do natively, we are still able to do using other features. For example, natively history tables weren't supported but we were able to create them using triggers.

Incentivized

Incredibly responsive, saving us countless hours in troubleshooting.

Incentivized

Much less effort than Oracle. Much better customer support than Oracle. Roughly equivalent to SQL Server in performance and ease of use. Much better customer service than SQL Server. Different ballpark from IQ. Same customer service.

Incentivized

IBM WebSphere business elements which was more complex to set up and also more expensive especially in a large SAP environment, We were also looking to get ramped up with the product with minimal learning curve especially with good documentation available to get started with the product as well as the ability to deploy and maintain with relative ease on an ongoing basis.

Incentivized

• Negative - Costs a lot ... but so do they all.
• Positive - It does what we need it to do.

Incentivized

• A positive impact on real-time analysis and patterns from streaming data
• Good speed
• Good documentation for setup
• No negative impact

Incentivized