Skip to Content
0
Nov 08, 2012 at 11:27 AM

Can SAP BODS take input as query(a java file) instead of source table and populate in target table with the generated output ?????

77 Views

In the source system, the tables are generated dynamically , so we never know the source table in advance.

(Current logic is in java , where it runs a loop on a table from which it gets to know the source table name to form a oracle query which is passed to pentaho API.

Pentaho API calls the pentaho process which runs the query and populate the target tables.)

We are planning to move this logic in SAP BODS.