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


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


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.


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:


Create RFC in BI system:


Make it Unicode enabled



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.


Go to connection container service.


Add Library:


Fill the below parameters

Driver Name:

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

User Name and Password


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.


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

Leave a Reply