Difference between ELT Combined SQL component and ELT Netezza component?

Highlighted
Seven Stars

Difference between ELT Combined SQL component and ELT Netezza component?

Hi,

 

Could you explain the difference between ELT Combined component and ELT Netezza component?

 

In the ELT tCombinedSQLOutput component I do not see Netezza in the database list.

Does Combined component does not support Netezza DB.

 

Thanks,

Revathy.

Highlighted
Nine Stars

Re: Difference between ELT Combined SQL component and ELT Netezza component?

Yes, unfortunately we don't have it, am using 6.4 Version, what is your talend version. Can you tell me what is need to use, ELT component in the job, are you doing inserts/updates?

Highlighted
Seven Stars

Re: Difference between ELT Combined SQL component and ELT Netezza component?

Talend enterprise edition 7.0

Highlighted
Nine Stars

Re: Difference between ELT Combined SQL component and ELT Netezza component?

Okay, for what purpose you want to use ELT component, caan you describe your specifics

Highlighted
Employee

Re: Difference between ELT Combined SQL component and ELT Netezza component?

Hi Revathy,

 

      Following are the only DBs supported for tCombinedSQLOutput Component and Netezza is not in the list.

 

image.png

 

 

So, if you want to perform ELT work in Netezza, please refer the below link which is having Netezza ELT components.

 

https://help.talend.com/reader/RVwYbn0XcQWx5GuCofigSQ/i7PyZv2Yq67eE6ijTk88EQ

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved :-)

Highlighted
Seven Stars

Re: Difference between ELT Combined SQL component and ELT Netezza component?

Hello Nikhil,

 

Could you explain as when do we use tCombined ELT component

 

Thanks.

Highlighted
Employee

Re: Difference between ELT Combined SQL component and ELT Netezza component?

Hi Revathy,

 

    I have not personally tried this component. So I would leave it to experts to comment on this area.

 

   @rhall_2_0  or @xdshi , would you like to comment on this query?

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved :-)

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog