is possible to do auto-guess schema in JaspersoftETL

Hello. im developing an ETL process using JaspersoftETL 5.6.2 Community version. What im trying to do is to extract a database from different server and save it to a diffrent server.

For example: Server A have a database with tables and data. Server B have an empty database, no table at all. I want to extract all the table including its content to server B using ETL process. i want to make it as short as possible. There is a total of 300++ tables to be extracted. 

Both server are using PostgreSQL. i manage to retrieve the list of tables that i want using SQL command at the tPostgresqllnput_1 component. The list of names will then act as an iteration to another tPostgresqlInput_2 component. Which will perform row insertion to a tPostgresqlOutput component. the tPostgresqlOutput will also been set with "create table if not exist" on the 'Action on table' option. i hope i explain it clear enough. tPostgresqlInput_2 component schema needs to be dynamic. so it will change its schema based on the original schema on server A. can this be achieved?

here is a screenshot of what i have done so far:

WarOne's picture
Joined: Mar 15 2015 - 6:05pm
Last seen: 6 years 2 months ago

1 Answer:

It seems that can be easier done if you just write a program using JDBC. Jaspersoft ETL (Talend ETL) just generates Java codes. If the job is complex and if you know Java, I find it faster to just code in Java rather than try to use ETL.

hozawa's picture
Joined: Apr 24 2010 - 4:31pm
Last seen: 3 years 11 months ago