Dynamic Microsoft SQL Server to Greenplum transfer.

GRoslov — Fri, 15 Nov 2024 23:26:52 GMT

Hi All!

I have a develop one such job which will by used to load data from Microsoft SQL Server to Greenplum (on Talend Data Management Platform). Without any calculation. Simple table transfer. I want to use Dynamic schema, but tDBOutput (Greenplum) does not support it.

How can i do without this component? Or this function could be quickly added (to tDBOutput (Greenplum))?

Please advise, how I can solve this problem.

Re: Dynamic Microsoft SQL Server to Greenplum transfer.

Anonymous — Mon, 06 Dec 2021 03:07:59 GMT

Hello,

So far, only tGreenplumInput component has added support for dynamic schema. The dynamic type is not supported in tGreenplumOutput component yet.

As we know that, you are able to use dynamic schema in tOracleOutput and tRedshiftOutput components.

Not sure this feature could be quickly added into tGreenplumOutput and you could create a support case on talend support portal. Our colleagues from support team will create a new feature jira issue for you through support cycle with priority.

Best regards

Sabrina

topic Re: Dynamic Microsoft SQL Server to Greenplum transfer. in Talend Studio

Dynamic Microsoft SQL Server to Greenplum transfer.

Re: Dynamic Microsoft SQL Server to Greenplum transfer.