DataMigrator

This content describes how to install and use DataMigrator to stage data for analysis with WebFOCUS and other purposes. It is intended for users responsible for transforming data by designing and executing data and process flows.

DataMigrator is a suite of software components that automates the process of building and maintaining a data warehouse or data mart. Using DataMigrator, you can perform actions, such as:

• Access source data in numerous formats and operating systems.
• Integrate multiple data sources into a single target or multiple data targets.
• Apply powerful data cleansing rules and transformation logic.
• Monitor and manage key server functions.

Key Features

The following new features were introduced in Release 7709:

• Built-in Statistical Python Functions. From a WebFOCUS COMPUTE command, you can call newly built-in Python scripts, that perform classification and regression using several techniques.
• Data Management Console. New functions, such as median and mode, are available.
• Improved Optimization of MATCH Logic for SQL Adapters. Streamlined SQL is now generated for MERGE requests against those adapters, such as Spark, whose INSERT statement does not support a list of columns.
• New Functions. New functions COALESCE. COMPACTFORMAT, INITCAP, GET_TOKEN, GIS_REVERSE_COORDINATE, and NULLIF have been added.
• IF-THEN-ELSE Logic. IF-THEN-ELSE logic is now supported within an expression.
• Abbreviated Numeric Format Options. Display options, such as K, have been added for displaying numeric values in an abbreviated format.