Greenplum Connection and Context - Define Multiple Schemas? HELP!

Anonymous — Tue, 26 Jul 2016 15:22:37 GMT

Hi! I am sort of a newbie. I have struggled my way (successfully) so far doing all the things I have been trying to do... until NOW.
Help. I have a connection to a Greenplum that holds several databases and within those several schemas then hundreds of tables. I want to use one connection to this and connect to a few schemas to get data. I am trying to map the newly added data into an Oracle instance for some other applications. In the tGreenplumInput_1, Basic Settings tab, I cannot get my Table and it seems that the schema I need has not been defined in this context. I see other things. So:
1. Is it possible to define multiple schemas into a context? (If so, HOW??)
2. If not, do I need to define multiple contexts, one for each schema in the database?
3. OR is it that this connection to Greenplum, which has many databases, many schemas, and many many tables, is just so big that there is a limit to what is defined in the context?
Thanks for your help.
Jackie (a.k.a. Pastthesun)

Re: Greenplum Connection and Context - Define Multiple Schemas? HELP!

Anonymous — Wed, 27 Jul 2016 05:13:57 GMT

Hi,
If you often need to connect to database tables of any kind, then you may want to centralize the connection information details in the Metadata folder in the Repository tree view.
Have you already checked documents about: TalendHelpCenteretting up a database connection and TalendHelpCenter:Retrieving table schemas?
It is impossible to design multiple schemas into a context.
Talend peovides Dynamic schema feature which is only available in Talend Enterprise subscription. It allows you to design schema with an unknown column structure (unknown name and number of columns).

Best regards
Sabrina

topic Greenplum Connection and Context - Define Multiple Schemas? HELP! in Talend Studio

Greenplum Connection and Context - Define Multiple Schemas? HELP!

Re: Greenplum Connection and Context - Define Multiple Schemas? HELP!