x

All Adapters - Version 7 Release 7.06

• Changing Common Adapter Settings. The Web Console Adapters page has a new button in the Troubleshooting group, labeled Change common adapter settings, that allows you to customize data type mappings and other miscellaneous settings that are common to all adapters. Adapter-specific settings are customizable by right-clicking a configured adapter folder and selecting Change Settings from the context menu.

x

Release 7.7 Version 06

All SQL Adapters

• Creating Indexes for an Existing Table. When you issue a CREATE FILE command for a table, an index is created in the relational DBMS for the primary key and for each index specified in the Access File. If you want to create a table without creating all of the indexes at that time, you can omit the index declarations from the Access File and issue the CREATE FILE command to create only the table and the index on the primary key. Then, at a later time, you can add the index declarations to the Access File and issue the CREATE FILE command with the INDEXESONLY phrase. The option of adding the indexes later makes loading data into a relational table much faster.
• Optimization of Full Outer Joins. The WebFOCUS join command and conditional join command now have a FULL OUTER join option.
• Adding a New Fact To Multi-Fact Synonyms: JOIN AS_ROOT. The JOIN AS_ROOT command adds a new fact table as an additional root to an existing fact-based cluster (star schema). The source Master File has a parent fact segment and at least one child dimension segment. The JOIN AS_ROOT command supports a unique join from a child dimension segment (at any level) to an additional fact parent.
• Joining From a Multi-Fact Synonym. Multi-parent synonyms are now supported as the source for a unique join to a single segment in a target synonym.
• Improved Handling of a Star Schema With Fan Trap. A new context analysis process has been introduced in this release that detects the multiplicative effect and generates SQL script commands that retrieve the correct values for each segment context. These scripts are then passed to the RDBMS as subqueries in an optimized SQL statement.
• Support for Discontiguous Key Definition in the Access File. Key fields in the Master File can be listed in the order established by the relational DBMS or in any order that is convenient. New syntax is available that does not require reordering of the fields in the Master File.
• Optimization of Simplified Character Functions. The SUBSTRING, LTRIM, RTRIM, TRIM_, CHAR_LENGTH, LOWER, POSITION, and UPPER simplified functions are optimized to SQL.
• Optimization of Simplified Date and Date-Time Functions. The DTPART, DTRUNC, DTADD, and DTDIFF functions have been optimized for SQL adapters, as reflected in the SQL Optimization Report.
• Optimization of Legacy Character and Numeric Functions. The TRIMV function with the L/B (left/both) option, TRIM, ARGLEN, and POWER functions have been optimized.
• Optimization of Date and Date-Time Functions. You can determine which functions are optimized to their SQL counterparts by adapter in the SQL Optimization Report available from the Web Console.
• Automatically Generating FORMAT SQL_SCRIPT for HOLD Files. This feature allows the specification for temporary HOLD file formats to be SQL_SCRIPT. It affects all ON TABLE HOLD requests that do not have an explicit format specified. It also enables you to convert procedures from disk HOLD files to SQL HOLD files through a single SET command.
• Amper Variables for SQLTAG and ABORTREPORT Settings. Variables that hold the values of SQLTAG and ABORTREPORT settings have been added.
• Extended Bulk Load Support for the ON TABLE HOLD Clause. When using HOLD with a FORMAT of a SQL database, a new option enables you to use a bulk load procedure to load the table.

Adapter for DB2 - Version 7 Release 7.06

• Case-Insensitive Filtering. Setting server collation (either as SET COLLATION=SRV_CI or under the NLS configuration) triggers the underlying i5 DB2 to also be case-insensitive for local IBM i DB2 connections.

Adapter for C9 INC - Version 7 Release 7.06

• The Adapter for C9 INC has been introduced in this release and is available as a named adapter on the Web Console in the SQL folder. It provides read access to Salesforce data stored in C9 and supports C9 temporal features by generating fields in the Master File with temporal properties.

Adapter for Greenplum - Version 7 Release 7.06

• Extended Bulk Load Support. DataMigrator supports Extended Bulk Load for EMC Greenplum using the Greenplum Load Utility, gpload. This provides a faster load option than insert/update.
• Unicode Support. The Adapter for Greenplum can read and write data in Unicode.

Adapter for Greenplum and PostgreSQL - Version 7 Release 7.06

• A256V Data Type Mapping. The Adapter for PostgreSQL supports data type mapping using the following setting:

  ENGINE SQLPSTGR SET CONVERSION LONGCHAR ALPHA n

  The setting affects the mapping of all PostgreSQL native fields that have a data type of [VAR]CHAR(32767) or TEXT.

Adapter for Hive - Version 7 Release 7.06

• Bulk Loading With DataMigrator. DataMigrator can create Hive metadata and load it into Hadoop using the Bulk Load via a Disk File load type.
• Increased CREATE FILE Functionality. The CREATE FILE process for a synonym that refers to a Hive table creates columns for files created by DataMigrator with data types that Hive supports.
• Specifying the Maximum String Length When Creating Synonyms. When creating a synonym for character columns in Hive data sources, an option enables you to specify the maximum string length.

Adapter for Hyperstage - Version 7 Release 7.06

• Performance Improvements. The increased use of parallelization in joins and sorting has improved the ability to run concurrent queries.
• Memory Management Improvements. Hyperstage now uses memory more efficiently. In addition, various changes have been made which reduce the amount of memory needed.
• Hyperstage ODBC Adapter. A new ODBC adapter for MySQL-based Hyperstage supplements the existing JDBC adapter on the Windows platform.
• Lookup Attribute Added to Denormalized Dimension Columns. When using Quick Copy for a cluster join describing a collection of tables that comprise a Star Schema with a denormalized Hyperstage target, character columns in dimension tables are created with the Hyperstage lookup comment attribute.
• DataMigrator and Quick Copy Support for Unicode. You can load Unicode data to a Hyperstage target using DataMigrator or Quick Copy.

Adapter for Hyperstage (PG) - Version 7 Release 7.06

• Adapter for Hyperstage. The Adapter for Hyperstage using PostgreSQL (PG) has been introduced in this release and is available as a named adapter on the Web Console in the SQL folder.
• Column Comments Supported as DESCRIPTION Attribute. Column Comments is now supported as the synonym DESCRIPTION attribute for PostgreSQL-based Hyperstage, and for all other JDBC-based engines that return Column Comments information in a JDBC Metadata call.

Adapter for i Access - Version 7 Release 7.06

• Adapter for i Access. The Adapter for i Access has been introduced in this release and is available as a named adapter on the Web Console in the SQL folder.

Adapter for Informix - Version 7 Release 7.06

• Support for SDK 4.10.x. The Adapter for Informix supports the Informix SDK 4.10.x.

JDBC Adapters - Version 7 Release 7.06

• Support for COMMANDTIMEOUT Setting. The SET COMMANDTIMEOUT command is introduced for JDBC-based adapters whose drivers support the setQueryTimeout() call.

Adapter for Microsoft SQL Server - Version 7 Release 7.06

• ODBC Adapter for Microsoft SQL Server. The ODBC-based adapter is introduced for Microsoft SQL Server and is available as a named adapter on the Web Console in the SQL folder.
• Support for View Properties. The Adapter for Microsoft SQL Server can retrieve and store view properties (if present) in a Master File synonym.

Adapter for Microsoft SQL Server and Oracle - Version 7 Release 7.06

• Support for HINT. The Adapters for Microsoft SQL Server and Oracle can speed up the DML SELECT by specifying a HINT clause.

Adapter for MongoDB - Version 7 Release 7.06

• Adapter for MongoDB. The Adapter for MongoDB has been introduced in this release and is available as a named adapter on the Web Console in the SQL folder.

Adapter for MySQL - Version 7 Release 7.06

• DataMigrator and Quick Copy, with a MySQL database target, now support the load type Extended Bulk Load, which provides faster load times than insert/update processing.

Adapter for Netezza - Version 7 Release 7.06

• Support for Column and Table Comments. The Adapter for Netezza supports column and table comments. They can be used as titles during the Create Synonym process.
• Support for Password Passthru. The Adapter for Netezza now supports Password Passthru authentication.

Adapter for Oracle - Version 7 Release 7.06

• Create Synonym Support for Materialized View. The Adapter for Oracle recognizes the Oracle synonym for materialized view as a candidate and presents it among the available objects on the Web Console Create Synonym page.
• Support for Version 12c (Cloud). Support has been added for Oracle Version 12c (Cloud).
• Support for 12c Extended String Size. The Adapter for Oracle supports Oracle 12c extended-string data types. [N]VARCHAR2(32767) is supported.

