Data ingestion between Databases (SAP to Oracle)

Aryan007 — Sat, 16 Nov 2024 00:18:25 GMT

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.

Re: Data ingestion between Databases (SAP to Oracle)

ppatel — Tue, 07 Jun 2022 10:25:46 GMT

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

topic Re: Data ingestion between Databases (SAP to Oracle) in Talend Studio

Data ingestion between Databases (SAP to Oracle)

Re: Data ingestion between Databases (SAP to Oracle)