SAP SQL Anywhere Pros and Cons

RDMS tool support wide range of programing language which makes easier for the developer to intigrate with different application. our organisation just moved the database management system from SQL SERVER management to SAP SQL since it support various operating system like windows, MACOS,Linux which provide fexiblity for the developer and promises to deliver the enterprise level data management and synchronization capability. Review collected by and hosted on G2.com.

Customer support still need to deliver the best with proper solution to the issue.some time we can't able to restart the database, we need to kill from task manager and need to restart. organization has raised the IT ticket with support team there came up with solution but the issue is reoccuring there need provide fix with proper version updates. Review collected by and hosted on G2.com.

As You know SAP SQL is a database management system , which is very useful for the managing the data of the clients and owners etc , It has it own advantages and disadvantages like other data base management systems The are

Advantages

-As the users mainly consider about the security of the data, the SAP SQL gives a good security for the datas and restrictes the unauthorized users from using the data and gives an great security for the data

- SAP SQL provides the seamless performance for the huge amount of the data also without any disturbances

- SAP SQLis user friendly and users can access the data with correct authorization easily

-SAP SQLsupports other sap Softwares also

-SAP SQLis very flexible in using because it supports many programming languages

-SAP SQLalso saves the time for the user by the smooth working Review collected by and hosted on G2.com.

There are some points I dislike

They are

-SAP SQL needs huge hardware resources to perform

-SAP SQL is bit more expensive compares to the other products

- SAP SQL is bit complex to setup

So i Consider that is usefull for the large scale companies then the small companies because of the cost issues Review collected by and hosted on G2.com.

It is being used in SAP for designing non-SAP UI apps and serving as sync services and displaying data in SQL Tables for the app. It has easy interface and SQL statements are easier to execute. Review collected by and hosted on G2.com.

The sync times are longer when using SQL Anywhere. The initialization and loading data takes a lot of time in show the SQL tables. The solution of UI with SQL Anywhere makes the user experience slow. Review collected by and hosted on G2.com.

I don't even know if I can answer this. I seriously can't think of anything positive to say about this software. Review collected by and hosted on G2.com.

Everything. The database manager (which in the MS SQL world would be the management studio express clone) is clunky, and it can't even restart the database successfully. I always have to kill the database service in task manager. I bought the newest version in 2016, it was very expensive, and it has never really run right. Did I mention the automated backup service seems to stop on its own? Here's another tidbit: when you run an update query in the Query Anallyzer (the thing you use to run queries against it), it will lock the table completely and prevent changes to it unless you disconnect from it! But it wont tell you that.. I had a problem and needed to contact support once and was stuck waiting for tier 2 to call me back, only to be told that I need tier 3 to call me back. My entire company was down for about 3 hours thanks to the bureaucracy that is known as SAP. Review collected by and hosted on G2.com.

SAP SQL is secure,with a range of security features to protect data from unauthorized access.

It supports wide range of programming languages including java, python,c++ which makes it more flexible than other database management systems

It is scalable ,can handle large amounts of data and high level of user traffic without performance issue Review collected by and hosted on G2.com.

SAP SQL can be expensive, especially for start ups and small enterprises

SAP SQL may require more hardware resources than other database management systems ,which can increase costs

It is also complex to set up and maintain,which may require specialized expertise Review collected by and hosted on G2.com.

The Upsides/Advantages of SAP SQL Anywhere:

Customer Support: SAP generally provides comprehensive customer support.

Ease of Use: The software is designed to be user-friendly.

Ease of Implementation: It is designed to be relatively easy to implement, especially in embedded and mobile scenarios.

Frequency of Use: Suited for applications that require frequent remote access or mobility.

Number of Features: Offers a good set of features, especially for embedded and mobile applications.

Ease of Integration: Users often find SAP SQL Anywhere relatively easy to integrate into various applications and systems. Review collected by and hosted on G2.com.

The Downsides/Disdvantages of SAP SQL Anywhere:

Customer Support: Response times and the overall experience can vary

Ease of Use: Some users might find it less intuitive than other, more widely used databases.

Ease of Implementation: Complex setups may require more effort.

Frequency of Use: For less frequent use or for applications with simpler database needs, it might be considered overkill.

Number of Features: Might lack some advanced features present in larger, more comprehensive RDBMS. Review collected by and hosted on G2.com.

SAP SQL Anywhere is a relational database management system (RDBMS) designed for embedded database applications. Some features that make SAP SQL appreciable are:

1. Embeddability : It is designed to be embedded within applications, which makes it suitable for various software solutions.

2. Cross-Platform Support: It supports arious operating systems like Windows, Linux, MacOS which provides flexibility for developers and organizations with diverse technology environments

3. High Perfoemance: It is known for efficient performance, even with limited resources.

4. Data synchronization: It includes features for Data Synchronization which is helpful for applications that need to work offline and later sync data when connected.

5. Security Features: It consists of security features like encryption and authentication mechanisms to protect sensitive data.

6. Ease of Use: Based on my research, users find SAP SQL relatively easy to use and setup. Review collected by and hosted on G2.com.

Here are come sons of SAP SQL Anywhere as far as I know:

1. Licensing costs: It is considered that the licensing cost of SAP SQL is a bit on the higher side which makes it difficult to implement in smaller organaizations with budget constraints.

2. Limited Community support: Compared to other Database managements systems, it is considered that the SAP SQL doesnot have as much as community support than other database Management systems.

3. Feature Set: For some particular applications, developers find that SAP SQL doesn't offer some features and capabilities when compared to other database systems.

4. Integration Challenges: While working with third-part tools, develpoers find it difficult to integrate SAP SQL with those applications

5. Updates and Releases: There are some concerns about the frequency of release of updates for SAP SQL. Which makes it a bit outdated compared to other database systems. Review collected by and hosted on G2.com.

It works seamlessly with other SAP softwares, which makes it easy to integrate with other systems. It is easy to learn and implement throughout the process. It is secure with range of features to protect the data from unauthorized access.Customer Support is provided in very useful and constructive manner. Review collected by and hosted on G2.com.

It is quite expensive specially for startups and small business. As the Frequency of Use is high, the maintenance is complicated which requires skilled expertise. It Requires more hardware resources then any other database management systems with ends up in increasing the cost. Review collected by and hosted on G2.com.

SAP SQL is scalable, where it can handle large amounts traffic without performance issues.

SAP SQL is secure, with a range of security features to protect data from unauthorized access.

User friendly interface.

Cost is inexpensive.

Scales well between the desktop (single user) and client/server installations supporting 50-1000 users Review collected by and hosted on G2.com.

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.

When syntax check enabled,the editor could be slow. Review collected by and hosted on G2.com.

The TSQL language that is used is good, similar to most others. Relatively easy to implement. Review collected by and hosted on G2.com.

The software to manage it is a bit outdated, and I liked the other SQL flavors we have used more. About 20 years ago SQL Anywhere was a king, and since then I feel that they have not brought as much to the table as the other competitors in this field. Review collected by and hosted on G2.com.