BW system connect to 3rd party database like MSSQL

[former_member459694]

Hello Experts,

Does anyone have experience in connection setting between SAP BW system and external databases?

Our bw system is based on NW7.31 oracle db 11.2.0.3 HPUX11.31, however BW consultant would like to connect external database - MSSQL, is it something like ODBC driver I should look for? and then add it in the kernel path of BW system? I tried to find SQL Server ODBC driver for HPUX but seems there isn't..

Please kindly share your ideas. thanks a lot.

By the way, is it possible to connect BOBJ system to external databases instead of SAP BW system? how can I set it up? Thanks!

Best regards,

Freshman

[Former Member · Accepted solution]

Hi,

Have you checked the below blog.

http://scn.sap.com/community/sqlserver/blog/2013/01/19/how-to-access-an-external-microsoft-sql-serve...

Check the below note if it helps.

1644499 - Database connectivity from Linux to SQL Server

1601608 - How to access an external Microsoft SQL Server database

Please also check the below blog.

http://scn.sap.com/thread/1723395

Thanks

RishI Abrol

[Former Member]

Actually, SAP has put together a KBA article for the systems based on NW 7.10 and above.

Check the attachment for step by step instructions.

1658310 - How to configure UD connect on the J2EE (710,..730) server for JDBC access to external dat...

[former_member459694]

Hello all,

Thanks a lot for your valuable replies, I have followed the guide to do the configurations in NWA and also setup a RFC connection in ABAP side, the test connection of RFC works well, however we met problem in data retrieval.

When I create a new source system in RSA1, I can not view the database/tables within the external MSSQL. could you kindly guide me how to setup in BW side? Is there something wrong?

Thanks!

[Reagan]

Hello

Could you provide the details of the JDBC connection string ?

Are you able to see the database and the tables when you do a test JDBC ?

Regards

RB

[former_member459694]

Hello Benjamin,

my JDBC settings in NWA are as below:

and in SAPJavaResourceAdapter15, I set programID:UDI_JAVA_P73 according to the guide, the test connection from ABAP side to Java side via RFC was successful, however, in BW system RSA1, it seems I could not add a UD connection, or in other words, nothing could be seen.

10.0.4.62 is the ip the the BW system resides.

Thanks a lot.

[Reagan]

Hello

You should always leave SDK_JDBC as it is and instead copy SDK_JDBC to another name and configure the new one.

Eg: Copy SDK_JDBC to SDK_JDBC_DBNAME

Secondly the URL is not complete.

You need to mention the JDBC port for the MSSQL server in it.

The default port is 1433 for MSSQL database but you may cross check with the SQL database specialist for this server.

The URL should be :

jdbc:sqlserver://10.10.12.31:1433;database=test

You can do a test using this string.

http://FQDN-OF-J2EE-SERVER:5NN00/TestJDBC_Web/TestJDBCPage.jsp

Regards

RB

[Reagan]

Hello

UDConnect is the solution for that

You need to create a JDBC connection to the MSSQL server.

You need to have a BI Java stack for that.

You need to deploy MSSQL Drivers on the Java stack

You need create a connection in the NWA (previously using the Visual Admin tool).

In Tx RSA1 on ABAP you need to create source system with this information.

Regards

RB