Creating a second DBConnect connection for SQL Server

[Former Member]

Greetings,

I am running BI7 on a Windows server OS using SQL Server 2008 - this is my default DBConnect connection. I need to add a second SQL Server connection to a non-SAP source system. I assume that I do not need to install DB Client or the DBSL librarries since they should already be on my BI7 servers (CI and app servers).

Where can I find instructions on how to add this second SQL Server connection for DBConnect?

Thanks in advance,

Dennis Beausoleil

[Former Member]

Hello!

I would like to extend this question. I need to connect to an SQL Server database which is not listening onthe standard Port 1433 but on a different one. How can I implement that? Is there a way to add a port to the connectionstring?

I didn't find any information about that...

[former_member184473]

Hello Bernd,

Yes it is possible, you just need to add comma port to the MSSQL_SERVER:

MSSQL_SERVER=<server>,<port>

Regards,

Eduardo Rezende

[former_member184473]

Hello Dennis,

Check the following notes:

[178949 - MSSQL: Database MultiConnect with EXEC SQL|http://service.sap.com/sap/support/notes/178949]

[323151 - Several DB connections with Native SQL|http://service.sap.com/sap/support/notes/323151]

[738371 - Creating DBCON multiconnect entries for SQL Server|http://service.sap.com/sap/support/notes/738371]

Regards,

Eduardo Rezende

[Former Member]

Thanks for pointing me to those helpful notes on DBConnect.

We will also be looking into connecting to an Oracle database and we will have to acquire the Oracle DB Client and DBSL from SAP. Is there any cost involved to implementing connections to a different database (Oracle instead of SQL Server)??

Thanks in advance

Dennis Beausoleil

[former_member184473]

Hello Dennis,

Cost to implement the external connection no.

You just need the license to use the external Oracle database.

Regards,

Eduardo

[Former Member]

Eduardo,

I will need to extract data from external Oracle databases (versionb 8.x and 9.x) into my SQL BW7 system and we will be using DBConnect for this. Where will I find the appropriate Oracle Client software and libraries? Would SAP provide these or do I need to get them from Oracle??

Hope you can help

dennis beausoleil 508 509 2914

[former_member184473]

Hello Dennis,

You can find the database library and oracle client under:

[http://service.sap.com/patches|http://service.sap.com/patches]

> Browse our Download Catalog

> Additional Components

> SAP Kernel

> <Kernel>

> <Kernel>

> <OS>

> ORACLE

> Database Library

[http://service.sap.com/oracle-download|http://service.sap.com/oracle-download]

> Oracle <release> Software (in the right side)

> Installation

> <OS>

> ORACLE

> ORACLE Client

Regards,

Eduardo