SAP Running on Sybase ASE 15.7

December 19, 2011 | SAP News | Clare Plaisance | 0 Comment

Diagram: Sybase ASE Architecture

Sybase ASE 15.7, also known as the SAP release, has been generally available since September 28th. Adaptive Server Enterprise (ASE) 15.7 has been designed to support SAP’s Business Suite. SAP has advertised ASE 15.7 as a database that will easily scale both in number of users and amount of data because of its compression algorithms which expand and contract data as needed.

Rob Verschoor takes a look at how SAP Business Suite and ASE 15.7 fit together at the Sybase blog.

When running SAP Business Suite on the ASE database, the SAP application data is contained in one ASE database, which runs as an embedded component inside of the SAP system. ODBC serves as the middleware that the SAP applications use to access the ASE database and the database uses a Unicode character set.

SAP also claims simplified administration and enhanced security in Sybase ASE 15.7. The database is accessed only through the DBA Cockpit, a system tool for maintenance and monitoring which uses a small database separate from the one for Business Suite. The DBA Cockpit can be used to access ASE’s built-in job scheduler and set up automatic table maintenance that reduces fragmentation. Since ASE 15.7 was designed to support SAP Business Suite, the monitoring tools include are very detailed, allowing DBAs to identify performance problems quickly.

Rob Verschoor includes many more details on the technical specifications of SAP Business Suite running on ASE 15.7 at his blog.