Skip to Content

BW system connect to 3rd party database like MSSQL

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 23, 2013 at 08:11 AM
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 24, 2013 at 06:07 PM

    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 databases

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 23, 2013 at 11:56 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.