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
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
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.
Optimal Data Storage
Reduced Load on Legacy Systems
Improved Response & Ownership
Improved Data flow
Data Management Console
Simple Server Web Console
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.