Writing data in a database table - 7.1

MemSQL
EnrichVersion
7.1
EnrichProdName
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Open Studio for Big Data
Talend Real-Time Big Data Platform
EnrichPlatform
Talend Studio
task
Data Governance > Third-party systems > Database components > MemSQL components
Data Quality and Preparation > Third-party systems > Database components > MemSQL components
Design and Development > Third-party systems > Database components > MemSQL components

Procedure

  1. Double-click the tRowGenerator component to open the Row Generator editor.
  2. Add three columns as shown below to generate 10 data rows:

    • id, Integer type, using Numeric.sequence from the Function list to generate sequence numbers.

    • firstName, String type, using TalendDataGenerator.getFirstName from the Function list to generate random first names.

    • lastName, String type, using TalendDataGenerator.getLastName from the Function list to generate random family names.

  3. In the Basic settings view of tRowGenerator in the Component tab, click the Edit Schema button to open the schema editor. Set the length of the id, firstName, lastName column to 4, 10, and 10.
    When done, click OK to close the editor and click Yes when prompted to propagate the schema to the next component.
    For more information about how to configure the tRowGenerator component, see tRowGenerator.
  4. Double-click tMemSQLOutput to open its Basic Settings view in the Component tab.
  5. Select the Use Existing Connection check box. The Component List is filled in automatically with tMemSQLConnection_1.
    Fill the Table field with the database table, customers in this example.
    Select Drop table if exists and create in the Action on table list, and Insert in the Action on table list.