DB Connect from BW on Oracle to MS SQL Server 2005

[Former Member]

Hello,

I am having issues replicating Meta-Data from SQL server databases via DBCONNECT to SAP BW.

For instance we have the CCM DB and the Siebel DB. We can transfer meta-data from CCM with no problem (SQL Server 2000) but we cannot transfer meta-data from Siebel (SQL Server2005).

Our SAP BW is system is on an Oracle database.

CCM is on OS Win 2003. SQL 2000 SP4.

Siebel is on Win 2003 Server Enterprise 5.2 and SQL Server 2005 SP2.

I already have the dbsl for SQL server installed in the BW system. When I do a Connection Check of the source systems in RSA1, it says "Source system connection OK".

Any help will be highly appreciated.

Thanks,

Ajay

[Former Member]

Just to add, we also have the SQL client installed on the BW servers.

Our BW servers are 64-bit, while the siebel db we are trying to access is 32-bit. Could this be a cause of worry?

Thanks,

Ajay

[former_member192142]

Hi,

I don't think the 32 vs. 64 bit is the issue. Have you tried checking OSS note: 512739. It describes the prerequisites for accessing MS SQLServer via DB Connect. Normally problems occurs due to unsupported data types being used in SQLServer - in such cases you have to create views in the source system and then use these views instead of the actual database tables. In the view you can perform the necessary data type conversion.

Hth,

Jacob