Steps to create a UDI Connect from HPUX Oracle to Microsoft SQL server 2008 or 2012
Log into a java system Netweaver Administrator (http://java_server:5<inst>00/nwa)
Select Configuration -> Infrastructure
Select the hyperlink for Application Resources
From the drop down select JDBC Drivers
Select Create New Resource -> Deploy New JDBC Driver
Add the JDBC Driver name. Hit add new driver
Note* Remember the name for later when you add the JDBC resource adaptor -> Loader Reference as (“library:mssq2008”).
Copy the MSSQL jdbc drivers (sqljdbc.jar) from the MSSQL server to your PC and select the sqljdbc.jar file.
Save
Add the reference for your driver to the UDI JDBC Resource Adaptor
Select resource adaptors from the drop down.
Select the line com.sap.ip.bi.sdk.dac.connector.jdbc
On the bottom section select Loader reference and Add New Reference
Add the Loader Reference library:mssql2008 (From the Note* above)
Configure Connection Properties
From the drop down menu select JCA Connection Factories
Select SDK_JDBC
Select the Configuration Properties tab
Fill in properties.
UserName: somecuser
Password: someuserpwd
DriverName: com.microsoft.sqlserver.jdbc.SQLServerDriver
URL: jdbc:sqlserver://servername;databaseName=SAPUDconnect
FixedCatalog:
FixedSchema:
Accept the defaults for Connection pooling.
http://service.sap.com/sap/support/notes/1050748 (for data load issues)
Select Resource Adaptors from the dropdown
Select SAPJavaResourceAdapter15
On the bottom portion fill in the Properties
Important Note1:
Make sure that there is no Jco RFC Destination with the same name that is started on the Java side!
If there is one stop it … otherwise the connection will go through the old route and UDI won’t work
Important Note2:
If the value for MaxReaderThreadCount is set to 0 RFC connection test will fail on ABAP side,
Solution is to increase that value.
Now create a TCP RFC from BW using the registered program you created on the portal java system
SM59
Test connection (Unicode and Test)
Confirm the registered program is listed in SMGW
Test the jdbc connection to MSSQL
http://java_server/5<inst>00/TestJDBC_Web/TestJDBCPage.jsp
Select SDK_JDBC in the drop down.
Hit Select Connection. This will pull the database tables from the MS SQL database.