Preparing context parameter sources - 6.4

Talend Open Studio for Big Data User Guide

EnrichVersion
6.4
EnrichProdName
Talend Open Studio for Big Data
task
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.