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

Highlighted
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
Highlighted

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.
Highlighted
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
Highlighted
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

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog