Skip to Content
author's profile photo Former Member
Former Member

Using OpenHub Unix to export to SQL Server

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jan 17, 2005 at 04:45 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Michael Eacrett

      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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.