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
Optimal Data Storage

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

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 & Ownership

Improved Response & Ownership

The data warehouse 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

Improved Data flow

Supporting ibi™ Data Migrator operations and design elements, a TIBCO WebFOCUS® Reporting Server manages and executes. data and process flow.

Data Management Console

Data Management Console

The system's graphical user interface runs on Microsoft® Windows® and allows you to design, test, and execute data and process flows.

Simple Server Web Console

Simple Server Web Console

The system's server web console comes pre-installed and supports administrative tasks through a browser.

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.