on 12-23-2013 7:38 AM
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
Hi,
Have you checked the below blog.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!
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.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.