on 05-11-2010 8:22 AM
hi
Currently BI server is install in Linux and connected to our Oracle Server which also in Linux now I need to connect MS-SQL Server which is windows base to get some data.
What is the procedure to do this?
Please mention in steps?
Hi,
As mentioned before you need an Windows application server to connect to the SQL Server db as the necessary database library are only available for Windows.
You can also follow notes [178949 |https://service.sap.com/sap/support/notes/178949]and [738371 |https://service.sap.com/sap/support/notes/738371]for the necessary steps.
Regards,
Eduardo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi dude!
You should set a DBCON connection. It is explained in the notes below:
178949 - MSSQL: Database MultiConnect with EXEC SQL
738371 - Creating DBCON multiconnect entries for SQL Server
Do not worry about the password; in general in a SQL Server database you have two options to connect: with a user (DB login) and password, or through "Windows authentication". The 2nd one is the standard way of connecting for SAP, as if you use the user adm user is local).
Find more information on users and their settings at note 592514 ("MSSQL: internal database users, permissions and security").
Cheers!!
-Jesú
Hi Ishkan,
I hope the below theads will shed some light to your requirement .
/people/gilad.weinbach2/blog/2007/03/20/leveraging-your-sap-bi-data-using-the-microsoft-bi-platform
Regards,
Nibu Antony
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The only way to do this in an easy manner is to install a Windows application server into your BI landscape and use that one to connect to the SQL Server system.
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.