topic Re: Create table if does not exist in Talend Studio

Create table if does not exist

Sam_10000 — Fri, 09 Oct 2020 08:10:48 GMT

Hi,

I am total newbie to Talend and trying it out.

I built a simple test job that reads from MSSql and writes data to a file. Now I tried the tMSSqlOutput component to get my results into a table. I have set the connection in tDBConnection.

I have now tried "Create table" and "Create table is does not exist". Schema is showing all my columns. When I run the job, it goes fine and show rows going into both targets (file & db). When I go to look in MSSql the table is not there.

No errors anywhere.

There must ne something simple that I am missing so can someone point me in the right direction... 🙂

Using TOS 7.3.1

Br,

Sam

Re: Create table if does not exist

manodwhb — Fri, 09 Oct 2020 08:28:05 GMT

@Sami Laitio , Have you committed the data ? using tDBcommit?

Thanks,

Manohar

Re: Create table if does not exist

Sam_10000 — Fri, 09 Oct 2020 08:32:31 GMT

Thanks, that did it.

I have been using other ETL tools for 20+ years and having to do a commit separately is new thing.

Br,

Sam

Re: Create table if does not exist

madhukolli2003 — Fri, 09 Oct 2020 14:55:27 GMT

Hi @Sami Laitio ,

You can create table using tDBOutput component .

Under Basic View -->

Table -->Provide table name

Action On Table --> Choose appropriate based on your requirement

You can use tDB commit component or you can enable Auto commit in the TDBConnection (Advanced Settings).

Also, refer to standard document for this option functionality .

Thanks & Regards,

Madhu Kolli