Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2009-04-29 04:31 AM

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
Labels (2)
Labels
264 Views
0 Likes
4 Replies
Anonymous
Not applicable
‎2009-04-29 12:06 PM
Author

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.
264 Views
0 Likes
Anonymous
Not applicable
‎2009-04-29 12:52 PM
Author

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
264 Views
0 Likes
Anonymous
Not applicable
‎2009-04-30 02:25 AM
Author

Hello
SID is the database name and the default value of schema is public.
Best regards
shong
264 Views
0 Likes
Anonymous
Not applicable
‎2009-04-30 04:45 AM
Author

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