Create DataSource for DB Connect step by step
This article has the following parts:
- Download database library
- Create DataSource for DB Connect
- Regarding Oracle Database
- Frequent problems
Download database library
First of all, download database library for the BW system from SAP service market: http://service.sap.com/swdc
Support Packages and Patches – Entry by Application Group” SAP NetWeaver” – SAP NETWEAVER” – SAP NETWEAVER 7.0″ – Entry by Component” Application Server ABAP – SAP KERNEL 7.00 32-BIT UNICODE
In my case, the BW is on 32-bit Unicode windows server, and I want to connect to a SQL Server database. Click ‘MS SQL SERVER’ and download lib_dbsl_248-20000973.sar.
Extract it with sapcar, and put it into the SAP execute directory. You can find the directory in the Profile like DIR_EXECUTABLE = $(DIR_INSTANCE)\exe.
Steps to create DataSource for DB Connect
Create logical system name, t-code BD54.
Now go to RSA1, create Source system at node DB Connect.
Enter connect parameters and save.
Click ‘Display DataSource Tree‘.
Create DataSource in the Application Component.
Go to ‘Extraction’ tab and enter the Table name.
Go to Proposal tab
Go to Preview tab, click ‘Read Preview Data’ button, and activate it.
Regarding Oracle Database
As OS limits of SQL Server, you may use Oracle database more often. You need to:
1. Download database library for Oracle.
2. Install Oracle client on the BW system.
3. Configure local network service name with Net Configuration Assistant.
If the SAP BW is based on Oracle already, the steps are not necessary.
Enter TNS name when you change the connect parameters.
You may have some problems like:
- No shared library found for the database with ID …
Please download and deploy the database library.
- Some table name(s) like: Alphabetical list of products Categories Category are invalid. Removed from selection ->Long Text
The naming conventions for the ABAP dictionary usually apply for table names and field names.
Make sure that you only use tables and views in the extraction whose technical names consist solely of upper case letters, numbers, and underscores (_). Problems may arise if you use other characters.
- ORA-12154: TNS:could not resolve the connect identifier
For Oracle, first you need to configure local network service name with Net Configuration Assistant.
And then modify tnsnames.ora, both %ORACLE_HOME%/network/admin and /usr/sap/SID/SYS/profile/oracle.
That’s all. Thank you.
For you more information you can look into SAP library:
Creating Database Management Systems as Source Systems
Creating DataSources for DB Connect
Requirements for Database Tables and Database Views