Premise: You need to setup BW data extraction from a remote MS SQL Server (2005 / 2012) on UNIX (AIX / HP-UX based) Systems
Observation:
Refer SAP Note:1644499 - Database connectivity from Linux to SQL Server
Solution: UDConnect(Uses J2EE Engine)
Refer SAP Note:1601608 - How to access an external Microsoft SQL Server database
Connectivity Support Matrix
Procedure:
1. Download JDBC Driver for MS SQL Server
Refer SAP Note:639702 - JDBC driver for Microsoft SQL Server
Download the latest version of the "Microsoft SQL Server JDBC Driver" from the Microsoft download page; for example:
"Microsoft SQL Server 2005 JDBC Driver 1.2" for SAP releases based on SAP NetWeaver releases between 7.0 and 7.11: This download is no longer provided by Microsoft.
If required, you can download the driver from SAP Service Marketplace:http://service.sap.com/swdc> Database and Database Patches (from other vendors)> MS SQL Server > Database Patches > MICROSOFT JDBC > MS SQL SERVER 2005 JDBC 1.2 > MS SQL SERVER > Microsoft SQL Server 2005 Driver for JDBC version 1.2
Download the zip file and extract it
2. Configure the JDBC
Go to Visual Administrator
For Testing the Connection, follow this steps:
Refer: http://wiki.scn.sap.com/wiki/display/EP/JDBC+Connection+Setup
Now Run the following link to test the connection : http://<hostname>:<port>/TestJDBC_Web/TestJDBCPage.jsp
Example: http://localhost:50000/TestJDBC_Web/TestJDBCPage.jsp
If your connection is successfully configured, a list of tables appears
3. Additional Steps
Make sure you create new JCo RFC (for each SDK_* under Connectors). 1 in this case
Any name should Work, For example it can be UDI_<xxx>
Create a corresponding RFC. Make sure the Program ID used is the same as in JCo RFC
This concludes the Technical setup of UDConnect.
Reference:
SAP Notes as Mentioned Above
http://wiki.scn.sap.com/wiki/display/VC/Step-by-Step+guide+MySQL+JDBC
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
37 | |
10 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 | |
2 | |
2 |