Reading data from a database table - 6.4

MemSQL

author
Talend Documentation Team
EnrichVersion
6.4
EnrichProdName
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Open Studio for Big Data
Talend Real-Time Big Data Platform
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
EnrichPlatform
Talend Studio

Procedure

  1. Double-click tMemSQLInput to open its Basic Settings view in the Component tab.
  2. Select the Use Existing Connection check box. The Component List is filled in automatically with tMemSQLConnection_1.
  3. Set the Schema as Built-in and click Edit schema to define the data structure of the database table to read data from.
    Click the [+] button to add the rows that you will use to define the schema, three columns in this example id, firstName, and lastName.
    Under Column, click in the fields to enter the corresponding column names.
    Click the field under Type to define the type of data.
    Click OK to close the schema editor.
  4. Fill the Table field with the database table, customers in this example.
    Alternatively, click the [...] button next to the Table Name field to select the database table of interest. A dialog box opens showing a tree diagram of all the tables in the selected database. Select customers and click OK to close the dialog box.
  5. Set the Query Type as Built-In. Click the Guess Query button. The Query box is filled in automatically to retrieve all columns from the selected table.
  6. Double-click tLogRow to set its Basic settings in the Component tab.
  7. In the Mode area, select Table (print values in cells of a table) for a better display of the results.
  8. Save the Job.