Skip to Content
author's profile photo Former Member
Former Member

how to DB connect MS SQL to SAP BW (AIX on Oracle)

Hi BW gurus,

I have tried to do some kind of a research for getting the knowledge behind how to do a DB connect from MS SQL to SAP BW.

I have followed the steps that was required to download the Database Share Library file from SAP service market.

However, when I downloaded and extract the files on our BW system, it doesn't extract the MS SQL shared library.

our BW kernel operating system is AIX and source database is Oracle.

Can you please advise me on why is the MS SQL share library was not included in the DBSL compressed file in SAP service market?

regards,

will

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Posted on Feb 13, 2014 at 08:24 PM

    Hello Willie,

    Multiple people have answered in small parts correctly. I will summarize the complete answer for you.

    First, just to confirm the facts, you are trying to connect an SAP BW system running on AIX/Oracle to an external SQL Server system in order to extract data from an SQL Server database back to the SAP BW database. If this is not correct, please let me know as my answer below might change.

    In this scenario, Roman was correct. There is no Microsoft driver that enables a database connection from AIX to SQL Server. This means you cannot make the connection, period, regardless of what SAP database libraries you install. Since there is no Microsoft driver to support a connection from AIX then the connection is not possible.

    Therefore, in order to make a connection from an SAP BW system in order to extract data, Reagan's answer is the only connection method possible. You can establish what is called a UDConnect connection type which uses Java. The details are in our SAP Note 1601608.

    If we were not talking about BW (for example, if we were talking about remote monitoring of a SQL Server system from an AIX based DBACockpit or Solution Manager) then there is actually a slightly different answer that you could add a RedHat or SuSE Linux or Windows instance to the landscape and make all connections to the SQL Server system via that instance. But those options are only possible with remote database monitoring, you *cannot* do this for SAP BW data extractions from SQL Server. I only am adding the detail because maybe some readers have heard of the possibility of adding Linux/Windows instances to an AIX landscape.

    Best regards,

    Leslie

    ___________________________
    Leslie Moser
    Developer, Microsoft Platforms U.S.

    Netweaver Development Tools
    SAP Labs, LLC

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 28, 2013 at 06:54 AM

    Hi,

    Please check the below note.

    1644499 - Database connectivity from Linux to SQL Server

    Thanks

    RishI Abrol

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 28, 2013 at 10:46 AM

    Willie Phang wrote:

    I have tried to do some kind of a research for getting the knowledge behind how to do a DB connect from MS SQL to SAP BW.

    our BW kernel operating system is AIX and source database is Oracle.

    You need to download DBSL library for Oracle

    You need to download Oracle DBSL file for Windows and put it on server with MS SQL.

    Willie Phang wrote:

    Can you please advise me on why is the MS SQL share library was not included in the DBSL compressed file in SAP service market?

    There is no MS SQL shared library for AIX.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 28, 2013 at 11:49 AM

    Hello

    Do you have a BI Java stack installed ?

    If yes you may create a JDBC connection to the MSSQL database.

    Regards

    RB

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 13, 2014 at 02:35 PM

    Hello,

    You can try creating a DBCON entry. The details are where:

    http://help.sap.com/saphelp_nw04/helpdata/en/9c/d736b880c34f76b507bac7751a0474/content.htm

    Best regards

    Joao Vagarinho

    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.