SAP BI – Data Extraction using DB Connect

Using DB Connect, SAP provided another options for extracting Data from an External Source System.   It enables to extract data from Table/View from the external DBMS.   In order to load the data from these external DBMS into SAP BW Application server; one has to first connect this in SAP BW’s source system and then create DataSource in order to extract data from Table/View.  Once the DataSource is created; rest of the extraction process is similar to typical BI extraction process.

Following are the list of DB Connected Supported DBMS

SAP DB (MaxDB)   (ADA)

Microsoft SQL Server   (MSS)

Oracle  (ORA)

Informix   (INF)

IBM DB2/390  (DB2)

IBM DB2/400   (DB2)

IBM DB2 UDB  (DB2)

Firstly, Create DBMS Source system in Source System folder of Administrative WorkBench(RSA1).  Fill in the following fields

1. DB Connection = (Logical System Name)

2. DMBS =(DBMS name — see above)

3. User Name & DB Password  = (Database username and password)

4. Connection Info = ( database and host name on which database is running)

5. Permanent = (if checked; the SAP workflow will try to re-establish the interrupted connection)

6. Connection Limit = ( number of simultaneous connection to DBMS; 0=max(255), 1=1, 10=10)

7. Connection Optimum.

Create DataSource:   Call Transaction Code RSDBC – Maintenance screen DB Connect: Overview of Tables and Views.  The Following entries should be maintained in this screen.

1. Application Component

2. DataSource Type

3.Transfer

4. Selection

5. Display Data from the Table or View

6. Checking the DataSource

7. Generate DataSource: