Configuring the components - 7.0

Sybase

author
Talend Documentation Team
EnrichVersion
7.0
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 > Database components > Sybase components
Data Quality and Preparation > Third-party systems > Database components > Sybase components
Design and Development > Third-party systems > Database components > Sybase components
EnrichPlatform
Talend Studio

Procedure

  1. Double-click the tRowGenerator component to open its RowGenerator Editor.
  2. Click the [+] button to add two columns and set their properties:
    • id, Integer type, using Numeric.sequence(String,int,int) from the Functions list to generate sequence numbers.

    • name, String type, using TalendDataGenerator.getFirstName() from the Functions list to generate random first names.

  3. In the Number of Rows for RowGenerator field, enter the number of rows to be generated. In this example, keep the default value 100.
  4. Click OK to close the editor and in the pop-up dialog box click Yes to propagate the schema to the next component.
  5. Double-click the tSybaseIQOutputBulkExec component to open its Basic settings view.
  6. In the Host, Port, Database, Username and Password fields, enter the information required to access the Sybase IQ 12 database.
  7. In the Table field, enter the name of the table into which the data will be writen. In this example, it is staff.
  8. In the Action on table list, select Create table if not exists.
  9. In the Filename field, enter the full path of the file to hold the data.