Configuring the components - 6.5

ELT PostgreSQL

author
Talend Documentation Team
EnrichVersion
6.5
EnrichProdName
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Open Studio for MDM
Talend Real-Time Big Data Platform
task
Data Governance > Third-party systems > ELT components > ELT PostgreSQL components
Data Quality and Preparation > Third-party systems > ELT components > ELT PostgreSQL components
Design and Development > Third-party systems > ELT components > ELT PostgreSQL components
EnrichPlatform
Talend Studio

Procedure

  1. Double-click tGreenplumConnection to open its Basic settings view in the Component tab.
    In the Host and Port fields, enter the context variables for the Greenplum server.
    In the Database field, enter the context variable for the Greenplum database.
    In the Username and Password fields, enter the context variables for the authentication credentials.
    For more information on context variables, see Talend Studio User Guide.
  2. Double-click employee+statecode to open its Basic settings view in the Component tab.
    In the Default table name field, enter the name of the source table, namely employee_by_statecode.
    Click the [...] button next to the Edit schema field to open the schema editor.
    Click the [+] button to add three columns, namely id, name and statecode, with the data type as INT4, VARCHAR, and INT4 respectively.
    Click OK to close the schema editor.
    Link employee+statecode to tELTGreenplumMap using the output employee_by_statecode.
  3. Double-click statecode to open its Basic settings view in the Component tab.
    In the Default table name field, enter the name of the lookup table, namely statecode.
  4. Click the [...] button next to the Edit schema field to open the schema editor.
    Click the [+] button to add two columns, namely state and statecode, with the data type as VARCHAR and INT4 respectively.
    Click OK to close the schema editor.
    Link statecode to tELTGreenplumMap using the output statecode.
  5. Click tELTGreenplumMap to open its Basic settings view in the Component tab.
    Select the Use an existing connection check box.
  6. Click the [...] button next to the ELT Greenplum Map Editor field to open the map editor.
  7. Click the [+] button on the upper left corner to open the table selection box.
    Select tables employee_by_statecode and statecode in sequence and click Ok.
    The tables appear on the left panel of the editor.
  8. On the upper right corner, click the [+] button to add an output table, namely employee_by_state.
    Click Ok to close the map editor.
  9. Double-click tELTGreenplumOutput to open its Basic settings view in the Component tab.
    In the Default table name field, enter the name of the output table, namely employee_by_state.
  10. Click the [...] button next to the Edit schema field to open the schema editor.
    Click the [+] button to add three columns, namely id, name and state, with the data type as INT4, VARCHAR, and VARCHAR respectively.
    Click OK to close the schema editor.
    Link tELTGreenplumMap to tELTGreenplumOutput using the table output employee_by_state.
    Click OK on the pop-up window below to retrieve the schema of tELTGreenplumOutput.
    Now the map editor's output table employee_by_state shares the same schema as that of tELTGreenplumOutput.
  11. Double-click tELTGreenplumMap to open the map editor.
    Drop the column statecode from table employee_by_statecode to its counterpart of the table statecode, looking for the records in the two tables that have the same statecode values.
    Drop the columns id and name from table employee_by_statecode as well as the column statecode from table statecode to their counterparts in the output table employee_by_state.
    Click Ok to close the map editor.
  12. Double-click tGreenplumInput to open its Basic settings view in the Component tab.
    Select the Use an existing connection check box.
    In the Table name field, enter the name of the source table, namely employee_by_state.
    In the Query field, enter the query statement, namely "SELECT * FROM \"employee_by_state\"".
  13. Double-click tLogRow to open its Basic settings view in the Component tab.
    In the Mode area, select Table (print values in cells of a table for a better display.