Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm new to the Talend universe and I try to use it for migrating data from one postgres DB to another one the problem is that my new one has multiple schema (other then the public one) and when I create a connection to my database I can get all the tables insides all schemas, but when I want to use one of those table, the schema metadata property in the component is empty and every time I want to use a table I've to click the component go inside the component tab click on the schema case say I want to switch to build-in mod and then set a value for the schema metadata, without that I will get an error saying the my table (for exemple user do not exist).
Am I doing something wrong? Is they-re a way to do it more efficiently?
Regards.
I somehow find a way to handle my problem it was a real pain in the a** so I write it here if someone someday encounter the same problem.
my solution is simply to create a db connection for each schema on the database and organise them by database inside folder
I somehow find a way to handle my problem it was a real pain in the a** so I write it here if someone someday encounter the same problem.
my solution is simply to create a db connection for each schema on the database and organise them by database inside folder