Adapter for Oracle TimesTen - Version 7 Release 7.06

• Adapter for Oracle TimesTen. The Adapter for Oracle TimesTen has been introduced in this release and is available as a named adapter on the Web Console in the SQL folder.

Adapter for SAP HANA DB - Version 7 Release 7.06

• Adapter for SAP HANA DB. The Adapter for SAP HANA Database has been introduced in this release and is available as a named adapter on the Web Console in the SQL folder.
• Metadata For Different Types of Views. The Adapter for SAP HANA can now retrieve metadata and create Synonyms for different types of HANA DB views.
• Adapter for SAP HANA ODBC. he ODBC-based adapter is introduced for SAP HANA and is available as a named adapter on the Web Console in the SQL folder. This adapter (available on Windows 64-bit) supports SSO with Kerberos security.

Adapter for Sybase - Version 7 Release 7.06

• Support for Connection Name. Connection Name has been added as a configuration parameter for the Adapter for Sybase.

Adapter for Teradata - Version 7 Release 7.06

• Extended Bulk Load for Unicode Data. The Adapter for Teradata configured with CLI Teradata Client supports the loading of UTF8-encoded data through Extended Bulk Load.
• Support for Version 14.10. The Teradata CLI and ODBC adapters support read/write access to Teradata Version 14.10.
• Support for Version 15.0. The Teradata CLI and ODBC adapters support read/write access to Teradata Version 15.0.
• Support for Reading INTERVAL and PERIOD Data Types. The Adapter for Teradata now supports read access to the PERIOD and INTERVAL data types.
• Support for Long Table and View Names. Teradata introduced Extended Object Name (EON) in v.14.1. The Adapter for Teradata now supports table and view names (containing multi-byte characters) with length up to 128-bytes.

Adapter for Vertica DB - Version 7 Release 7.06

• JDBC-based Native Adapter for Vertica (SQLVRT). This adapter has been introduced in this release and is available as a named adapter on the Web Console in the SQL folder.

x

Release 7.7 Version 06

Adapter for JSON - Version 7 Release 7.06

• Support for UPDATE. Using DataMigrator, data can be loaded into new JSON targets in a data flow.
• Support for ON TABLE HOLD FORMAT JSON. A report can now save output in JSON (Java Script Object Notation) format.

XML Write Adapter - Version 7 Release 7.06

• Ability to Set Encoding in the XML Header. Previously, the XML Write Adapter always created the XML file with encoding="UTF-8" in the XML header. Now encoding can be specified in the synonym and is written to the XML header.

XML, Web Services, REST and Social Media Adapters - Version 7 Release 7.06

• Redirection Support for HTTP Status Codes 302, 303, and 307. Support has been added for HTTP calls made from the XML, Web Services, REST and Social Media adapters that require a redirection to a different URI. This support includes HTTP status code responses 302, 303, and 307.

x

Release 7.7 Version 06

• Adapter for Axiom EMP. The Adapter for Axiom EMP has been introduced in this release and is available as a named adapter on the Web Console in the ERP folder.
• Adapter for SAP/R3 Setting Execution Mode. From the Change Settings page for SAP, you can select Online or Batch from the Execution mode drop-down menu.

x

Release 7.7 Version 06

• Adapter for Essbase. Two-tier connection support has been implemented for the Adapter for Essbase version 11.1.2 and higher. Since these Essbase versions require Application Manager or higher privileges in order to be able to read the outline while reporting from a cube, a user without those privileges can generate a report or create a synonym by referencing another connection whose user ID has the required privileges.
• Adapter for SAP BW: New Connection Parameters for SNC. Two configuration parameters have been added for SAP BW adapters to support Secure Network Communication (SECURITY_MODE=SNC).
• Adapter for SAP BW NetWeaver 7.x/Hana MDX Unicode. The Adapter for SAP BW NetWeaver 7.x/Hana MDX Unicode has been introduced in this release and is available as a named adapter on the Web Console in the OLAP/SAP folder. The adapter supports SAP BW NetWeaver 7.3 powered by the HANA database, HANA optimized infocubes, and SAP HANA optimized Data Store objects.
• Adapter for SQL Server Analysis Services - Version 7 Release 7.06
  • Certification of Version 2014. Certification is complete for Microsoft SQL Server Analysis Services (SSAS) 2014.
  • Exposing Member Unique Names for Standard Hierarchies. The Web Console screen to create a synonym for SSAS data sources has a button labeled Create Fields for Member Unique Names. Clicking this button adds the UNIQUEIDS INCLUDE syntax to the CREATE SYNONYM command. These names are now also generated using the "7X" style (0x0003), as this style yields shorter unique names and, according to MS SSAS documentation, they are "guaranteed unique names, which are stable over time."
  • Unicode Support. Support has been implemented for Unicode (UTF-8) code page 65001 for the SSAS adapter.

