Skip to Content

UDI Connect from HPUX Oracle to Microsoft SQL server 2008 or 2012

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.





Add the reference for your driver to the UDI JDBC Resource Adaptor

Select resource adaptors from the drop down.


Select the line


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 the Configuration Properties tab


Fill in properties.

UserName: somecuser

Password: someuserpwd


URL: jdbc:sqlserver://servername;databaseName=SAPUDconnect




Accept the defaults for Connection pooling. (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




Test connection (Unicode and Test)



Confirm the registered program is listed in SMGW



Test the jdbc connection to MSSQL



Select SDK_JDBC in the drop down.

Hit Select Connection.  This will pull the database tables from the MS SQL database.

Be the first to leave a comment
You must be Logged on to comment or reply to a post.