Additional Blogs by Members
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member
0 Kudos

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.