Skip to Content

SAP BODS : Redirecting the output to two tables

Sep 26, 2017 at 04:39 AM


avatar image
Former Member

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Murlli Maraati Sep 26, 2017 at 05:17 AM

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member
..and make sure they run in sequence.

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.