Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
dan-rosen
Contributor II
Contributor II

tDBOutput component fails to create a database table

I'm experiencing an issue trying to create a table in a postgres database using the tDBOutput component, where I receive an error that the table does not exist. for reference, I've tried various table actions (drop and create, drop if exists and create, create if does not exist, create, etc.), along with an insert action on data, and every time it tells me that it can't insert data because the table doesn't exist. it seems it's failing to create the table. I have no issues if I create the table myself in the database management tool and then use Talend to insert rows, but I'm looking at doing a mass data transfer for many tables and want to create the tables using Talend so that the table schemas can detect and build themselves. anyone know what the cause of this may be?

Labels (5)
1 Reply
Anonymous
Not applicable

Hello @Dan Rosen​ ,

What's the db Type for the tDBOutput component in your side?

In my side, I test with MySQL db with Action on table "Drop table if exists and create" and Action on data "Insert" for tDBOutput, it's working as expected as the below

0695b00000bFHtVAAW.png