Creating the Job and defining context variables - 6.5

Data Integrationジョブの例

author
Talend Documentation Team
EnrichVersion
6.5
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 ESB
Talend Open Studio for MDM
Talend Real-Time Big Data Platform
task
ジョブデザインと開発 > ジョブデザイン
EnrichPlatform
Talend Studio

Before you begin

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:

key value
host localhost
port 3306
username root
password talend
database testing

db_production:

key value
host localhost
port 3306
username root
password talend
database production

You can create these database tables using another Talend Job that contains tFixedFlowInput and tMysqlOutput components.

Procedure

  1. Create a Job and add a tMysqlInput component and a tLogRow component onto the design workspace, and link them using a Row > Main connection.
  2. Select the Contexts view of the Job, and click the [+] button at the bottom of the view to add five rows in the table to define the following variables, all of type String, without defining their values, which will be loaded dynamically at Job execution: host, port, username, password, and database.
  3. Now create another variable named db_connection of type List Of Value.
  4. Click in the Value field of the newly created variable and click the button that appears to open the Configure Values dialog box, and click New... to open the New Value dialog box. Enter the name of one of the database tables holding the database connection details and click OK.
  5. Click New... again to define the other table holding the database connection details. When done, click OK to close the Configure Values dialog box.

    Now the variable db_connection has a list of values db_testing and db_production, which are the database tables to load the connection parameters from.

  6. Select the Prompt check box next to the Value field of the db_connection variable to show the Prompt fields and enter the prompt message to be displayed at the execution time.