Scenario: Filtering SQlite data - 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 describes a rather simple job which uses a select statement based on a filter to extract rows from a source SQLite Database and feed an output SQLite table.

  • Drop from the Palette, a tSQLiteInput and a tSQLiteOutput component from the Palette to the design workspace.

  • Connect the input to the output using a row main link.

  • On the tSQLiteInput Basic settings, type in or browse to the SQLite Database input file.

  • The file contains hundreds of lines and includes an ip column which the select statement will based on

  • On the tSQLite Basic settings, edit the schema for it to match the table structure.

  • In the Query field, type in your select statement based on the ip column.

  • On the tSQLiteOutput component Basic settings panel, select the Database filepath.

  • Type in the Table to be fed with the selected data.

  • Select the Action on table and Action on Data. In this use case, the action on table is Drop and create and the action on data is Insert.

  • The schema should be synchronized with the input schema.

  • Save the job and run it.

The data queried is returned in the defined SQLite file.

For an example of how to use dynamic schemas with Input components, see Scenario 4: Writing dynamic columns from a MySQL database to an output file.