Seven Stars

How to Move Talend metadata from public schema to private schema

Hi folks,

During installation of Talend we have provided the db with public repository.

We wish to move the tables created in the public schema to private schema and also we need to use private schema only here after. 

how to change the schema db configuration page on TAC. I have added the connection string in this way "jdbc: postgresql://hostname: port/database/schema". Is this the correct method? if not could you suggest the right way to add schema name with the database name

database name: talend

private schema name: dq

db config on TAC_LI (2).jpg

I have checked dq schema is there in postgresSQL

could please share your information.

Note: This is urgent requirement

RAJESH J
1 ACCEPTED SOLUTION

Accepted Solutions
Ten Stars

Re: How to Move Talend metadata from public schema to private schema

check:

- version of PostgreSQL (before 9.4 string little different), You could test it with 

jdbc:postgresql://host:5432/database?searchpath=schema


- permissions

 

as You can see from pictures - all work as expected:

Screen Shot 2018-02-05 at 1.31.49 PM.png

 

2nd picture - show new tables in schema dev, created by Talend

Screen Shot 2018-02-05 at 1.32.00 PM.png

-----------
10 REPLIES
Ten Stars

Re: How to Move Talend metadata from public schema to private schema

I can not test it right now (server production)

but You can test

 

jdbc:postgresql://host:5432/YourDB?currentSchema=YourSchema

 

-----------
Seven Stars

Re: How to Move Talend metadata from public schema to private schema

Hi
I tried your solution. It's not working.
RAJESH J
Ten Stars

Re: How to Move Talend metadata from public schema to private schema

unfortunately - could not comment, because not see what You full settings

-----------
Seven Stars

Re: How to Move Talend metadata from public schema to private schema

Hi vapukov,

 

Thank you very much for your prompt response. I tried below command.

 

jdbc: postgresql://dwh.cortobddhensa.ap-south-1.rds.amazonaws.com:5432/talend?currentSchema=dq

jdbc: postgresql://dwh.cortobvddhensa.ap-south-1.rds.amazonaws.com:5432/talend?dq

 

hostname: dwh.cortobddhensa.ap-south-1.rds.amazonaws.com

database name: talend

schema name: dq

RAJESH J
Ten Stars

Re: How to Move Talend metadata from public schema to private schema

check:

- version of PostgreSQL (before 9.4 string little different), You could test it with 

jdbc:postgresql://host:5432/database?searchpath=schema


- permissions

 

as You can see from pictures - all work as expected:

Screen Shot 2018-02-05 at 1.31.49 PM.png

 

2nd picture - show new tables in schema dev, created by Talend

Screen Shot 2018-02-05 at 1.32.00 PM.png

-----------
Seven Stars

Re: How to Move Talend metadata from public schema to private schema

Hi vapukov,

The information you provided me is of immense help. Thanks for your quick response

RAJESH J
Four Stars

Re: How to Move Talend metadata from public schema to private schema

@vapukov : Hi, 

jdbc:postgresql://host:5432/database?currentschema=schema

 This URL checks out. 

However the tables are not created in the specified private schema. We tried manually moving all the tables from public to private schema and changed the url in tac and tried making changes in tac. The changes are still captured in public schema and it is not getting reflected in private schema even after changing the url connection string.

Ten Stars

Re: How to Move Talend metadata from public schema to private schema


gautam_srinivas wrote:

@vapukov : Hi, 

jdbc:postgresql://host:5432/database?currentschema=schema

 This URL checks out. 

However the tables are not created in the specified private schema. We tried manually moving all the tables from public to private schema and changed the url in tac and tried making changes in tac. The changes are still captured in public schema and it is not getting reflected in private schema even after changing the url connection string.


Smiley Happy


check all information above ... it is work 

-----------
Ten Stars

Re: How to Move Talend metadata from public schema to private schema

what exactly PostgreSQL are You use?

-----------
Seven Stars

Re: How to Move Talend metadata from public schema to private schema

Hi
Currently we are using PostgreSQL 9.6 version.
RAJESH J