Greenplum Connection and Context - Define Multiple Schemas? HELP!

[Anonymous]

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)  

[Anonymous]

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