|
|
|
|
|
|
As Information Technology evolved over the years, organizations deployed numerous software applications to manage their day to day business operations. Even with the advent of enterprise systems and ERPs, most companies still possess numerous information systems usually deployed on different technological platforms. This often poses challenges in extracting disparate data sets and combining them in order to view meaningful information
ETL abbreviated for Extract Transform and Load enables organizations to extract data from numerous data sources, reformat, cleanse and load it into CUBOT for analysis and reports.
|
|
|
|
|
-
Native ETL tool. CUBOT uses its own native ETL tool and does not depend on integration with 3rd party tools.
-
Supports numerous data sources.
Supports all common data sources including text files, spreadsheets, XML®, ODBC or JDBC compliant databases.
-
Scheduler. ETL tasks can be scheduled from the browser to start automatically at a pre-defined time.
-
Easy mapping and transfer.
Easy table to table mapping and data transfer using the GUI without the need to write SQL statements.
-
Inbuilt ETL monitor. Monitor the ETL process using the inbuilt ETL monitor. Get alerted by email on task failures.
|
|
|
|
|
|
-
Easy to use.
Intuitive browser based application that does not require lengthy user training. Most administrators can be trained to use CUBOT ETL within a matter of hours.
-
Cost effective. As ETL is a part of the CUBOT product stack, there is no need to invest in expensive 3rd party tools.
-
No programming. Requires little or no programming unlike most other applications. No knowledge of SQL is required to configure ETL.
-
Extendable. Easily extendable to include additional data sources.
|
|
|
|
|
|
|
|
