Skip to Content
avatar image
Former Member

Is it possible to create a realtime flowgraph with more than one realtime source?

We want create a realtime flowgraph with many data sources, and we need to set realtime flag for all these data sources (data sources are virtual table from Oracle).

We tried to create a flowgraph with two data sources with realtime flag checked but, when we try to save it, we get this error:

"DP realtime flow graph may have only one realtime Data Source".

Do you have any suggestion?

Thanks in advance

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 25, 2017 at 07:18 PM

    Hi Enrico,

    Flowgraphs currently only support one realtime source. In case a join partner is another virtual table it will still be able to match the incoming records with the latest versions of the non realtime virtual table. However the trigger for the execution of the delta flow is only the realtime enabled source.

    One example:

    2 Virtual Tables (Invoices and Customers) get joined and the output is pushed to a hana table.

    Invoices will be the Realtime enabled source.

    For the Initial load it will join all existing invoices and customers and write the result into the hana table.

    If now a new Invoice comes in it will join it with the current version of the customer table and write it into the hana table.

    If a new customer comes in, it won't trigger the delta flow.

    -

    Timo

    Add comment
    10|10000 characters needed characters exceeded