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 · Accepted solution]

@Harguna ,yes ,you need configure connection component or if you have created metadata for the  target DB you can drag that into designer there you can specify postgresqlconnection component.

[Anonymous]

New error in prejob and old error in post job are still there. I am attaching the screenshot.

Btw, let me clear it out what I've done overall:

1. Added prejob component and connected with target DB postgresqlconnection.

2. added source and target postgresql DBs as tpostgresqlinput and tpostgresqloutput, connected via tmap where columns are mapped.

3. added postjob component and commit component.

Screenshot 2019-02-07 at 12.55.42 PM.png

[manodwhb]

@Harguna ,show me the design with error component? have you select prostgresqlsonnection in the component list of tPostgresqlCommit?

[Anonymous]

Yes, I did add postgresqlconeection in postgresqlcommit.

Here are screenshots of the error and the designer:

Screenshot 2019-02-07 at 1.03.28 PM.png
Screenshot 2019-02-07 at 1.04.36 PM.png

[manodwhb]

@Harguna ,I am not able to download the attachment,can you re-share the job design? 

[Anonymous]

Here you go:

Btw, thank you so much for the help

Screenshot 2019-02-07 at 1.11.23 PM.png
Screenshot 2019-02-07 at 1.11.31 PM.png

[manodwhb]

@Harguna ,you have correctly the Commit component. you need to see the error from 

Window>>Show View>>General>>Error Log

[Anonymous]

If you check the error window in previous screenshots, you'll see that it says some java compatibility issues, or some plug-in issues (screenshot attached here). Any ideas about this?

Screenshot 2019-02-07 at 1.28.22 PM.png

[manodwhb]

@Harguna ,it is difficult from that screenshot,could you please share the ecah component settings and schema?

[Anonymous]

I updated JVM version and that error stopped showing but a new error has come which says that permission to the database denied. I don't know if the problem is at my end or is it something with Talend. Thanks for the help. I really appreciate it!