SAP BODS : Redirecting the output to two tables

[former_member465305]

Hi All,

I want to create a BODS job which redirects the output to two target tables of different databases say table 1 belong to oracle and table 2 belongs to HANA. with condition table 1 is loaded after every 1 hour and table 2 is loaded after every 12 hour.

Can you help me how to achieve this?

[murllimaraati · Accepted solution]

You can create two separate dataflow - one for Oracle and other for HANA.

[mageshwaran_subramanian · Accepted solution]

..and make sure they run in sequence.

[former_member187605 · Accepted solution]

As the DS unit of execution is the job level, you'll need to include the data flows in separate jobs and schedule them, one to run every hour, the other every 12 hours.