Transferring Data Using DB Connect
By default, when the BI application server starts, SAPkernel opens a connection to the database on which the SAPsystem is running. In the remainder of this section, this connection is referred to as the (SAP) default connection. All SQL commands that are submitted by the SAPkernel or ABAP programs (irrespective of whether they are open or native SQL commands), automatically refer to this default connection; they run in the context of the database transaction that is active in this connection. Connection data, such as database user name, user password, or database name are taken either from the profile parameters or from the corresponding environment variables (this is database specific).
You use DB Connect to open other database connections in addition to the default connection and use these connections to transfer data from tables or views to a BW system.
See also:
If you want to create a connection to an external database, you need relevant knowledge and experience of the source database in the following areas:
- Tools
- Database-specific SQL syntax
- Database-specific functions
You also need relevant knowledge of the source application so that you can transfer semantically utilizable data into BW.
If the BW DBMS and the source DBMS are different, you have to install a database-specific DB client for the respective source-database management system (DBMS) on the BW application server before you can use the DB Connect functions.
In all cases, you need to license the database-specific DB client with the database manufacturer. You can get information about the database-specific DB client from the respective database manufacturers.
In addition, the SAP-specific part of the database interface - the Database Shared Library (DBSL) - must be installed for the corresponding source database management system on the BW application server. For more information, seeInstalling the Database Shared Library (DBSL).
The information contained in the DB Connect documentation is subject to change. Always refer to the SAP Notes listed in the documentation.
DB Connect from BW offers flexible options for extracting data directly into the BW from tables and views in database management systems that are connected to the BW in addition to the default connection. You can use tables and views from the database management systems that are supported by SAP to transfer data. DataSources are used to make data known to BW. The data is processed in BW in the same way as data from all other sources.
With DB Connect, you can load data from a database system that is supported by SAP, by
- linking a database to the BW as a source system, thereby creating a direct point of access to external relational database management systems (RDBMS).
- Making metadata known to BW by generating a DataSource.
A purchasing application runs on a system that is based on a DBMS X. Before you can analyze the data in the purchasing application, the data must be loaded into a BW system that is based on a DBMS Y. DBMS Y can be the same as DBMS X or can be different to DBMS X. If DBMS Y is the same as DBMS X, you do not need to install the database-specific client and the database-specific DBSL. DB Connect allows you to connect the DBMS of the purchasing application and to extract the data from the database tables or views to transfer it into BW.