Skip to Content

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.

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply