topic Re: Using Talend for an ETL (Access to Oracle) project in Talend Studio

Using Talend for an ETL (Access to Oracle) project

Anonymous — Sat, 16 Nov 2024 14:30:49 GMT

Hello!
I'm a studient and I want to implement a datawarehouse but I have some problem in the ETL phase.
I'm a beginer in Talend and I want migrate my data in Access to Oracle before doing requiered transformations.
I need some tutorial or help to begin my ETL project in Talend.
Source Database : Access
Target Database : Oracle
thanks!

Re: Using Talend for an ETL (Access to Oracle) project

Anonymous — Fri, 16 Nov 2007 19:14:55 GMT

Hello,
That's a quite simple job : tAccessInput -> tOracleOutput
Read carefully TOS Documentation and more precisely the part about this components.
Regards,

Re: Using Talend for an ETL (Access to Oracle) project

_AnonymousUser — Wed, 16 Jul 2008 23:40:26 GMT

That was very precise.
If you have done that..could you please share any documnetation on how to do the migration?
my requirement is..
Legacy System on MsAccess
New System on Oracle.
New Schema in Oracle is completely different than old schema in MsAccess.
So I need to migrate data from Schema 1 (in Access) to schema 2 in Oracle where Schema 1 NOT EQUAL TO schema 2.
Any help would be greatly appreciated.
Regards,
Kaushik

Re: Using Talend for an ETL (Access to Oracle) project

Anonymous — Thu, 17 Jul 2008 02:44:32 GMT

Hello Kaushik

So I need to migrate data from Schema 1 (in Access) to schema 2 in Oracle where Schema 1 NOT EQUAL TO schema 2.

You mean you only want to insert the data which don't exist in Oralce into Oracle, right?
Best regards

shong

Re: Using Talend for an ETL (Access to Oracle) project

fyk_cz — Thu, 17 Jul 2008 07:43:03 GMT

Hello Kaushik

New Schema in Oracle is completely different than old schema in MsAccess.
So I need to migrate data from Schema 1 (in Access) to schema 2 in Oracle where Schema 1 NOT EQUAL TO schema 2.

That's not a TOS problem, that's problem with ETL process definition. When you have a different schemas, you must define where you get data for filling a target system. If you find a some data, which you need, but not exists in source system, you must define where to get or how to generate. For data, which exists in source system you define transformations.
Print a source and a target schema models, take a pencil and draw lines from source to target tables/columns. After that you start a TOS and paint a job for ETL.