When you have an Oracle database and you don't have permissions to install software on the database server, what is the best approach for being able to quickly pull out 9 million rows of data? Right now its taking over 4.5 hours using tOracleInput.
The DBA tells me data pump is installed on the database server.
I created an external table with 3 .dmp files, I see data was written into the files. Is there a way Talend can read the data out of the .dmp files?
You can use combination of 3 components:
- tOracleBulkOutput - https://help.talend.com/reader/OrVKY3aU49Xb35rRrikPTA/HfKcPUJ6JDScazgvN9q5fg
- transfer (tSCP ot tFTPPut) to Oracle server local folder
- tOracleBulkExec - https://help.talend.com/reader/OrVKY3aU49Xb35rRrikPTA/cJCqFax52pAkMsnilGVGWA