topic Re: I want to use tDBOutputBulk component with Dynamic Support in Talend Studio

I want to use tDBOutputBulk component with Dynamic Support

GKUMAR1634738328 — Fri, 15 Nov 2024 23:29:09 GMT

Source (SQL) target (oracle) I want to pass the data tDBOutputBulk with Dynamic Support. Is it any possible to do!

Re: I want to use tDBOutputBulk component with Dynamic Support

Anonymous — Thu, 25 Nov 2021 04:23:59 GMT

Hello,

What's talend build version are you using? V 7.3.1?

The TalendHelpCenter: tSetDynamicShema component can get schema from input columns and file. Please try to fetch DB type from input columns so that toracleBulkExec will work when tSetDynamicSchema get dynamic schema from input.

Let us know if it works.

Best regards

Sabrina

Re: I want to use tDBOutputBulk component with Dynamic Support

GKUMAR1634738328 — Thu, 25 Nov 2021 06:40:24 GMT

Hi xdshi,

Thank for the reply, I was trying to connect from input to tsetDynamicShema. But it doesn't support Dynamic. And tsetDynamicShema to tBulkExec component does not support the connection.

Re: I want to use tDBOutputBulk component with Dynamic Support

Anonymous — Thu, 25 Nov 2021 08:08:03 GMT

Hello,

We have added dynamic Schema support for TMSSQLBulkExec component in V 7.3.1 already and added Dynamic schema for tVerticaOutputBulk support in V 8.0.1

https://jira.talendforge.org/browse/TDI-40852

https://jira.talendforge.org/browse/TDI-37016

Not sure that it is OK with oracle DB as well.

Please create a new feature jira issue of DI project on talend bug tracker.

Best regards

Sabrina

Re: I want to use tDBOutputBulk component with Dynamic Support

GKUMAR1634738328 — Thu, 25 Nov 2021 09:57:35 GMT

HI,

So I am using source(Microsoft SQL) Target(Oracle), for Output I want to use Bulk components. can you please brief me please. I Need to connect from tDBInput(MIcrosoftSQL) to output (Oracle) Oracle Bulk. can you help me to fix it. I am using 7.3.1 version

Re: I want to use tDBOutputBulk component with Dynamic Support

Anonymous — Fri, 26 Nov 2021 09:01:05 GMT

Hello,

The toracleoutput component could work with 'Dynamic' schema type but not toracleOutputBulk.

It seems to be a new feature to add support dynamic Schema for tOracleOutputBulk.

Could you please create a support case on talend support portal so that our colleagues from support team would check your requirement to see if it is possible to give you a workaround on it through support cycle with priority.

Best regards

Sabrina