topic Exasol and dynamic Schema in Talend Studio

Exasol and dynamic Schema

Aukema — Sat, 16 Nov 2024 07:21:58 GMT

I am trying to send information to Exasol using the "Dynamic Schema" function. But the job is throwing some strange error. See screenshots for details

Is the dbtype of the tExaOut causing this issue? and how to solve this?

According the documentation the tExaOut component should be able to handle Dynamic schema

"This component offers the advantage of the dynamic schema feature. This allows you to retrieve unknown columns from source files or to copy batches of columns from a source without mapping each column individually. For further information about dynamic schemas, see Talend Studio User Guide."

When putting another output (for example tOutputDelimited), everything works fine.

I am using Talend 6.5 subscribed version of Talend.

Re: Exasol and dynamic Schema

fdenis — Fri, 02 Nov 2018 09:32:00 GMT

Does tExaOut allow Table Creation with dynamic data?
I do not think.
Your dynamic data does not have any name nor sql type so it's difficult to generate create Table.
Try to create your table previously to insert data.

Re: Exasol and dynamic Schema

Aukema — Thu, 08 Nov 2018 12:26:03 GMT

That will probably work, but I didnt continue this as the source table contained an object which contained a lot of data and required to find another solution.