Outputting the result of the preparation into a database - 7.1

Data Preparation

author
Talend Documentation Team
EnrichVersion
Cloud
7.1
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 Real-Time Big Data Platform
task
Data Governance > Third-party systems > Data Preparation components
Data Quality and Preparation > Third-party systems > Data Preparation components
Design and Development > Third-party systems > Data Preparation components
EnrichPlatform
Talend Data Preparation
Talend Studio

Procedure

  1. In the design workspace, select tRedshiftOutput and click the Component tab to define its basic settings.
  2. In the Property Type list, select Built-in to set the database connection details manually.
  3. In the Host, Port, Database, Schema, Username and Password fields, enter the Redshift connection details and the user authentication data for the database, between double quotes
  4. To fill the Table field, with the expression that will dynamically reuse the input file name and give it to the table, drag it from the tFileList_2 list of expressions in the Outline panel.
  5. From the Action on table drop-down list, select Create table if does not exist.
  6. From the Action on data drop-down list, select Insert.
  7. Click Sync columns to retrieve the new output schema, inherited from the tDataprepRun component.