Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What is the best way to load tables from source (SAP) to target (Oracle) using a single job. It should pull all the tables (listed in a file or table) from source and create tables at target with same structure as in source db.
Hello,
Reads data from an SAP table on an SAP server. tSAPTableInput connects to an SAP server and reads data from a specified SAP table based on the pre-defined filter condition.
https://help.talend.com/r/en-US/8.0/sap/tsaptableinput
tOracleBulkExec inserts append, replaces or truncates data in an Oracle database. To load to oracle in a bulk manner you can use the tOracleBulkExec component:
https://help.talend.com/r/en-US/8.0/oracle/toraclebulkexec
Hope this helps.
Best regards
Pooja Patel