Great workgroup RDMS at a fair price
December 11, 2021
Great workgroup RDMS at a fair price
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with SAP SQL Anywhere
We use SQL Anywhere with our GeoGraphix software for oil and gas exploration. It has been a workhorse RDMS for us for almost 25 years. It's fully ANSI SQL compliant, performs well, and handles relatively large data volumes (10,000,000 records per table). It also scales easily from a single consultant's desktop to an oil and gas major or NOC.
Pros
- Good performance with relatively large data sets - its cost-based query optimizer is particularly robust
- ANSI SQL compliant
- Supports T-SQL
- Scales well between the desktop (single user) and client/server installations supporting 50-1000 users
Cons
- Small user base makes finding information difficult.
- Third-party vendors don't support native connections to SQL Anywhere (TIBCO, ESRI). Although direct ODBC connections can be used successfully.
- Powerful full-featured RDMS
- Little or no database administration required
- Scales well from the desktop to client/server installations with 50-100 users.
- Satisfies our requirements
- Limited online support
- Price is fair
I worked with Oracle for years during my career. I wouldn't select SQL Anywhere to implement a global ATM system with tens of thousands of concurrent connections, but SQL Anywhere is much easier to use and deploy and works very well in workgroup settings. Query performance often exceeds some Oracle versions without having to rely on database tuning.
Do you think SAP SQL Anywhere delivers good value for the price?
Yes
Are you happy with SAP SQL Anywhere's feature set?
Yes
Did SAP SQL Anywhere live up to sales and marketing promises?
Yes
Did implementation of SAP SQL Anywhere go as expected?
Yes
Would you buy SAP SQL Anywhere again?
Yes
Comments
Please log in to join the conversation