Steps to connect SQL database with SAP BW – UNIX ABAP Stack using UDconnect.
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
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.
Fill the below parameters
Driver Name: com.microsoft.sqlserver.jdbc.SQLServerDriver
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