topic Talend Data Catalog Export Bridges - "Database SQL DDL Script-Export" in Talend Data Catalog

Talend Data Catalog Export Bridges - "Database SQL DDL Script-Export"

SSugita1654140788 — Fri, 15 Nov 2024 22:52:00 GMT

Hello,

Is it possible to import an Informatica PowerCenter ETL job into TalendDataCatalog and then use a bridge called "Database SQL DDL Script --Export" to convert the ETL process to SQL?

Or can the bridge "Database SQL DDL Script-Export" convert only table-defined SQL?

Or do you know of other Export bridges that allow PWC to SQL migration?

https://help.talend.com/r/en-US/Cloud/tdc_bridges/mirddlexport

Re: Talend Data Catalog Export Bridges - "Database SQL DDL Script-Export"

Anonymous — Tue, 07 Jun 2022 09:05:06 GMT

Hello,

I have reported your issue to our TDC team and relevant experts and then come back to you as soon as we can.

Best regards

Sabrina

Re: Talend Data Catalog Export Bridges - "Database SQL DDL Script-Export"

Anonymous — Thu, 09 Jun 2022 06:19:37 GMT

Hello,

We got confirmation from our TDC team that it is possible to convert Informatica PowerCenter ETL job into Talend Data Catalog. However, TDC doesn't support all Talend DI components as such using this approach of importing an Informatica Job and exporting as a Talend Job will not be 100% functionally equivalent / reliable using TDC bridges.

Do you have any testing Informatica job? We can give it a try using the TDC import/export option.

Best regards

Sabrina

Re: Talend Data Catalog Export Bridges - "Database SQL DDL Script-Export"

SSugita1654140788 — Mon, 13 Jun 2022 06:41:24 GMT

Thank you for your reply.

The important thing is the scope of SQL export.

1. Is only DDL converted to SQL?

2. Convert Power Center ETL Processes to SQL?

Do you know which one?

Re: Talend Data Catalog Export Bridges - "Database SQL DDL Script-Export"

Anonymous — Mon, 13 Jun 2022 06:49:21 GMT

Hello,

Thanks for your feedback and I have escalated your issue to TDC team to see which one can be converted to SQL in talend.

Best regards

Sabrina