Transfer data from data server to warehouse (postgresql)

[Anonymous]

Hello, 

I am new to Talend and needed a help with transferring data from data server (postgresql) to warehouse server (postgresql). A step-wise elaboration will be appreciated.

Till now what I've been able to achieve:

1. Make DBConnections for data server and warehouse server and load their respective schemas. (tPostgresqlInput)

2. Insert a tMap between the two and map the columns of data server table and warehouse table.

But, when I run the job, it shows the following screen (in the picture), and when I try to check the warehouse table, I am not able to see any data there, i.e. table is empty.

Thanks!

 

[manodwhb]

@Harguna ,you need to commit the data once it is loaded.find the below screenshot. until unless you commit you will not see any data ,if your job has completed successfully.

[Anonymous]

Thank you for the response. I tried your method but the following error occurred (attached)

Screenshot 2019-02-07 at 12.20.21 PM.png

[manodwhb]

@Harguna ,in which component you were getting this error and check in the code tab for the error?

[Anonymous]

Here is the code version of the error:

Also, does Postjob needs to be configured or something? I just dragged and added the two components you asked me to and linked them via trigger.

Screenshot 2019-02-07 at 12.27.36 PM.png

[manodwhb]

@Harguna Can you show in design which component is failed?

[Anonymous]

Here is m workspace for the job:

Screenshot 2019-02-07 at 12.32.17 PM.png

[Anonymous]

The code says postjob component, but in the workspace, a red alert symbol is on commit component (attached images):

Screenshot 2019-02-07 at 12.27.36 PM.png
Screenshot 2019-02-07 at 12.32.17 PM.png

[manodwhb]

@Harguna ,Understand your problem,since you have not specified connection in commit component.

[Anonymous]

Do I have to configure the prefab or the postgresqlconnection component?