IBM has announced a new product offering in the DB2 Web Query family portfolio.
DB2 Web Query DataMigrator ETL Extension (i.e. DataMigrator) provides extract, transformation, and load (ETL) capabilities integrated with DB2 Web Query and DB2 for i.
Users looking to isolate their query workloads from production environments, or needing to automate the consolidation of data from a variety of data sources will be interested in this solution.
DataMigrator allows you to automate the process of extracting data from any DB2 Web Query supported source database, the process of transforming or cleansing the data and loading the data into an optimized DB2 for i reporting repository. Depending on the design and use of that repository, the industry refers to this as an operational data store, data mart, or data warehouse.
While leveraging the same graphical look and feel of DB2 Web Query, there are also integration points with DB2 Web Query. For instance, synchronize meta data defined either in DataMigrator or DB2 Web Query.
For more information, refer to the following documents:
IBM US Announcement
IBM Europe, Middle East, and Africa Announcement
Frequently Asked Question document
If you need assistance with architecture, design or implementation of your analytics environment running in IBM i, please reach out - we are here to make you successful!