ibi™ Data Migrator builds, manages, and optimizes modern enterprise data ecosystems, enabling fast, flexible, end-to-end ETL process creation across computing platforms from on-premise to cloud. It simplifies data integration and supports data access requirements associated with analytics, reporting, data management, and artificial intelligence. With ibi™ Data Migrator, you can automate the creation and management of data warehouses and data marts. You can also access source data in various formats and operating systems, integrate multiple data sources into single or multiple targets, apply powerful data cleansing rules and logic, and create roll-ups to help make decisions. The software offers specialized high volume data warehouse loaders, allows you to schedule data updates at user-defined intervals triggered by events or conditional dependencies, load star schema with slowly changing dimensions, and monitor and manage essential server functions. Extensive logging and transaction statistics provide better understanding of your data operations. It is a proper client/server middleware solution with transparent underlying communications protocols and data source subsystems. Supporting ibi Data Migrator operations and design elements, the ibi WebFOCUS® Reporting Server manages and executes data and process flow.

Features:

• Optimal data storage: Optimize your data warehouse(s) to ensure data is stored in a more readable format for analysis and cleansing.
• Reduced load on legacy systems: Because your analysts no longer access operational data sources, their complex queries do not impede or slow production systems.
• Improved response and ownership: Install your data warehouse on premise or in the cloud, can be installed on one or many departmental machines, each with summary information specific to the department. You no longer need to scour the network for your data.
• Improved data flow: Supporting ibi Data Migrator operations and design elements, the ibi WebFOCUS® Reporting Server manages and executes data and process flow.
• Data Management console: The system's graphical user interface allows you to design, test, and execute data and process flows.
• Total access with REST API: Using the REST API, start or stop ETL Flows, manage or retrieve information about scheduled flows, and obtain statistics about the execution of a flow from any application in your organization.