Informatica 10.5.2 release is for all customers and prospects who want to take advantage of the updated Hadoop distribution support and fixes to the core platform and other functionalities of PowerCenter, Informatica Data Quality, Data Engineering Integration, Data Engineering Quality, Data Engineering Streaming, Data Privacy Management, Enterprise Data Catalog, and Enterprise Data Preparation.
This release provides new features, the latest ecosystem and connectivity support, security enhancements, and performance enhancements while improving the user experience. Also, Log4j 1.x and 2.x have been updated to Log4j 2.17.1.
Data Engineering Integration (DEI)
Product enhancements
- Databricks ecosystem enhancements:
- Unmanaged Databricks table support: Read and write support for unmanaged Databricks tables on AWS and Azure platforms for mappings that run on the Databricks engine
- Flexible Databricks cluster creation options: Pass a configurable Databricks JSON file as an input parameter for the Create Cluster task for Databricks
- Delta target schema evolution support: Use Merge Schema SQL queries in post SQL commands of Databricks targets
- Developer Tool: Mark all the columns to allow null values with a single click by selecting the Enable All Nullable option in the Outline view for relational and logical data objects
PAM updates
- EMR 6.4 (New)
- Ubuntu 18.04 with HD Insights 4.0
Data Quality (DQ)
Product enhancements
- Informatica Container Utility (Deployment Manager): Use Informatica Deployment Manager to install Informatica Data Quality on Azure Kubernetes Service (AKS) clusters. Additionally, use Informatica Deployment Manager to manage domains and nodes that run on Kubernetes for Informatica Data Quality
- Exception Management and Human Tasks: Support for Exception Management, Exception Management Audit, and Human Task databases on PostgreSQL using a JDBC driver
- Data Quality Accelerators:
- Fix included for Data Domain Glossary 10.5.x (ABA Routing Numbers and US ZIP Codes)
- Fix included for Informatica Core Accelerator 10.5.x (US ZIP Codes)
PAM updates
- EMR 6.4 (New)
- Ubuntu 18.04 with HD Insights 4.0
Data Engineering Streaming (DES)
Product enhancements
- Use Kudu as a target in dynamic mappings with Data Engineering Streaming
PAM updates
- EMR 6.4 (new)
- Ubuntu 18.04 with HD Insights 4.0
Enterprise Data Catalog
User Experience
- Display asset description and composite data domains on the Search Results page
- Enhanced search pre-filter with custom attribute sorting
- Axon Business Terms - Key Data Element (KDE) or Critical Data Element (CDE) enhancements:
- The KDE icon is added to the following sections to quickly identify KDE Axon Business Terms: On assets, In Search results, In Related Glossaries, In Association
- The KDE icon is shown for Enterprise Data Catalog assets where KDE Business Terms are associated
- The KDE attribute can be filtered
- Show Related Logical Assets on the Axon Glossary, Dataset, and System Overview page
- Show Related Technical Assets on the Axon Attribute Overview page
- Show the asset path in the:
- Business Term to asset association dialog box
- Show All tabular view in the Relationships tab
- Display asset documented foreign keys information on the Keys and Relationships tabs
- Enhance the Salesforce scanner V1 resource asset page to show data domains, basic profiling statistics, and source and inferred data types
Deployment
- Support Log4j 2.17.1
- Reverse proxy and load balancing support for Enterprise Data Catalog web applications
- Email notifications on Resource Job Task failure
- Support external PostgreSQL DB for similarity datastore in Informatica Cluster Service configuration
- Support multi-disk partition, H/A failover SSL for external PostgreSQL DB for similarity datastore to improve performance
- New DAA Dashboard API to extract OOTB dashboard metrics and chart information
- New "accessFilter" GET API to fetch the privileges for specific resources and specific users
Scanners and Discovery
New Advanced Scanner
- Azure SQL Data Warehouse - Azure Synapse Analytics (SQL Pool) - Stored Procedures
New Standard Scanners
- Informatica Cloud Data Integration (IICS) scanner V2 (Technical Preview):
- Parameter file support
- Filter support at project, folder, and task levels
- Mapping tasks, PowerCenter tasks, synchronization tasks
- Salesforce scanner V2 (Technical Preview)
- Include metadata extraction for Salesforce Sales Cloud and Service Cloud
- Objects, views, triggers, asset descriptions, SDFC API v52 support, user/password and OAuth authentication, connection through proxy support, and metadata filters
- Amazon S3 scanner V2 (Technical Preview) and ADLS GEN-2 scanner V2 (Technical Preview):
- Schema merge of nested schema
- Partition pruning. Find the latest partition to identify the schema and for data discovery
- Partition detection for Parquet and Avro files
- Custom or non-Hive-style partitioning support
- Incremental scan
- Exclusion filters for directories
Scanners and Discovery Enhancements
- Support thresholds for inference and auto acceptance of smart data domains
- Enable Business Term Association for Tableau
- Data profiling on Databricks cluster on AWS
- Acceptance threshold while propagating "Data Domains" to similar columns
- Enhanced Import and Export features:
- Bulk certification
- Details of data match conformance scores and metadata match in exports
- Option to export data type
- Enhanced Avro file support in Amazon S3 scanner V1, ADLS Gen2 scanner V1, and HDFS scanner:
- Support for Avro complex data type, multi-hierarchy file
- Partitioned file detection (strict mode only)
- Profiling in native and Spark mode
- Upper limit for Random % Sampling in Google BigQuery
- Google BigQuery profiling for reserved keywords
- Regex based directory filtering for File system; S3 scanner V2 and ADLS scanner V2
- Unique Key Inference for Azure SQL Database and IBM DB2/ZOS
Note: We are releasing V2 scanners for technical preview, so customers can evaluate them and provide feedback before the general availability in a future release.
PAM updates
Scanners
- Informatica Data Quality 10.5.2
- Informatica Platform 10.5.2
- Informatica PowerCenter 10.5.2
- Business Glossary 10.5.2
- Oracle 21c
- Teradata 17
- Tableau 2021
- EMR 6.4
- Connection through proxy for ADSL, Amazon S3, Azure SQL Database, Azure SQL Data Warehouse, Sharepoint, Google BigQuery
Profiling
- Certification of AWS Databricks
- Partitioned parquet files on Amazon S3
- Delta tables on AWS Databricks
Deployment
- Support for Microsoft Edge based on Chromium
- Added support for RHEL 8.5
- Added support for Oracle Linux 8.5 - RHCK Kernel only
- Added support for Suse Linux 15 SP3
- Added support for Oracle 21c to install Enterprise Data Catalog
Enterprise Data Preparation
PAM updates
- EMR 6.4 (New)
- Ubuntu 18.04 with HD Insights 4.0
Data Privacy Management
Product enhancements
- Connectivity enhancements for OneDrive and SharePoint data stores. Data Privacy Management now uses Azure APIs to scan these data sources, improving scan performance.
PAM updates
- PostgreSQL 13.4
- Oracle 21c
- Snowflake as golden datastore for Subject Registry
Test Data Management
PAM updates
- PostgreSQL 13.4
- Oracle 21c
Informatica Platform
Product enhancements
- Support for Apache HTTP reverse proxy (webserver) for web apps for the Administrator tool and Analyst tool
- Update of Log4j 1.x and 2.x to Log4j 2.17.1
- Added UTC time zone logging (time zones in the timestamp fields for the logs)
- Security audit logging enhancements for invalid user names and passwords for SOX compliance
PAM updates
- PostgreSQL 13.4
- Oracle 21c
- Ubuntu 18.04
- Updated Azul OpenJDK Java 1.8.0_322
- Updated AIX - IBM JDK 8.0-7.0
- Updated Tomcat 9.0.58
Authentication
- Added support for Microsoft AD 2019 - LDAP authentication and Kerberos
- PingFederate 10.2.1.1
- Shibboleth iDP
PowerCenter Repository Service
PAM updates
- Azure PostgreSQL v11
- PostgreSQL 13.4
- Oracle 21c
Product enhancements
- Support for Windows FIPS option (FipsAlgorithmPolicy)
Model Repository Service
PAM updates
- PostgreSQL 13.4
- Oracle 21c
- Perforce 2021.2
- Visual SVN 4.2.7 and 4.3.5
- SVN 1.14.1
- Bitbucket Server Data Center 7.19.3
- GITHUB Enterprise Server 3.3.2
- GITLAB Enterprise Edition 14.5.1
PowerExchange Mainframe and CDC
Product enhancements
- Configurable buffer size for Db2 for CDC journal entries on the IBM i platform
- Ability to delete inactive CDC registrations from the PowerExchange CCT file
- Improvements to memory usage reporting:
- Memory reporting for the z/OS PowerExchange Listener
- Memory utilization reporting for PowerExchange Express CDC for Oracle
- PostgreSQL CDC changes are now collected only for sources with active CDC registrations
- PowerExchange for IMS can now search for DBD information from a list of concatenated DBD libraries
PAM updates
- Added support for Oracle 21c with PowerExchange Express CDC for Oracle
- Added support for z/OS 2.5 for PowerExchange software installed on the z platform
Connectivity (Informatica Platform/Informatica PowerCenter)
Product enhancements
- PowerExchange for PostgreSQL for PowerCenter
- Support to call stored procedures using pre-SQL and post-SQL queries
- PowerExchange for Microsoft Azure Data Lake Gen2
- ACL support for read and write operations
- Recursive read support for flat files
- Shared key authentication
PAM updates
- Teradata v17.10 certification for PowerCenter, Data Engineering Integration, Informatica Data Quality, and Data Engineering Quality (Support is not available on AIX)
- Greenplum client v6.18 certification for RHEL 8.0 for PowerCenter
- PostgreSQL v14.x certification for PowerCenter
- Oracle v21c certification for PowerCenter