Preparing context parameter sources - 6.2

Talend Data Fabric Studio User Guide

EnrichVersion
6.2
EnrichProdName
Talend Data Fabric
task
Data Quality and Preparation
Design and Development
EnrichPlatform
Talend Studio

Create two tables named db_testing and db_production respectively in a MySQL database named db_connections, to hold the connection parameters for accessing the above mentioned databases, testing and production. Each table should contain only two columns: key and value, both of type VARCHAR. Below is an example of the content of the database tables:

db_testing:

keyvalue
hostlocalhost
port3306
usernameroot
passwordtalend
databasetesting

db_production:

keyvalue
hostlocalhost
port3306
usernameroot
passwordtalend
databaseproduction

You can create these database tables using another Talend Job that contains tFixedFlowInput and tMysqlOutput components. For how to use these components, see the Talend Components Reference Guide.