Inserting tExtractJSON data into a PostgreSQL database

Five Stars

Inserting tExtractJSON data into a PostgreSQL database

Hi,

I'm making a job that can extract JSON response from tRest component and insert the result into a PostgreSQL table. The job I'm using generates perfectly csv files but somehow doesn't work with PostgreSQL table as an output.

Thanks in advance .

Thirteen Stars

Re: Inserting tExtractJSON data into a PostgreSQL database

Hi,

 

so, what is your problem? what is not work in your job?

-----------
Five Stars

Re: Inserting tExtractJSON data into a PostgreSQL database

The data were not inserted in the table. it gives me the following result.

You may find the mapping details . the database is well settled and when testing the connection is successful. So i really don't see where the problem may come from 

What’s New for Talend Spring ’19

Join us live for a sneak peek!

Sign up now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads