Find Solution to your Query

Wednesday, June 27, 2012

Connecting SAP BI to Microsoft SQL Server Database


This document reflects couple of steps that we used to connect our SAP BI on DB2/Windows x64 bit based Server with MS SQL Server Database.

The Purpose of our connection was to read one table from SQL Server DB.



Requirement:

To connect the existing SAP BI NW 7.02 on DB2 and Windows x64 bit based system with MS SQL Server Database.

Procedure:
1.    Create a Logical System for this connection. We created SQLSERVER
2.    Download the DBSL for the external RDBMS in your kernel directory - for SQL Server it is called dbmssslib.dll

Go to market place path: SAP NetWeaver and complementary products > " SAP NetWeaver" > SAP EHP2 FOR SAP NETWEAVER 7.0 > " Entry by Component" > Application Server ABAP > SAP KERNEL 7.20 64-BIT UNICODE > Windows on x64 64bit > MS SQL SERVER > and check for the Data Base Library file "lib_dbsl_218-10007271.sar"

The following 2 files are uncared from the file "lib_dbsl_218-10007271.sar": 
a.     dbmssslib.dll
b.     dbmssslib.pdb

Put both these files in the following locations
a.     D:\usr\sap\\SYS\exe\uc\NTAMD64
b.     D:\usr\sap\\DVEBMGS\exe




Go to transaction DBCO and enter the following new entries



The Parameters to be entered are as follows:

DB Connection: A name for the connection to SQL Server
DBMS: Data base type
User Name:
DB Password:
Permanent: Uncheck
Connection Limit: 0
Optimum Conns: 0

For SQL:-
Conn Info: MSSQL_SERVER= MSSQL_DBNAME= OBJECT_SOURCE=dbo
SERVER = Hostname or IP of Sever hosting SQL Server DB
DB_NAME = Data base that you need to connect to
Schema = dbo

For Oracle:-
Conn Info: SSID=;SAPDBHOST=

Once you save it, the entries will be created in Table: DBCON

Go to RSA1





Press enter and then enter/select the desired DB connection parameters as explained above.

Reference Links:



# http://help.sap.com/saphelp_smehp1/helpdata/en/f3/914f3445194d468f652d45494230b1/content.htm


# http://sap.ittoolbox.com/groups/technical-functional/sap-basis/i-am-unable-to-connect-external-mssql-db-to-bw-oracle-10g-server-2294184


# http://scn.sap.com/thread/307556


# http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/503c4394-cfb6-2e10-349e-85052e8e957d?QuickLink=index&overridelayout=true&52046414000223


# http://scn.sap.com/thread/3185151
 

Enter your email address:

Delivered by FeedBurner