Creating and Populating Tables in Talend Open Studio

Creating and Populating tables without using the dynamic schema in Talend Open Studio

Creating tables from one database to another database without using dynamic schema concept. Creation of tables and insertion of data needs to happen in one Job itself. There is a tSetDynamicSchema component in Talend Enterprise Edition but this component is not available in Open Studio.

So the other method to use dynamic schema is as follows:

Create 3 delimited Files

1. File Containing table names to be created

For example:
TableName
Emp
Dept
Sal
And so on

2. File containing create scripts

For example:
TableName;Create
Emp;create table Emp……
Dept;…..

3. File containing insert scripts

For example:
TableName;insert
Emp;insert script ….
Dept;…….

Steps to create a job:

1. In Repository Right Click on the Job Design and create a job
2. Create three delimited files



3. Drop Three delimited files from Repository, three tFlowToIterate and three tDBRow components from a palette on to the workspace.
4. And provide the link from one component to another below as diagram.

(Note: Right Click on tFlowToIterate and give a link as “Iterate”)




5. Provide the required connection details either Repository or Built-in in tDBRow component. And provide the global variables by pressing CTRL+SPACE in place of Table name in the component settings as follows:

tDBRow :drop




tDBRow:create




tDBRow:Insert




6. Run the Job(Execution)
7. Then check the output in the given DB connection

Best Open Source Business Intelligence Software Helical Insight is Here

A Business Intelligence Framework

Free
Download

In Case if you have any queries please get us at support@helicaltech.com

Thanks
Vijaya
Helical IT Solutions Pvt Ltd