tMysqlLookupInput - 6.3

Talend Open Studio for Big Data Components Reference Guide

EnrichVersion
6.3
EnrichProdName
Talend Open Studio for Big Data
task
Data Governance
Data Quality and Preparation
Design and Development
EnrichPlatform
Talend Studio

Function

tMysqllookupInput reads a MySQL database and extracts fields based on a query.

This component also allows you to connect and read data from a RDS Aurora or a RDS MySQL database.

Purpose

tMysqlLookupInput executes a database query with a strictly defined order which must correspond to the schema definition.

It passes on the extracted data to tMap in order to provide the lookup data to the main flow. It must be directly connected to a tMap component and requires this tMap to use Reload at each row or Reload at each row (cache) for the lookup flow.