topic Re: DbConnection-PostgreSQL-what shall I write for "schema" and "sid" in Talend Studio

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

Anonymous — Sat, 16 Nov 2024 13:58:35 GMT

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"

Anonymous — Wed, 29 Apr 2009 16:06:03 GMT

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.

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

Anonymous — Wed, 29 Apr 2009 16:52:16 GMT

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

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

Anonymous — Thu, 30 Apr 2009 06:25:38 GMT

Hello
SID is the database name and the default value of schema is public.
Best regards
shong

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

Anonymous — Thu, 30 Apr 2009 08:45:08 GMT

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