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

/wp-content/uploads/2014/08/pic1_519758.png

Select the hyperlink for Application Resources

/wp-content/uploads/2014/08/pic2_519759.png

From the drop down select JDBC Drivers

/wp-content/uploads/2014/08/pic3_519760.png

Select Create New Resource -> Deploy New JDBC Driver

/wp-content/uploads/2014/08/pic4_519764.png

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”).

/wp-content/uploads/2014/08/pic5_519765.png

Copy the MSSQL jdbc drivers (sqljdbc.jar) from the MSSQL server to your PC and select the sqljdbc.jar file.

/wp-content/uploads/2014/08/pic6_519766.png

Save

/wp-content/uploads/2014/08/pic7_519767.png

/wp-content/uploads/2014/08/pic8_519768.png

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

Select resource adaptors from the drop down.

/wp-content/uploads/2014/08/pic9_519769.png

Select the line com.sap.ip.bi.sdk.dac.connector.jdbc

/wp-content/uploads/2014/08/pic10_519770.png

On the bottom section select Loader reference and Add New Reference

/wp-content/uploads/2014/08/pic11_519771.png

Add the Loader Reference library:mssql2008 (From the Note* above)

/wp-content/uploads/2014/08/pic12_519772.png

Configure Connection Properties

From the drop down menu select JCA Connection Factories

/wp-content/uploads/2014/08/pic13_519773.png

Select SDK_JDBC

/wp-content/uploads/2014/08/pic14_519774.png

Select the Configuration Properties tab

/wp-content/uploads/2014/08/pic15_519775.png

Fill in properties.

UserName: somecuser

Password: someuserpwd

DriverName: com.microsoft.sqlserver.jdbc.SQLServerDriver

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

FixedCatalog:

FixedSchema:

/wp-content/uploads/2014/08/pic16_519776.png

Accept the defaults for Connection pooling.

http://service.sap.com/sap/support/notes/1050748 (for data load issues)

/wp-content/uploads/2014/08/pic17_519777.png

Select Resource Adaptors from the dropdown

/wp-content/uploads/2014/08/pic18_519778.png

Select SAPJavaResourceAdapter15

/wp-content/uploads/2014/08/pic19_519779.png

On the bottom portion fill in the Properties

/wp-content/uploads/2014/08/pic20_519780.png

/wp-content/uploads/2014/08/pic21_519781.png

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

/wp-content/uploads/2014/08/pic22_519782.png

/wp-content/uploads/2014/08/pic23_519783.png

Test connection (Unicode and Test)

/wp-content/uploads/2014/08/pic24_519784.png

/wp-content/uploads/2014/08/pic25_519785.png

Confirm the registered program is listed in SMGW

/wp-content/uploads/2014/08/pic26_519786.png

/wp-content/uploads/2014/08/pic27_519787.png

Test the jdbc connection to MSSQL

http://java_server/5<inst>00/TestJDBC_Web/TestJDBCPage.jsp

/wp-content/uploads/2014/08/pic28_519788.png

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.