CODEWITHSUNDEEP
oracle-data-integrator
Hamed Tamadon
Hamed Tamadon

Reputation: 77

Problem loading datapump to table with Oracle Data Integrator

how can i import to one data pump file to table in Oracle data integrator? i have on local directory i should read file(data Pump) from this directory and import to table in oracle. By Oracle Data Integrator How is it possible?

Upvotes: 0

Views: 488

Answers (1)

Murilo Cerone Nascimento
Murilo Cerone Nascimento

Reputation: 21

To import a dumpfile you must run the "impdp" command.

There are a few ways you can make ODI do that for you:

  1. You can create a shell script file that calls the impdp with all necessary parameters and create an ODI package (using OdiOSCommand) that simply runs the shell script. For this to work your ODI agent must have access to the script and also to the database client (or the database home) so it can run impdp. (you can also use OdiOSCommand to run impdp directly)

  2. The same idea from step 1 can be done using an ODI Procedure (if maybe the import is just part of a bigger integration flow)

  3. ODI also has an LKM that uses Data Pump, but it is used to export a source table into a dumpfile and import it into a target database... If you have access to the source table metadata inside ODI Studio, you can create a simple mapping between source and target tables, choose to use the Data Pump LKM and simulate the execution. ODI will create all the necessary code to import the dumpfile

Upvotes: 2

Related Questions