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

[Former Member]

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

[leslie_moser · Accepted solution]

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

[former_member227891 · Accepted solution]

Hi Leslie,

Since you said: "there is no Microsoft driver to support a connection from AIX then the connection is not possible" do you have a documentation from SAP about this ?

I was not able to find an OSS notes or Knowlegde base about this ?

Can you provide me some official documentation ?

Regards,

Juan

[luisdarui · Accepted solution]

Hi Juan,

You shouldn't revive old threads to continue a discussion. If you have a doubt regarding the same topic, you can create a new thread and link to the old discussion.

I'll answer here but next time you have to create a new topic, ok?

In the SAP KBA 1601608 - How to access an external Microsoft SQL Server database this information is documented.

Regards,

Luis Darui

[Former Member]

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

[Reagan]

Hello

Do you have a BI Java stack installed ?

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

Regards

RB

[Former Member]

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.

[Former Member]

Hi,

Please check the below note.

1644499 - Database connectivity from Linux to SQL Server

Thanks

RishI Abrol