Skip to Content
Author's profile photo Shen Peng

Create DataSource for DB Connect step by step

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.

Note:   You should be aware that SQL Server can not run on Linux or any UNIX OS, so SAP BW on Linux/ UNIX will not able to connect to SQL Server database with DB connect, but UD Connect (http://help.sap.com/saphelp_nw70ehp1/helpdata/en/78/ef1441a509064abee6ffd6f38278fd/content.htm ). 

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

Assigned Tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Ingo Köntje
      Ingo Köntje
      Hey,
      you made a insteresting and plain documentation.

      But there is a question left:
      you wrote:
      "Note:  You should be aware that SQL Server can not run on Linux or any UNIX OS, so SAP BW on Linux/ UNIX will not able to connect to SQL Server database."

      Does this mean, that i can not connect from SAP BW on AIX with DB2 to SQL Server database on windows?

      Author's profile photo Shen Peng
      Shen Peng
      Blog Post Author
      I'm afraid not.
      Because there is no available MS SQL Server database library for AIX/Linux/Unix. But you can use UD Connect which is like JDBC.
      Author's profile photo Former Member
      Former Member
      @Peng Shen

      You can connect to MS SQL Database via BW on Linux / Unix by deploying an BW Application server on Windows enviroment and Syncronising it with CI via SAMBA Software .