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 ,since your getting permissions denied error on database side right? when you were loading data into database,the user might have not permissions to load the data into that table. if you have created that table,you need to provide Grant access to that table ,the user which you were using.

[Anonymous]

Now it is showing another error that the table I am trying to import from data source does not exist, whereas I checked the data source myself and the table does exist. 

While making the DBConnection, do I need to enter the 'schema' field? 

[manodwhb]

@Harguna ,yes you need to specify schema also.

[Anonymous]

This is the error I am getting:

Screenshot 2019-02-07 at 4.39.03 PM.png

[manodwhb]

@Harguna ,can you show me configuration of tDBInput?

[manodwhb]

@Harguna ,you may have that table in different schema.check below case will be useful.

https://stackoverflow.com/questions/36753568/postgresql-tables-exists-but-getting-relation-does-not-...

[Anonymous]

But I have already mentioned the schema in the query, screenshot attached.

Screenshot 2019-02-07 at 4.51.54 PM.png

[manodwhb]

@Harguna ,the schema is public and database is ben_13.

[Anonymous]

I have already mentioned that but the error still exists.

[manodwhb]

@Harguna ,if you are sure about the schema then could be problem with grant access on that table to the user,which you were using.