DbConnection-PostgreSQL-what shall I write for "schema" and "sid"

One Star

DbConnection-PostgreSQL-what shall I write for "schema" and "sid"

Hi,
I'm beginner in Talend.
I'd like to know how to configure my PostgreSQL DbConnection.
What shall I put for schema and sid?
Is the sid field mandatory?
Thanks,
Mathieu

Re: DbConnection-PostgreSQL-what shall I write for "schema" and "sid"

you will need to put the correct values for the Schema and SID from your postgres install. These values are defined at the database level. if you have a DBA, they can help you get the correct values.
One Star

Re: DbConnection-PostgreSQL-what shall I write for "schema" and "sid"

I think we're more in the postgreSQL field now whereas it's a forum for talend but may I ask you how to get the SID and schema values?
Can I get them through pgadmin?
Regards,
Mathieu
Community Manager

Re: DbConnection-PostgreSQL-what shall I write for "schema" and "sid"

Hello
SID is the database name and the default value of schema is public.
Best regards
shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: DbConnection-PostgreSQL-what shall I write for "schema" and "sid"

I didn't know SID was the database name.
Thanks for the answer,
mathieu