WarOne Posted May 13, 2016 Share Posted May 13, 2016 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: Link to comment Share on other sites More sharing options...
hozawa Posted May 13, 2016 Share Posted May 13, 2016 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now