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

Some questions about Open hub

Background:

We need to outbound BW ODS data to a target SQL server, through Open Hub.

Questions:

1) Under what scenario shall we consider to use DB table as Open Hub Destination rather than flat file?

2) What areas shall we pay attention when using DB table?

3) What are the pros and cons between DB table as OH destination, and File as OH destination?

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 25, 2006 at 08:54 AM

    Hi,

    You can get the info on this link:

    http://help.sap.com/saphelp_nw04/helpdata/en/ce/c2463c6796e61ce10000000a114084/frameset.htm

    Hope this helps

    Assign points if useful

    Regards,

    venkat

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 25, 2006 at 09:02 AM

    Hi,

    Thanks for your reply. I am interested what senario we should use DB or flat file to post data.

    Thanks,

    Bob

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 25, 2006 at 09:10 AM

    I think you have to make the following consideration in order to use DB table or file as destination.

    1. Structural of integration, how the external system can see the data? Could read a transparent table of the DB of BW or only a file?

    2. The performance of reading the data from the external. In a DB table you can impact on the performance of BW (depending on the heavy of extraction).

    3. Creation of a delta or a full and store the history. The DB table is in advantage respect of file if you want to keep the history.

    Regards,

    Sergio

    Add a comment
    10|10000 characters needed characters exceeded

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.