Using OpenHub Unix to export to SQL Server

[Former Member]

Hi,

I have SAPBW 3.1(DB2 database) on a Unix machine and I need to export data to a SQL Server database on Windows. There are general issues with accessing SQL Server from a Unix machine (ODBC drivers), but what I would like to know is, does this apply using OpenHub?

Any assistance is greatly appreciated.

Kind Regards,

Lee.

[former_member181887]

Hi,

Open Hub has destinations of a flat file or a DB table ( a table in the SAP BW systems DB). Therefore it is not possible for SAP BW on Unix/DB2 to write directly to a Windows/SQL Server DB.

Open option you could have would be to have a 3rd party program read the open hub table and copy it to the SQL Server table. This would have to be a program running out side of SAP BW or on a Windows application server connected to your BW system.

I hope this helps,

Mike

[Former Member]

Hi Mike,

Thanks for the reply, this does help.

If I can write back into a table in the SAP BW database, how does that sit with Supporting 3rd party applications accessing that table?

My understanding is that SAP will not support 3rd party access to the BW database. Does that not apply to tables generated using Open Hub?

Kind Regards,

Lee

[former_member181887]

Hi Lee,

You have a good point but I think it should be ok if you take care with the reads/writes. SAP does not encourage non-SAP programs to directly read or write to tables for numerous reasons: performance impact, read consistency, locking, change management, DDIC consistency, etc.

As long as your program can ensure the above, I personally would not see an issue. Because of the above most people use some ABAP code to copy or move the table entries. The ABAP code could then be integrated into the Process chains to ensure the execution at the right time.

Just some thoughts,

Mike.

[Former Member]

Hi Mike,

Once again thank you for the reply and I appreciate the assistance.

Just one final question, do you believe that it would be possible to use ABAP code to copy the tables to a Windows/SQLServer environment?

Kind Regards,

Lee