Connecting MS SQL System on Windows NT OS with BW System on Linux OS
I have a requirement where i have to bring data from a MS SQL system to BW ( BI 7.0 version) system. While the MS SQL System is on Windows NT OS the BI system is on Linux OS. I cannot use DB Connect since i can connect the source and target only if both the OS's are Windows NT.
What is the work around for that, can you send me some documentation or steps for the same.
Lars Breddemann replied
interestingly I got exactely the same requirement today in one of the support messages I'd to work on.
Actually there is not much of a 'workaround'.
To access the MS SQL db you will need a database client for that on Linux.
There is no such thing available from Microsoft - that's why SAP is unable to provide a DBSL for MSSQL on any non-Windows-platform.
You may check support note #178949 - "MSSQL: Database-MultiConnect with EXEC SQL" for details on this.
So, what can you do?
This heavily depends on the needs you've for the data access.
If it's possible to change the MS SQL system to a different DBMS you may just do that and access the data in the new database simply over one of the available DBSLs (BTW: afaik AS/400 and MSSQL are the only DBMS supported by SAP that have such a nasty limitation. Oracle, Informix and MaxDB - they all have database clients available for all supported platforms!)
Another, more simple solution can be to install a small NetWeaver AS on Windows and access the data just from this AS.
Yet another option (technically) might be to use Oracle as the main NetWeaver DB and the Heterogenous Services to access the MS SQL database. Anyhow, on non-Windows-platforms you'll have to resort to 3rd party ODBC drivers to do that; which is not supported by SAP. That means: if you get trouble with this setup, you won't get a fix from SAP.
Finally you may think about what way of data access is really necesary.
Perhaps you just can push the data from the MS SQL to a staging database/schema and access this staging data from your SAP application.
These are the options I can think about. Maybe other users have other ideas/experiences?
Would be interesting to learn these solutions!