About This Release
Server New Features
Launch PDF file
Server Enhancements
Data Management Console: Data Type Icons
Data Management Console: Group and Replace
Data Management Console: Additional Functions Available
Installation: New Language Options on Windows
Setting Defaults for Upload Target Parameters
Adapter Enhancements
SQL Adapters
SQL Adapters: Improved Optimization of MATCH Logic
SQL Adapters: Support for SET HOLDATTR for Formats SAME_DB and SQL_SCRIPT
SQL Adapters: Optimization of Simplified Statistical Functions
Adapter for Microsoft SQL Server OLE DB: Additional Connection String
Adapter for MongoDB: Support for Connector for Business Intelligence JDBC Adapter
Adapter for Oracle: Support for Version 18c
Adapter for Snowflake Cloud Data Warehouse
Adapter for Stratio Crossdata
OLAP Adapters
Adapter for Microsoft SQL Server Analysis Services Tabular Data Model
ERP Adapters
Adapter for Salesforce.com: Support for Bulk Retrieval
Procedures Adapters
OAuth 2.0 Authentication Support for the Adapter for REST
Adapter for REST: Support for an XML String in a GET Request Parameter
Sequential and Indexed Adapters
Adapter for Delimited Files: Skip Rows Before Header
Adapter for Excel: Creating a Synonym for Crosstabbed Data
Statistics Adapters
Python Support
XML Adapters
DataMigrator Enhancements
Adapters
Adapter for Excel: Creating a Synonym for Crosstabbed Data
Adapter for Salesforce.com: Support for Bulk Retrieval
Adapter for Snowflake Cloud Data Warehouse
Adapter for Stratio Crossdata
Calculators
Additional Aggregate Functions Available
GET_TOKEN Function Now Available
INITCAP Function Now Available
New FOCUS Functions
Data Management Console
Data and Process Flows
Formatted Files With Excel Format Now Use .XLSX
Enhancements to Join Profiling
Data Profiling
Reporting
Resource Analyzer and Resource Governor Enhancements
New Audit Report
New Repository Load Type Options
New Scheduling Report Option
Reporting Language Enhancements
Expanded Functionality With BY TOTAL and ACROSS
COALESCE: Returning the First Non-Missing Value
COMPACTFORMAT: Displaying Numbers in an Abbreviated Format
FPRINT: Displaying a Value in a Specified Format
GET_TOKEN: Extracting a Token Based on a String of Delimiters
GIS_REVERSE_COORDINATE: Returning a Geographic Component
INITCAP: Capitalizing the First Letter of Each Word in a String
NULLIF: Returning a Null Value When Parameters Are Equal
Statistical Python Functions
BLR_CLASSIFY: Binary Logistic Regression
KNN_CLASSIFY: K-Nearest Neighbors Classification
KNN_REGRESS: K-Nearest Neighbors Regression
POLY_REGRESS: Polynomial Regression
RF_CLASSIFY: Random Forest Classification
RF_REGRESS: Random Forest Regression
Using IF-THEN-ELSE Logic in an Expression
Generating Descriptive Column Titles for Prefixed Fields
Format Display Options for Abbreviating Numeric Values
Support for C-Style In-Line Comments
SET PCTFORMAT: Displaying a Percent Sign for Percent Prefix Operators
Server Release Notes Release 7709
Launch PDF file
Access Control: Option to Disable Password Changes at Login
Active Technologies: Flex SDK No Longer Shipped
Adapter Notes
Dropped Support: Adapter Releases
Dropped Support: Operating System Releases
IBM i and z/OS: Server Does Not Start if the CCSID in admin.cfg Does Not Match the Server Code Page
Java: Minimum Release for Server Startup
Java: Oracle and OpenJDK License and Certification Issues
PTH Security Provider: Removal of security_scope Keyword
Further Information