Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Aryan007
Contributor
Contributor
‎2021-04-06 11:56 AM

Data ingestion between Databases (SAP to Oracle)

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.

100 Views
0 Likes
1 Reply
ppatel
Contributor III
Contributor III
‎2022-06-07 06:25 AM

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

100 Views
0 Likes