Introduction

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.

 

Frequent problems

 

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.

 

Related Content

For you more information you can look into SAP library:

Creating Database Management Systems as Source Systems

http://help.sap.com/saphelp_nw70ehp1/helpdata/en/50/63d6b37bda7f4a92e2dec21b14ceee/content.htm

 

 

Creating DataSources for DB Connect

http://help.sap.com/saphelp_nw70ehp1/helpdata/en/42/fdccb72aa95277e10000000a1553f7/content.htm

 

 

Requirements for Database Tables and Database Views

http://help.sap.com/saphelp_nw70ehp1/helpdata/en/a6/4ee0a1cd71cc45a5d0a561feeaa360/content.htm