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

[Former Member]

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:

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: com.microsoft.sqlserver.jdbc.SQLServerDriver

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