Solution for Automatic Migration of
Integration Jobs from one Technology to Another
You want to migrate to the cloud or simply change integration technology?
But you are stuck on hundreds if not thousands of ETL routines written on the old technology stack?
The solution might be just couple of clicks away!
Our solution, EPIC Ingenioso, does just that. It automatically converts ETL routines from one technology to another. On the source side, we support integration technologies such as IBM DataStage or Oracle Data Integrator. And of course, all sorts of stored procedures and SQL. Using integration tools repository, EPIC lngenioso parses jobs written in IBM Datastage, Oracle Data Integrator or technology specific SQL. It then stores meta information about the job in our proprietary generic format. Using this format, it can then generate jobs in target technologies such as ODI, ANSI SQL based stored procedures and others.
On the target side, except forementioned technologies like ODI or SQL, we support state of the art cloud solutions such as Snowflake or BigQuery.
But EPIC Ingenioso is more than just a migration tool! EPIC Ingenioso can be used to automate generating ETL from scratch. Our proprietary generic format is basically spreadsheet where a job is specified. From it we automatically generate the job in target technology. So, after finishing specification, you immediately have the implementation and documentation! In such way, EPIC Ingenioso drastically reduces costs of changing integration technology. Without it, all the jobs should be manually developed in target technology. Using EPIC lngenioso, manual work can be reduced only to those original jobs which need to be reengineered anyway.