Jump to content
Changes to the Jaspersoft community edition download ×

is possible to do auto-guess schema in JaspersoftETL


WarOne

Recommended Posts

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:

asdasdasd.png.976fd9f2e06275d42f53aa3dbb271eae.png

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Posted Images

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.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...