ibi™ Data Migrator Software

Simplify and automate data extraction and integration

ibi™ Data Migrator software is part of a group of tools for simplifying and automating extraction and integration of data from various sources. Data is transformed using business rules at various points throughout the process, from source extraction to target load.

Benefits
Automate, transform, and save time

Automate, transform, and save time

Automate creating and managing 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.

Greater flexibility & value

Greater flexibility & value

Use specialized high volume data warehouse loaders, 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.

Logging for greater insight

Logging for greater insight

Better understand your data operations with extensive logging and transaction statistics. You get a proper client/server middleware solution with transparent underlying communications protocols and data source subsystems.

Capabilities
What's New

Data Migrator 9.2 provides a series of exciting new features in the product.

Now, access Data Migrator functions from any of your applications via a new 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. Performance improvements were made to speed up ETL flows and common table expressions (CTE). Temporary named result sets created from a Select statement that can be used in a subsequent Select statement can now be used to simplify and speed up SQL requests when the same sub-select is used multiple times. We extended the Notes feature to allow you to add general notes to the canvas, and enhanced the Data Lineage report to provide information for sub-selects, UNION, correlated sub-selects and CTEs allowing for a more complete picture of the data lineage of a column. 

Upgrade to Data Migrator 9.2 to take advantage of these great new features.