SAP Adaptive Server Enterprise

SAP Adaptive Server Enterprise
Database background

SAP Adaptive Server Enterprise (SAP ASE) is a relational database management system developed by SAP. It was previously known as Sybase Adaptive Server Enterprise or Sybase ASE until SAP acquired Sybase. When people refer to the Sybase database, they generally mean Sybase Adaptive Server, not Sybase SQL Anywhere.

We support Sybase Adaptive Server (ASE) directly in our products! You don't need separate drivers and can immediately connect to your database.

Originally, the product was called Sybase SQL Server. Microsoft ported Sybase SQL Server to IBM OS/2 in 1988, and both Sybase and Microsoft sold and supported the product until their co-development licensing agreement ended in 1993.

After the agreement ended, the codebases diverged. Microsoft continued development and released Microsoft SQL Server, while Sybase continued developing its own product under the name Sybase SQL Server.

In 1996 Sybase was forced to rename its product to Sybase Adaptive Server Enterprise in order to avoid confusion with Microsoft SQL Server.

Sybase ASE is a powerful database system and is especially popular in financial institutions. SAP has encouraged customers running SAP ERP on Oracle to migrate to SAP ASE, although such migrations can be complex, risky, and expensive for large enterprise environments with many business processes.

SAP Adaptive Server Enterprise data types we support

Integral:
bigintint (integer)smallinttinyintubigintuintusmallint
Decimal:
decimal (numeric)double (double precision)float (real)moneysmallmoney
Text:
chartextunichar (nchar)unitextunivarchar (nvarchar)varchar
Binary:
binarybittimestampvarbinary
Date/Time:
datedatetime (bigdatetime)smalldatetimetime (bigtime)
Large objects:
imagetextunitext