barbosa.alvaro Posted September 8, 2017 Share Posted September 8, 2017 Hi, I need to make an ETL, but the tables name are variable, MOVPRD0917,MOVPRD1017,MOVPRD1117...Is there any way to do this automatically, without need do table by table. Thanks Link to comment Share on other sites More sharing options...
dnaboka Posted September 16, 2017 Share Posted September 16, 2017 Hi,Try using tJDBCTableList to filter the tables. Here is an example job:http://community.jaspersoft.com/wiki/etl-query-multiple-tables-single-tpostgresqlinput-using-tjdbctablelist-regex-filter-table-names 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