topic Re: Table schema from DB2 to Oracle in Talend Studio

Table schema from DB2 to Oracle

Anonymous — Sat, 16 Nov 2024 12:24:50 GMT

Hi there,
I would like to know if is possible and how to create an Oracle table schema based on a DB2 table (fields and types).
Thanks.

Re: Table schema from DB2 to Oracle

Anonymous — Wed, 01 Feb 2012 09:27:54 GMT

Hi
As ETL tool, Talend Data Integration supports transformation within different datasources.
Use tOracleInput and tDB2Output components.
Edit Schema of each component with the same types and fields.
Regards,
Pedro

Re: Table schema from DB2 to Oracle

Anonymous — Wed, 01 Feb 2012 10:09:26 GMT

Hi Pedro,
Thanks for the fast reply. I see the idea, anyway i am not able to guess the input schema. Nothing happens, or i need to add the input columns manually?

Re: Table schema from DB2 to Oracle

Anonymous — Wed, 01 Feb 2012 10:13:29 GMT

Hi
What do you mean "i am not able to guess the input schema"?
Have you created metadata->Db Connections?
If so, you can retrieve schema from metadata.
Or you encounter a bug?
Regards,
Pedro

Re: Table schema from DB2 to Oracle

Anonymous — Wed, 01 Feb 2012 10:29:49 GMT

Problem Solved. Thanks Pedro!

Re: Table schema from DB2 to Oracle

Anonymous — Mon, 06 Feb 2012 09:56:52 GMT

Hi Pedro,
Apparently column descriptions from DB2 where not imported to Oracle. I can see them on Output Schema (Talend view) but when looking the Oracle table the column comments are all (null). What i am missing? Thanks.

Re: Table schema from DB2 to Oracle

Anonymous — Tue, 07 Feb 2012 07:55:47 GMT

Hi Joel
I received your email.
Sorry for my delay to answer.
There must be something wrong with tOracleOutput settings.
Could you upload the screenshot of tOracleOutput?
Regards,
Pedro

Re: Table schema from DB2 to Oracle

Anonymous — Tue, 07 Feb 2012 12:25:41 GMT

Here you have:
http://imageshack.us/photo/my-images/826/86931904.png/

Re: Table schema from DB2 to Oracle

Anonymous — Wed, 08 Feb 2012 01:38:35 GMT

Hi Joel
I see your image and find that you didn't set attributes "Database" and "Oracle Schema".
One more thing, you'd better select "Create table if not exists" this time.
I strongly recommend you read Tutorials about TOS and download the document.
Regards,
Pedro

Re: Table schema from DB2 to Oracle

Anonymous — Wed, 08 Feb 2012 09:08:33 GMT

Hi Pedro,
I did what you suggested but comments are still null. Any other suggestion? I tried MySQL instead Oracle and same happens. I am using Talend Open Studio 4.1.2.
About documentation, could you provide any link where i can download it? Thanks.

Re: Table schema from DB2 to Oracle

Anonymous — Wed, 08 Feb 2012 09:13:11 GMT

Hi
You can donwload here.
Just follow the scenarios.
Regards,
Pedro

Re: Table schema from DB2 to Oracle

Anonymous — Wed, 08 Feb 2012 12:02:01 GMT

Hi Pedro,
Thanks for the documentation. I have checked that document and unfortunately there are no relevant informations for "columns comments" in the whole document, so i guess my settings are all correct. Are you sure this is not a bug? Have you or any of your team mates tested this? I remember that i can pass fields names, types and all the data from one database to other, only columns comments are not being passed to the destination table. This happens also with MySQL (i also tried from a MySQL table with comments on columns to a new MySQL table). Comments are never passed.

Re: Table schema from DB2 to Oracle

Anonymous — Thu, 09 Feb 2012 11:57:55 GMT

Hi Joel
I have found the same issue at BugTracker about this. http://jira.talendforge.org/browse/TDI-12488
Sorry for wasting your time.
I?m afraid you have to add it manually.
Coments can be retrieved from DB automatically. But it can't be saved into DB?
Best regards,
Pedro