• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Loop on Oracle Table and export them

#1 2012-04-20 10:46:54

guillaume78
Guest

Loop on Oracle Table and export them

Hi,

how may i set up a job that could loop over tables from an Oracle connexion and then export eache table into an Access DB ?

thanks,

Guillaume

#2 2012-04-20 10:53:32

pedro
Member
Registered: 2011-11-17
Posts: 3682

Re: Loop on Oracle Table and export them

Hi Guillaume

Welcome to Talend Community!

You want to synchronize these two databases, right?
This topic [Forum, topic 19072] Synchronization of databases may help you.

Regards,
Pedro


Only Paranoid Survive.

Offline

#3 2012-05-04 14:37:04

Guillaume78
Guest

Re: Loop on Oracle Table and export them

Hi,

no i just need to extract all my oracle tables into a new Ms Access Db ...

#4 2012-05-07 03:36:12

pedro
Member
Registered: 2011-11-17
Posts: 3682

Re: Loop on Oracle Table and export them

Hi

If using Talend Open Studio(Community version) which doesn't support dynamic schema, you have to do this ETL table by talbe. That means maybe each table needs to be created a new job.

Regards,
Pedro


Only Paranoid Survive.

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Loop on Oracle Table and export them

Board footer

Powered by FluxBB