DataMigrator/Reporting Server

This content describes how to use the Web Console to configure, operate, monitor, tune, and troubleshoot the Reporting Server. It is intended for server administrators, database administrators, and application developers.

New Features Highlights

The following new features are introduced in Release 7707/82:

Adapters

• JOIN command support SSAS/Excel/Fix files combination
• Adapter for Esri ArcGIS
• Adapter for Microsoft Dynamics CRM Online
• Adapter for RStat Predictive Analysis
• Microsoft Dynamics AX 2012 Integration
• Adapter for Amazon Redshift
• Adapter for EXASOL ODBC - Extended Bulk Load
• Adapter for EXASOL ODBC
• Adapter for Google BigQuery
• Adapter for Hyperstage: Access via DataDirect ODBC Driver
• Adapter for Hyperstage: Apps to Schema Access Control
• Adapter for IBM i JDBC (Windows/Linux)
• Adapter for Jethro
• Adapter for MapR/Apache Drill
• Adapter for MariaDB
• Adapter for MariaDB supports Extended Bulk Load Utility
• Adapter for MariaDB: Change Data Capture support
• Adapter for MySQL: Change Data Capture support
• Adapter for Oracle: Bulk Load via Direct Path API
• Adapter for Oracle: XMLType support via DB_EXPR()
• Adapter for SAP HANA: NCLOB/TEXT data types support
• Adapter for SQL Server JDBC/ODBC: Version 2016 support
• Adapter for SQL Server ODBC: Linux RH6 Intel 64 support
• Adapter for Apache Phoenix JDBC access to HBase
• CREATE FILE With FOREIGNKEYS Option support
• Spatial Data Types for SQL Server/Oracle/MySQL/TD
• Optimization of Simplified Numeric Functions
• Functions: Analytical Expressions - Optimization
• MERGE option in ON TABLE HOLD clause

DataMigrator

• MERGE support via Optimized load option
• LOG/STAT as standalone csv files
• Assigning SCD columns on a synonym
• DataMigrator update values in target transformations

Reporting

• LOCALE sets to override date/currency/decimal in MFD
• SET FLOATMAPPING expands numeric functionality
• Allow mutual assignments of data formats Date-Time and Date
• Aggregation prefix operators TOTAVE, TOTMIN, TOTMAX, TOTCNT
• PARTITION_AGGR function for rolling calculations over groups of lines
• WHERE_GROUPED for screening of aggregated lines prior to COMPUTE processing

Server

• Data Assist: Binning Dialog
• Data Assist: Custom Copy - Web based data prep tool
• Data Assist: Data grid heading menu and icon
• Data Assist: Data Grouping Dialog
• Data Assist: Data Grouping via phonetic cluster - spelling corrections
• Data Assist: Data Preview on DMC and Web Console
• Data Lineage for reports
• LNGPREP Utility to Prepare for MFD Localization
• Access Control for PDS Datasets on zOS USS Server
• Kerberos and single sign-on on Linux
• Kerberos support for Hive/Cloudera. server-wide
• Kerberos support for JDBC: explicit adapter connection
• Binocular search on Web Console pages