x

Release 7.7 Version 06

Adapter for Microsoft Dynamics CRM 2011 (IWAF) - Version 7 Release 7.06 The IWAF (iWay Adapter Framework) adapter for Microsoft Dynamics CRM 2011 can be used with the WebFOCUS Reporting and DataMigrator server to retrieve data.

Adapter for REST - Version 7 Release 7.06

• Basic Authentication Enabled for Chained Authentication. User credentials can be passed using Basic Authentication for Chained Authentication in a SOAP or REST request.
• Producing a REST Request Trace as a Text File for Diagnostics. The FILEDEF RESTTSCQ command will produce a text file showing the information that a REST request would contain without actually running the REST request.
• Passing an Authorization Token in a REST Request Header. After authenticating through a REST call and receiving a token, all future REST calls for the web service must have the token passed as part of the authorization in the HTTP header.
• Passing a Global Variable for the OBJECT Parameter in a REST Access File. You can pass a global variable for the OBJECT parameter value in a REST Access File.
• Support for Mutual Authentication Certificates for REST and SOAP. A check box labeled SSL Mutual Authentication has been added to the Advanced HTTP connection options collapsible form.

x

Release 7.7 Version 06

Adapter for Excel (via Direct Retrieval) - Version 7 Release 7.06

• File Listener for Excel Worksheet. The File Listener component of DataMigrator can process Microsoft Excel workbooks that are delivered to a specified directory. In addition to the synonym for the workbook as Excel (via direct read), this requires a synonym for a flat file with the normal file listener parameters specified. An additional segment contains a copy of the synonym for the Excel workbook.

Adapters for Flat and Delimited Flat Files - Version 7 Release 7.06

• Reading a Field Containing Delimited Values as individual Rows. A field that contains a list of delimited values (such as email addresses separated by spaces) can now be pivoted to be read as individual rows when an additional segment is added with SEGSUF=DFIX (Delimited Flat File).
• Option to Show Raw Data When Creating a Synonym for a Delimited File. hen creating a synonym for a delimited flat file, the user may need to look at the file in order to see whether there is a header line, what is being used as the delimiter, and what is being used as the enclosure character, if there is one. The Show File option was added to display the selected file.

UPLOAD Support for Discovery of Erroneous Input Data - Version 7 Release 7.06

• When creating metadata and loading data from an Excel worksheet, detection of erroneous data, such as non-numeric values, has been improved.

Trimming Blanks from Uploaded Files - Version 7 Release 7.06

• When working in debug mode, the Change Common Adapter Settings page has a group named Data cleansing functionality (DCF) settings that has a drop-down list for trimming leading spaces and another for trimming trailing spaces.

x

Release 7.7 Version 06

Adapter for Salesforce - Version 7 Release 7.06

• JOIN Support. Child-to-parent retrieval (reversed join) queries are now enabled for custom objects. This feature adds support for queries with multiple objects.

x

Release 7.7 Version 06

• Adapter for Google Analytics. Report against the information residing in the Google Analytics environment. Metrics, such as Page Views and Users, can be analyzed by various dimensions (for example, Country and City).
• Adapter for Facebook: Enhanced Create Synonym Functionality. Create Synonym functionality has been enhanced to create DataMigrator flows and metadata for SQL Server tables to support the warehousing of Facebook information.
• Adapter for Twitter: Enhanced Create Synonym Functionality. Create Synonym functionality has been enhanced to create DataMigrator flows and metadata for SQL Server tables to support the warehousing of Twitter information.
• Adapter for LinkedIn. The Adapter for LinkedIn has been introduced in this release and is available as a named adapter on the Web Console in the Social Media folder.