Scenario: Bulk-loading data to a Sybase IQ 12 database - 6.1

Talend Components Reference Guide

EnrichVersion
6.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 Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for Data Quality
Talend Open Studio for ESB
Talend Open Studio for MDM
Talend Real-Time Big Data Platform
task
Data Governance
Data Quality and Preparation
Design and Development
EnrichPlatform
Talend Studio

This scenario saves data from a tRowGenerator to a file and then bulk-loads the data to a Sybase IQ 12 database.

Linking the components

  1. Drop tRowGenerator and tSybaseIQOutputBulkExec onto the workspace.

  2. Link tRowGenerator to tSybaseIQOutputBulkExec using a Row > Main connection.

Configuring the components

  1. Double-click tRowGenerator to open its schema editor.

  2. Click the [+] button to add two columns, namely id and name.

  3. Select the type for id and name, respectively int and String.

  4. Set the length for id and name, respectively 4 and 30.

  5. Select the function for id and name, respectively Numeric.sequence and TalendDataGenerator.getFirstName.

  6. Click Ok to close the editor and click Yes on the pop-up below to propagate changes:

  7. Double-click tSybaseIQOutputBulkExec to open its Basic settings view.

  8. In the Host and Port fields, enter the connection details.

  9. In the Database field, enter the database name.

  10. In the Username and Password fields, enter the authentication credentials.

  11. In the Table field, enter the table name.

  12. In the Action on table list, select Create table if not exists.

  13. In the Filename field, enter the full path of the file to hold the data.

Executing the Job

  1. Press Ctrl+S to save the Job.

  2. Press F6 to run the Job.

  3. In the Sybase Central console, open the table staff to check the data:

    As shown above, the table is created with data inserted.