Skip to Content

Steps to connect SQL database with SAP BW – UNIX ABAP Stack using UDconnect.

Applies to

Development and support based on SAP BW 7.0 and SQL Database

Summary

This document provides step by step guide to connect SQL database with SAP BW – UNIX ABAP Stack using UDconnect..

Author: Lakdawala Ashish

Created on: 12th August 2014

Version: 1.0


Back-ground

This document will help you to connect the MS SQL Database with SAP BW ( HP Unix OS / ABAP Stack) using DB Connect / UD Connect. JDBC Connection will not work because of  ABAP stack unavailibilty and installation of  windows application server on this Database is not applicable.

Solution

In this solution,

BI system connected to external MSSQL database via EP system in UD connection type data source.

Below are the steps –

UD Connection for MSSQL System:

Create JCO RFC in Portal System:

Pic1.png

Create RFC in BI system:

Pic2.png

Make it Unicode enabled

Pic3.png

Pic4.png

Download MSSQL JDBC Driver 1.2 as per Note 1109274 – New JDBC driver for NetWeaver 7.0 and higher and Load in JDBC Connector service.

Pic5.png

Go to connection container service.

Pic6.png

Add Library:

Pic7.png

Fill the below parameters

Driver Name: com.microsoft.sqlserver.jdbc.SQLServerDriver

URL: jdbc:sqlserver://<dbserver>:<port>;databaseName=<dbname>

User Name and Password

Pic8.png

Benefits of UD connection over Conventional web-service method.

1)    Reduce dependency on developers (ABAPer in SAP BI and Web service developer in MS-SQL)

2)    Easy to access of any database table/view based on user rights

3)    Reduce the time for new development

Problem of this UD Connection –

UD connect type data source won’t work if we bring down EP system for any kind of maintenance activity

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply