You find the database-dependent part of the SAP database interface in its own library. This is linked dynamically to the SAP kernel. This database library contains the Database Shared Library (DBSL) and libraries belonging to the corresponding database manufacturers. These are either statically or dynamically linked to the database library.
When you start an SAP system, the database-dependent database library is loaded before the DBSL is called for the first time. The system searches for the library in the directory indicated by the environment variable DIR_LIBRARY (for example,. /usr/sap/<SAPSID>/SYS/exe/run). The environment variable dbms_type contains the name of the required database management system. When the system is started, an attempt is made to load the library belonging to the required database management system from the directory that is indicated by the environment variable DIR_LIBRARY.
For more information about the database library, see SAP Note 400818 - Information about the R/3 Database Library .
One of the advantages of this architecture is that a work process can include connections to several different databases belonging to different manufacturers.
To be able to transfer DB Connect data into a BW, you need to have installed the SAP-specific part of the database interface - the DBSL for the corresponding source-database management system for each BW application server.
The database library is available in the SAP Service Marketplace in the SAR archives LIB_DBSL<xxx>.SAR, in the patch directories. These are not specific to the database manufacturers.
We recommend that you also download the latest DBSL from the SAP Service Marketplace for SAP DB/MaxDB databases and SAP HANA databases.
To download the DBSL from the SAP Service Marketplace, proceed as follows:
You can access the required directory from the Software Center on SAP Service Marketplace at:.
You will find the the directory for SAP HANA database at:.
Load the file into the directory indicated by the environment variable DIR_LIBRARY.
The file LIB_DBSL.SAR forms a complete SAP kernel patch together with the database-independent DW.SAR archive. (SAP Note 19466 - Downloading SAP Kernel Patches describes how kernel patches are imported).
Next, unpack the SAR archive using the SAPCAR tool. Before doing so, refer to SAP Note 212876- The New Archiving Tool SAPCAR
In the directory defined in the environment variable of the BW Application server, you can find the library db<dbs>slib.<ext> , where <dbs> is the SAP-specific ID for the database management system and <ext> stands for the enhancement of the shared libraries in the respective operating system.
The database library for the Oracle database management system in Windows is called dboraslib.dll.
After you have installed the database-specific DB Client, you have fulfilled all installation prerequisites for using DB Connect. For information about the database-specific DB client, see the information from the respective database manufacturers.