Skip navigation
1 2 Previous Next

Informatica Platform

25 posts

What are we announcing?

Informatica 10.5.1

Who would benefit from this release?

This release is for all customers and prospects who want to take advantage of the latest PowerCenter, Informatica Data Quality, Data Engineering Integration, Data Engineering Quality, Data Engineering Streaming, Data Privacy Management, Enterprise Data Catalog, Enterprise Data Preparation, and Test Data Management capabilities.

What’s in this release?

Data Engineering Integration

  • Security enhancements

PAM:

  • Cloudera CDP: Private Cloud Base 7.1.x
  • Cloudera CDP: Public Cloud 7.2.x
  • Amazon EMR 6.1.x
  • Hortonworks HDP 3.1.5
  • Cloudera CDH 6.3.4
  • Databricks 7.3
  • Google Dataproc 1.5
  • MapR 6.1.x MEP 6.3.3

Data Quality

  • Informatica Container Utility (Deployment Manager): support for deployment of an Informatica domain and the required application services for Informatica Data Quality. The Deployment Manager deploys Informatica Data Quality in a docker container.
  • Reference Data Database: support for reference data database on PostgreSQL using JDBC driver.
  • Match Transformation: updated identity resolution libraries and population files.
  • Address Validator Transformation: updated to use Informatica Address Verification engine 5.16.1.
  • Data Quality Accelerators:
    • Added/updated these data domains: 
      • Relates to identification ids: Albania_NationalID, Argentina_NationalID, Australia_BusinessNumber, Australia_DriversLicense, Australia_Medicare_Number, Australia_TaxFileNumber, Australian_ACN, Australian_PhoneNumber, Chile_NationalID, Colomia_NationalID, Czechia_TIN, Estonia_NationalID, France_SIREN, Greenland_CPR, Hungary_TIN, Hungary_TIN_Adószám, Ireland_NationalID, Kuwait_NationalID, Laithuania_NationalID, Spain_NIF_NIE, UnitedArabEmirates_NationalID, UnitedKingdom_UTR, USA_ITIN
      • Related to California: California_Telephone_Area_Code, California_Cities, California_Counties, California_Universities, California_Zipcodes
  • PAM
    • MAPR 6.1.x MEP 6.3.3
    • Cloudera CDP: Public Cloud 7.2.x
    • Cloudera CDP: Private Cloud Base 7.1.x

Informatica Analyst Tool

  • Ability to create a connection to a Salesforce system and import Salesforce objects using the Analyst Tool.

Data Engineering Streaming

  • Transformations in Databricks: You can add the following transformations to streaming mappings that run in the Databricks environment on Azure and AWS platforms:
    • Address Validator
    • Classifier
    • Parser
    • Standardizer
  • Intelligent Structure Models on Databricks: You can incorporate an intelligent structure model in a Confluent Kafka, Kafka, Azure Event Hubs, and Amazon Kinesis Stream data object for streaming mappings that run on the Databricks Spark engine.
  • New PAM
    • MAPR 6.1.x MEP 6.3.3
    • EMR 6.1
    • Cloudera CDP : Private Cloud Base 7.1.x
    • Cloudera CDP : Public Cloud 7.2.x

Connectivity

PAM Updates

  • Informix v14 certification for PowerCenter
  • PostgreSQL v13.x certification for PowerCenter
  • MySQL v8.0.25 certification for PowerCenter
  • MySQL v8.0.25 certification using ODBC connector for Informatica Platform
  • Sybase IQ v16.1 SP4 certification as target (Loader connection) for PowerCenter
  • Vertica Client v10.1.x certification for PowerCenter
  • JDBC V2 Spark Connector certification for Azure SQL DB for PowerCenter and Informatica Platform

Security Enhancements

  • Driver support for MIT Kerberos with Informatica package for Oracle, SQL Server (ODBC), DB2, and Sybase for PowerCenter

Enterprise Data Catalog

User Experience

  • Improved Enterprise Data Catalog login response time.
  • Sort search results based on relevance and sort enabled attributes.
  • Curate data domain for columns directly from the table level.
  • Change notifications for data stewards and data owners assigned to assets.
  • Increase in character limit from 10K to 1,000K to display views and logic scripts.

Analytics

  • Data Asset Analytics:
    • Improved dashboard response time for huge data asset volumes.
    • Additional filters in Asset Usage, Business Term Association, and User Collaboration reports.
    • Security enhancements.
  • Data Flow Analytics General Availability:
    • Data Flow Analytics for data mapping insight and discoveries with AI/ML to accelerate data modernization, improve data mapping efficiency, and reduce operational costs.
    • Data Flow Analytics for PowerCenter mappings automates the following discoveries:
      • Similar mapping groups and the representative mapping within each group.
      • Duplicate mappings.
      • Mapplet candidates.
      • Reusable transformation candidates.
      • User-defined functions candidates.

Deployment

  • Automated mTLS security enablement for all services running on the cluster.
  • Removed the requirement for Sudo privileges while you perform the following tasks:
    • Restarting, monitoring, starting, and stopping the Informatica Cluster Service and Catalog Service.
    • Backup and restoration of catalog data.
  • Security enhancements.
  • Install Enterprise Data Catalog in a non-production environment using Docker. 

Scanners and Discovery

  • Scanner and Discovery Enhancements
    • New utility to perform a bulk import of Amazon S3 certificates into the default trust store.
    • Support for incremental profiling and metadata ingestion using the Amazon S3 resource.
    • PowerCenter parameter file utility enhanced with support for worklets-level parameters and password encryption.
    • Support custom data profile sampling SQL query parameter for the JDBC resource.
    • Group compatible parquet file schemas using the 'Non-Strict' partition detection option.
    • Profile Google BigQuery partitioned tables and views for primitive data types.
      Note: You cannot use a single resource to profile both partitioned tables and views as the support modes are different for both object types. Views are supported through the simple mode and partitioned tables are supported through the hybrid mode.
  • New Advanced Scanners
    • Azure Data Factory.
    • Databricks Notebooks with support for Python (PySpark), SQL.
    • Amazon Redshift stored procedures with PL/pgSQL lineage parsing.
    • SAP Business Objects Data Services (BODS).

PAM Updates

  • Scanners
    • Informatica Data Quality 10.5.1
    • Informatica Platform 10.5.1
    • Informatica PowerCenter 10.5.1
    • Informatica Data Integration Hub 10.5
    • Business Glossary 10.5.1
    • SAP S/4HANA 2020
    • Cloudera Navigator 6.3
    • Apache Atlas CDP 7.1.6
    • HDFS and Hive certification for MAPR-FS 6.1.1 MEP 6.3.3 
  • Deployment
    • Support added for RHEL 8.4
    • Support added for Oracle Linux OS 8.4 - RHCK Kernel Only
    • RHEL 7.9 FIPS Certification
    • SELinux on Enforcing mode support

Enterprise Data Preparation

New Features

  • Security enhancements

PAM

  • MapR 6.1.1 MEP 6.3.3

Data Privacy Management 

New Features

  • Tag anomalies in User Activity and filter and export anomalies based on tags.
  • Customize existing DSAR PDF report templates or create new DSAR PDF report templates.

PAM Updates

  • Microsoft Azure SQL Database as the Data Privacy Management repository
  • Native connectivity for Domain Discovery and Subject Registry
    • Google BigQuery
  • Connectivity through third-party drivers (Drivers to be procured directly by customers)
    • MongoDB
    • REST API

Test Data Management 

PAM Updates

  • Support for the following data types when masking data in Hadoop:
    • CHAR
    • VARCHAR
    • DATE
    • TIMESTAMP

Platform PAM

  • Java
    • OpenJDK Java 1.8.0_302
    • IBM JDK 8.0.6.35
  • Tomcat
    • Updated Tomcat 9.0.50
  • Browser support updated:
    • Microsoft Edge Chromium - Version 93.0.961.38
    • Chrome Version - 93.0.4577.63
  • MRS VCS
    • Perforce  - added 2021.1, removed 2019.1
    • Visual SVN - added 4.3.4, 4.2.6, removed 4.3.1, 4.2.2
    • SVN - removed 1.13
    • Bitbucket Server Data Center - added 7.14, removed 7.7
    • GITHUBG Enterprise Server  - added 2.22.15, removed 2.22.4
    • GITLAB Enterprise Edition - added 13.12, removed 13.6.0

PowerCenter

  • Support for Kerberos Resource-Based Constrained Delegation (RBCD), which restricts the services to which the specified server can act on the behalf of a user that allows the resource owner to control who can access it. Configure an Informatica domain to use either full delegation or Resource-Based Constrained Delegation.
  • Enhanced security for Command task: Capabilities to control the usage of certain commands in the PowerCenter Workflow command task.

PowerExchange Mainframe & CDC

  • PAM
    • PostgreSQL V13
    • MySQL RDS CDC
  • Security Improvements
    • z/OS RACF recording of User last log-on data
    • z/OS netport jobs: passphrase support
  • Functionality Enhancements
    • Oracle Dynamic Dictionary
    • Oracle LOB support for PowerExchange Express CDC for Oracle
    • z/OS tape recall improvements
    • SAP HANA sources supported for CDC with trigger-based capture
      • Informatica has introduced a new SAP HANA CDC capability, which allows customers to capture changes from SAP HANA databases

Release Notes & Product Availability Matrix (PAM)

What's New and Changed: https://docs.informatica.com/data-integration/shared-content-for-data-integration/10-5-1/what-s-new-and-changed--10-5-1-/preface.html

Note: Product documentation is updated for every major release even if a guide does not contain any updated functionality. Product documentation is updated for service packs and hotfixes only if a guide contains updated functionality. If you cannot find a guide for a service pack or hotfix, look at the previous version.

Informatica 10.5.1 Release Notes: https://docs.informatica.com/data-engineering/shared-content-for-data-engineering/10-5-1/release-notes--10-5-1-/abstract.html

PowerExchange Adapters for Informatica Release Notes: https://docs.informatica.com/data-integration/powerexchange-adapters-for-informatica/10-5-1/powerexchange-adapters-for-informatica-release-notes.html

PowerExchange Adapters for PowerCenter Release Notes: https://docs.informatica.com/data-integration/powerexchange-adapters-for-powercenter/10-5-1/powerexchange-adapters-for-powercenter-release-notes/abstract.html

PowerExchange Release Notes: https://docs.informatica.com/data-integration/powerexchange-for-cdc-and-mainframe/10-5-1/release-notes/introduction.html

PAM for Informatica 10.5.1: https://network.informatica.com/docs/DOC-19274

What are we announcing?

Informatica 10.5.0.1

Who would benefit from this release?

This release is for Informatica Data Quality, Data Engineering, Data Catalog, Data Preparation & Data Privacy Management customers and prospects who want to take advantage of updated Hadoop distribution support as well as fixes to the core platform and other functionality. You can apply this service pack after you install or upgrade to Informatica 10.5.

What’s in this release?

Data Engineering

  • Infacmd CLI updates: With the new CLI updates, can now abort specific mappings from the infacmd command line interface.
  • PAM
    • Azure HD Insights 4.0 Spark Cluster
    • Cloudera CDH 6.3.4
    • MapR 6.1.0 MEP 6.3.3

Data Quality

  • Internet Protocol Dual Stack (IPv6-IPv4) support: Deploy the domain, application services, repositories, Informatica Analyst, the Content Management Service, and source and target connections on dual-stack servers.
    - Official Support Statement
  • PAM
    • Azure HD Insights 4.0 Spark Cluster
    • Cloudera CDH 6.3.4
    • MapR 6.1.0 MEP 6.3.3

Data Engineering Streaming

  • PAM
    • Spark 3.x support for DES with Databricks 7.3
    • New Hadoop distributions support:
      • Azure HD Insights 4.0 Spark Cluster
      • Cloudera CDH 6.3.4
      • MapR 6.1.0 MEP 6.3.3

Enterprise Data Catalog

Scanners

  • New Advanced Scanners for Snowflake and Greenplum with stored procedure support.
  • New Microsoft Power BI scanner with support for proxy, field-level detailed lineage for datasets, and external lineage.
  • Enhanced SAP BW scanner with support for lineage, impact, and relationships from InfoSource.
  • Updated scanner PAM with support for the following versions of data sources:
    • MicroStrategy 2021
    • Qlik Sense 13.x
    • HDFS and Hive: MAPR 6.1.0 with MEP 6.3.3

Data Asset Analytics

  • Fine-tuning to enhance performance.
  • Data Asset Analytics repository PAM update: support for PostgresSQL 12.6.

Enterprise Data Preparation

  • PAM
    • Azure HD Insights 4.0 Spark Cluster
    • Cloudera CDH 6.3.4
    • MapR 6.1.0 MEP 6.3.3

Data Privacy Management

  Sensitive Data Discovery and Subject Registry support added for:

  • Active Directory
  • Scality RING 8
  • Google Docs, Sheets, and Slides through the Informatica Discovery Agent

Release Notes & Product Availability Matrix (PAM)

Informatica 10.5.0.1 Release Notes: https://docs.informatica.com/data-catalog/shared-content-for-data-catalog/10-5/release-notes--10-5-0-1-/preface.html

Note: Product documentation is updated for every major release even if a guide does not contain any updated functionality. Product documentation is updated for service packs and hotfixes only if a guide contains updated functionality. If you cannot find a guide for a service pack or hotfix, look at the previous version.

PowerExchange Adapters for Informatica Release Notes: PowerExchange Adapters for Informatica Release Notes (10.5.0.1)

What's New and Changed: https://docs.informatica.com/data-engineering/shared-content-for-data-engineering/10-5/what-s-new-and-changed--10-5-0-1-/preface.html

PAM for Informatica 10.5.0.1: https://network.informatica.com/docs/DOC-19062

 

You can download the Service pack links from: https://network.informatica.com/downloadsView.jspa

What are we announcing?

The release of Informatica 10.5

Who would benefit from this release?

This release is for all customers and prospects who want to take advantage of the latest PowerCenter, Informatica Data Quality, Data Engineering Integration, Data Engineering Quality, Data Engineering Streaming, Data Privacy Management, Enterprise Data Catalog, Enterprise Data Preparation, and Test Data Management capabilities.

What’s in this release?

This release provides new features, the latest ecosystem & connectivity support, security enhancements, cloud support, and performance enhancements while improving the user experience.

Some of the key features include:

Data Engineering Integration

  New Features

  • Mapping audit: You can validate the consistency and validity of the mapping jobs by creating audit rules and conditions. Rules can be scheduled before and after the mapping runs, either from the Developer tool or infacmd.
  • File manager utility: You can administer the preprocessing and file watching capabilities for a cloud ecosystem. The utility eliminates the need for a complex setup or custom script. You can use the credentials and connections set up within Informatica Administrator for file management.
  • Claire Recommendation: Enterprises that use Enterprise Data Catalog to tag columns as sensitive can share the information with developers. This information empowers developers to take appropriate masking actions to secure data in the Data Engineering pipeline.
  • CI/CD: You can compare objects across services in the same domain and between services across domains.
  • Debugging: The LogPacker utility can now aggregate logs from ephemeral cloud clusters and Spark job servers. A new API is also available to trigger and perform log collection programmatically.
  • Dynamic flattening in mappings: You can flatten complex hierarchical data types in dynamic mappings. Dynamic flattening improves the reusability of mappings when files are processed with hierarchical data types.
  • Multi-match lookups: Helps developers leverage the full functionality of feature-rich Informatica lookups in mappings that run on the Spark engine.
  • Databricks warm pool: Users of the Databricks pushdown capabilities can leverage warm pool instances to shorten cluster startup time with ephemeral or standard clusters from Data Engineering Integration.
  • File watcher: Added support for file watcher or file-preprocessing commands that allows file copy, read, list, rename, move, and watch.

PAM Update

  • Databricks 5.5, 7.3
  • Google Dataproc 1.5
  • Cloudera CDP Public Cloud 7.2 (AWS and Azure)
  • Cloudera CDP Private Cloud 7.1.4,7.1.5
  • Microsoft Azure HD Insights 4.0
  • Hortonworks HDP 3.1.5
  • Cloudera CDH 6.3.4 (with EBF)
  • Amazon EMR 5.29, 6.1

Spark PAM Update

  • Spark 3.0.1 support
    • Databricks 7.3
    • Amazon EMR 6.1

PowerCenter

  • Parameterized connect string: Provides the ability to parameterize the connect string attribute in relational connections for the Oracle database.
  • Oracle Multitenant CDB/PDB support: Applies to the domain and the PowerCenter Repository Service.
  • Integration of system trace and stack trace: Improved debugging with the integration of system trace and stack trace collection on the Linux platform.
  • TLS-enabled Mail Server Support: Send secured emails using through SMTP servers that use TLS protocol.
  • GENERATE_UUID(). GENERATE_UUID( ) function for pushdown optimization with ODBC for GBQ.  Use for use cases such as autogenerating string values as surrogate keys in the tables.
  • Error logging. Improved error logging for the PowerCenter Integration Service to improve supportability.
  • Diffie-Hellman Ciphers: Supports Diffie-Hellman Ciphers in PowerCenter services to mitigate the Forward Secrecy issue.

Platform

Platform PAM

  • Oracle Database Multitenant (CDB/PDB) support for Informatica PowerCenter Domain, PowerCenter Repository Service, Model Repository Service, Data Integration Service, Informatica Data Service, and the Analyst tool.
  • Database support added:
    • PostgreSQL 12.3
    • PostgreSQL 11.8
    • IBM DB2 11.5
  • Operating System support added:
    • RHEL 8
    • SUSE 15
    • Ubuntu 20.04
    • Amazon Linux 2.0.20210126
  • Database support removed:
    • PostgreSQL 11.7 & 10.6
    • SQL Server 2014
    • Oracle 12cR1 & 11gR2
    • IBM DB2 10.5
  • Operating System support removed:
    • Windows 2012 R2
    • SUSE 11
    • Ubuntu 16.04.5
    • Amazon Linux2.0.20200304
  • Operating System support:
    • AIX 7.1 and 7.2
  • Java support updated:
    • OpenJDK Java 1.8.0_275
    • IBM JDK 8.0.6.20
  • Tomcat
    • Added Tomcat 9.0.41
    • Removed 7.x
  • Browser support updated:
    • Microsoft Edge Chromium - Version 86.0.622.38
    • Chrome Version - 86.0.4240.75
    • Removed Microsoft Edge Browser as it is replaced with Microsoft Edge Chromium.
    • Internet Explorer - 11.x
    • Safari 13.0.4
  • Informatica Domain
    • SAML Enhancements
      • Request signing: SAML request signed by Informatica using the private key and the identity providers (IdP) can verify the signature using the public certificate.
      • Response signing: IdP sends signed SAML response using the private key and Informatica verifies the signature using the public certificate.
      • Encrypted assertion: IdP sends the encrypted assertion to Informatica, which then decrypts the assertion.
      • Configurable properties: Configure SAML authentication in the Administrator tool: gateway and worker nodes. Configure functionality such as the IdP URL, clock skew tolerance, and authentication context, as well as the above-mentioned functionality.
    • SAML identity providers (IdP):
      • OKTA SAML SSO
      • Oracle Access Manager (OAM) SAML SSO
      • Azure Active Directory Domain Services (ADDS) SAML SSO
    • Optimize LDAP sync and performance improvements.
    • Encryption strengthening to AES-256:
      • Update to AES-256 bit encryption key for secure data storage from AES-128. This enhanced encryption allows to encrypt sensitive data, such as passwords and secure connection parameters, before Informatica stores the data within the Informatica repositories with 256 bit encryption key.
      • Regeneration of the site key is removed to strengthen the security. The regeneration of the encryption key with keyword and domain name is removed and replaced with generation only once during initial setup. The site key is generated only once (regeneration with result in a new site key) and the same should be copied to each node or can be placed at a shared location accessible by each node. You cannot regenerate the site key. It is recommended to secure the site key.
      • Upgrade impact-  It is recommended to migrate the site key (to AES-256) after the Informatica domain upgrade. However, customer can choose not to upgrade to the latest AES-256 bit encryption and the previous behavior will be retained with AES-128 bit encryption key.
    • Enhanced audit logs for permission and privilege change. Display detailed permission and privilege level changes in the user activity logs.
    • Credential security: Credential data needs to be securely encrypted so that it cannot be modified and disallow elevation of privileges for logged-in user.
    • Azure SQL DB authentication with Azure Active Directory for Informatica Domain and Repository (PCRS and MRS).

Installer

  • Web-based user interface for the installer is available for technical preview. Technical preview functionality is supported for evaluation purposes but is unwarranted and is not production-ready. Informatica recommends that you use it in non-production environments only. Informatica intends to include the preview functionality in an upcoming release for production use but might choose not to in accordance with changing market or technical circumstances. For more information, contact Informatica Global Customer Support.
  • Support for enhanced SAML authentication features: signed request, signed response, and encrypted assertion.

Model Repository

  • Bitbucket load balancer
  • Version control systems (VCS) support added:
    • Azure DevOps
    • Visual SVN 4.3.1 (with 1.14.0 Apache SVN)
    • Perforce 2020.1
    • SVN  1.14.0
    • Bitbucket Server 7.7
    • GitHub Enterprise Server 2.22.4
    • GitLab 13.6.0
    • Removed - Visual SVN 4.0.2 , Perforce 2017.2 , Bitbucket 7.1 & 6.4 , Github Enterprise Server 2.20.5 , GitLab - 12.9.2

Informatica Container Utility (Deployment Manager)

Kubernetes (K8s)

Support for the Informatica Domain in Azure Kubernetes Service (AKS) with the new INFAK8s plugin. This is a new deployment utility with plugin-based approach to support individual Informatica application services on the Kubernetes cluster. The following functionality is available:

  • Node management with Installation and Configuration Update
  • Grid Service Manual & Auto Scaling
  • EBF Patching - EBF can be placed in shared volume and picked up by the INFAK8s plugin (EBFs will be applied to all the nodes automatically)
  • Upgrade - Seamless upgrades into newer Informatica releases - 1 click task (post 10.5)
  • Pod and Node Recovery - In case of pod crash or cluster failure, auto-recovery to last running state – no backup node required for non Grid services like the Model Repository Service and the PowerCenter Repository Service
  • 1-click domain shutdown and restart
  • Restrict CPU, memory usage per node
  • File streaming/Log retrieval from nodes
  • CPU and memory-based auto-scaling for grid services
  • Managing CPU and memory usage limits per node
  • Ability to run node and service pre-startup and post-startup commands
  • Node and service recovery after K8s POD restart
  • Restoring the Model Repository Service and PowerCenter Repository Service backup from an existing installation
  • Container Image configuration - support for full image and custom service-based Images

PAM support

  • Docker Container - CentOS & RHEL
  • Database - Oracle, SQL Server, and PostgreSQL
  • Kubernetes - Azure Kubernetes Service (AKS) only
  • Available for Informatica Domain, PowerCenter, PowerCenter Repository Service,  PowerCenter Integration Service, Data Engineering Integration, Model Repository Service, Data Integration Service, monitoring Model Repository Service, and Email Service.

Data Engineering Streaming (DES)

Streaming Data Integration

  • Support for high precision decimal numbers
  • Support for logical data types in Avro data format
  • Support for a periodic refresh of lookup cache in long-running streaming mappings
  • Enhanced parsers for CSV, XML, JSON, and Avro data format for addressing complex use cases
  • Support for offset header port in Kafka source

Enhanced Cloud streaming support

  • Google Ecosystem
    • Support for running streaming jobs on Google Dataproc
    • Support for Google PubSub as a streaming source
    • Support for Google Cloud Storage as a streaming target
    • Rollover support for ADLS Gen2 and Amazon S3 target connectors
  • Databricks.Additional transformation support on Databricks in streaming mode
  • Amazon-managed Streaming for Kafka (MSK) certification
  • Connectivity
    • Latest Apache and Confluent Kafka support
    • New target connectivity: Support for Cassandra and Kudu targets
    • Hive target enhancements
  • PAM
    • Databricks 5.5
    • Google Dataproc 1.5
    • Cloudera CDP Public Cloud 7.2 (AWS and Azure)
    • Cloudera CDP Private Cloud 7.1.4,7.1.5
    • Microsoft Azure HD Insights 4.0
    • Cloudera CDH 6.3.4 (with EBF)
    • Hortonworks HDP 3.1.5
    • Amazon EMR 5.29

Data Engineering Quality (DEQ)

PAM

  • Databricks integration:
    • You can run mappings with the following Data Quality transformations in an Azure Databricks or AWS Databricks environment: Address Validator, Case Converter, Classifier, Consolidation, Decision, Key Generator, Labeler, Match, Merge, Parser, Rule Specification, Standardizer, Weight Based Analyzer
    • You can create and run profiles on the Databricks cluster in the Informatica Developer and Informatica Analyst tools. You can perform data domain discovery and create scorecards on the Databricks cluster. Profiling of Databricks Delta table (JDBC) and objects in Azure ADLS Gen 2 in Azure Databricks clusters
    • Supported versions: Databricks 5.5 and 7.3
  • Google Dataproc 1.5
  • Cloudera CDP Public Cloud 7.2 (AWS and Azure)
  • Cloudera CDP Private Cloud 7.1.4, 7.1.5
  • Microsoft Azure HD Insights 4.0
  • Cloudera CDH 6.3.4  (with EBF)
  • Hortonworks HDP 3.1.5
  • Amazon EMR 5.29, 6.1

Informatica Data Quality (IDQ)

New pre-built package of Data Quality Accelerators for Japan

  • Contains rules for:
    • Address: multi-line address, multi-line address with geocoding, postal code and prefecture validation
    • Contact: Driver license, first name, last name and others
    • General: Date validation
    • Dictionaries: prefecture, town, postal code, area code for telephone, Romanized first name and last name, city, name by gender in Kanji and others
  • Update to data domain glossary to include national IDs

Enterprise Data Preparation (EDP)

New Features

  • Directly prepare on cloud data warehouses, cloud databases, and other JDBC V2 compliant relational data sources without duplicating data to the lake
  • Enhanced project-centric user experience
  • Copy projects to quickly share the prepared recipes and datasheets with your team
  • Support for multi-byte characters
  • Performance improvements for the user interface
  • Enhanced Security

PAM

  • Amazon EMR 6.1
  • Cloudera CDP Private Cloud 7.1.4
  • Microsoft Azure HD Insights 4.0
  • Hortonworks HDP 3.1.5
  • Cloudera CDH 6.3.4 (with EBF)

Enterprise Data Catalog (EDC)

Discovery

  • Profiling pushdown to Databricks: Support for pushdown to Databricks cluster for column profiling and data domain discovery.
  • Enhancements to similarity discovery such as grouping resources, reducing false positives, and computing similarity on enabled features.

Re-architecture of Enterprise Data Catalog

  • Deprecated support for installation on internal and external Hadoop clusters.
  • Replaced HBase with MongoDB as the metadata store.
  • Nomad by HashiCorp introduced as the orchestration framework.
  • Support to back up metadata store, search database, and other stores either separately or in parallel.

User Experience enhancements

  • Search result page. Enhanced with the following features to improve user experience in searching and identifying assets of interest:
    • Enhanced search bar with customizable search pre-filters.
    • Simplified search result filter pane, search result asset content layout, and pagination.
    • Additional information pane to show important details about the selected asset.
  • Asset notification. Improvements include filtering and export options.
  • Clone a resource configuration. Accelerates the creation of resources with similar type and settings.
  • New Catalog Administrator contextual walkthroughs. Accelerates the onboarding of Catalog Administrator:
    • Introduction to Home page
    • Create a Resource
    • Create a Custom Attribute
    • Create a Data Domain
    • Overview of Security and Permissions Management
  • New Enterprise Data Catalog contextual walkthroughs. Provides an overview of the following features:
    • Application Configuration
    • Business Term Overview
    • Data Domain Overview
    • Curate Data Domains
    • Resource Overview

Analytics

  • Data Asset Analytics enhancements
    • Expose and document the Data Asset Analytics views that allow users to connect to report type datasets through any business intelligence tools.
    • Data Asset Analytics repository support for the following databases:
    • Microsoft SQL Server Named instance.
    • Oracle RAC with SCAN type connection.
    • Enhancements to improve user experience.
  • Data Flow Analytics (Technical Preview):
    • Data Flow Analytics for data mapping insight and discoveries with AI/ML to accelerate data modernization, improve data mapping efficiency, and reduce operational cost
    • Data Flow Analytics for PowerCenter mappings automates the following discoveries:
    • Similar mapping groups and the representative mapping within each group.
    • Duplicate mappings
    • Mapplet candidates
    • Reusable transformation candidates
    • User-defined functions candidates

Technical preview functionality is supported for evaluation purposes but is unwarranted and is not production-ready. Informatica recommends that you use it in non-production environments only. Informatica intends to include the preview functionality in an upcoming release for production use but might choose not to in accordance with changing market or technical circumstances. For more information, contact Informatica Global Customer Support.

Scanners

  • Advanced Scanners integration:
    • Install Advanced Scanners. which are bundled with the Enterprise Data Catalog installer binary files.
    • Implemented native models for the following Advanced Scanners:
      • Code: Oracle, SQL Server, Teradata, IBM DB2, Netezza, and Sybase.
      • BI: SAS, Microsoft SSAS, and SSRS.
      • Legacy: Cobol and JCL.
      • ETL: Oracle Data Integrator, Talend DI, IBM DataStage, and Microsoft SSIS.
      • Support for connection-less configuration for the dependent systems.
    • Support for reference resources.
    • Support for connection assignments with other resource end-points.
  • Axon scanner enhancement: Ability to filter lifecycle statuses for each object types.
  • Added support for S3 compatible filesystem that is Scality Ring certified.
  • New Snowflake scanner with advanced view SQL parsing and cross resource connection assignment capabilities.
  • New Advanced scanner for Oracle Data Integrator and Talend DI.
  • SAP S/4 HANA scanner that works for both SAP ECC and SAP S/4HANA is now available with support for data profiling.

PAM Updates

  • Scanners:
    • Informatica Data Quality 10.5
    • Informatica Platform 10.5
    • Informatica PowerCenter 10.5
    • Business Glossary 10.5x
    • Erwin 2020Rx
    • Tableau 2020.x
    • SAP Business Objects 4.3
    • Oracle Data Integration 12.x
    • Talend DI 7.x
  • Deployment
    • Embedded deployment only (no support for external Hadoop cluster deployment)
    • Support added for RHEL 8.x
    • Support added for RHEL 7.9
    • Support added for Suse 15
    • Support added for Suse 12 SP5

Informatica Metadata Manager

  • Support for Microsoft Azure SQL DB
  • Upgrade to latest cumulative version of MITI 10.1.0
  • Security bug fixes, and TPL upgrades to latest versions
  • Support large lineage export with more than 5K lineage nodes

Data Privacy Management (DPM)

Privacy enhancement

  • Data Stores, Location, and Subject Requests drill-down pages on the Privacy Dashboard
  • Filters on the Privacy Dashboard to enable Privacy Analysts to find content faster

Domain discovery enhancements with Discovery Agent

  • Treats compressed files as folders, and files within compressed files are scanned and reported as individual files
  • Supports scans for image files (OCR Scans) - PDF with images, JPG, JPEG, BMP, TIFF, PNG
  • Supports scanning of emails in Office 365

Installer, Infrastructure & Supportability Enhancements

  • Hadoop cluster/infrastructure has been removed from the product and is replaced with MongoDB. MongoDB gets installed as part of the product installation.
  • Support for Silent Installation of DPM through a Silent Installer
  • Enhanced SAML support

PAM Updates:

  • Support for PostgreSQL as a repository for Data Privacy Management
  • Support for RHEL 8.0
  • Support for SuSe Linux 15.0
  • Support added for Suse 12 SP5
  • Lineage support for Informatica 10.4.1 and 10.5
  • Support for Axon 7.1
  • Domain Discovery and Subject Registry support for HDFS & Hive on CDP 7.1.1

Test Data Management

Enhancements

  • Support for encryption in the Data Masking transformation in the PowerCenter Designer and the Developer
  • Performance improvements in format preserving encryption rules
  • Improved dictionary usage in substitution masking
  • Support for UNICODE data in dictionaries in substitution masking
  • Support for Conditional Data Generation for XML files
  • Support for MinOccurs and MaxOccurs values in an XSD for Data Generation with XML files

Connectivity updates

 

  • Support for PostgreSQL as a repository for Test Data Management
  • Support for PostgreSQL as a repository for Test Data Warehouse
  • Support for Oracle Exadata for the Test Data Management repository
  • Support for Oracle Exadata for the Test Data Warehouse repository

Ecosystems and Connectivity

Amazon

  • S3 – Directory-level partitioning support for complex files in mappings that run on the Spark engine
  • S3 - Support for Scality RING Amazon S3 compatible storage
  • Redshift - Partitioning support for Amazon Redshift mappings that run in the native environment

Microsoft Azure

Azure Synapse

  • Support for ADLS Gen2 as a temporary storage in the native environment or on the Spark or Databricks Spark engine
  • Table and schema override support for sources and targets
  • Staging file compression (Gzip) support to load data to the target for mappings that run on the Spark engine
  • Support for reading case-sensitive data from the database
  • Parquet file format support on staging for mappings that run in the native environment or on the Spark or Databricks Spark engine
  • Datetimeoffset, Date, and Smalldate data types support for mappings that run on the Databricks Spark engineADLS Gen2 as a temporary storage (Native/Spark/Databricks)

ADLS Gen2

  • Directory-level partitioning support for complex files in mappings that run on the Spark engine
  • Support for wildcard characters while reading file names (Technical preview)
  • Support for recursive read from subdirectories (Technical preview)
  • JDBC V2
  • Support for the Create Target option
  • Support for dynamic mapping
  • JDBC V2
    • Support for the Create Target option
    • Support for dynamic mapping
    • Support for SAP HANA
  • Snowflake
    • Read and write support to Snowflake data warehouse Google Cloud Platform as staging
    • Audit support for Snowflake read operations for mappings that run in the native environment or on the Spark engine  
  • Google
    • Cloud Storage - Support for File Name port
    • Pub/Sub - (DES) Reader
    • BigQuery - ODBC pushdown enhancement
  • SFDC
    • SFDC API v50.0 is certified
  • SFMC
    • Support for dynamic Mapping     
  • Relational:
    • Support for PostgreSQL v12
    • Support for Azure SQL DB CDC
  • No-SQL:
    • Cassandra ODBC driver is upgraded to the latest version
  • Enterprise Data Warehouse
    • Support for Greenplum V6
  • Hadoop:
    • Complex File Connector – Support for partitioned files
    • HBase - HBase on CDP 7.1 support for mappings that run on the Spark or Blaze engine
    • PowerExchange for Kudu – New adapter that supports write operations

PowerExchange CDC and Mainframe

PAM Changes

  • CICS/TS V4.3 had been deprecated
  • CICS/TS V5.6 has been added
  • Db2 LUW V11.5 has been added
  • Open SSL version has been upgraded

IBM i Improvements

  • IBM i (i5/OS) supports SSL connections

Informatica Platform

  • Sequential File Name can be overridden at run time

PowerExchange Command Improvements

  • LISTTASK enhanced reporting displays additional entities, such as User-id, File Name, Task/Subtask, etc.

B2B/ISD

ISD

  • Support on Databricks
  • Directory partitioning for Parquet, Avro, and ORC
  • New PDF preprocessor (very specific use case support)
  • Dynamic mapping support
  • Model generation based on XSD

DT

  • performance enhancement: to address validations of large files and concurrency
  • "nillable" support in XSD

Release Notes & Product Availability Matrix (PAM)

PAM:

Release Notes:

 

What’s New and Changed:  https://docs.informatica.com/data-engineering/shared-content-for-data-engineering/10-5/what-s-new-and-changed.html

What are we announcing?

Informatica 10.4.1.3

Who would benefit from this release?

This release is for Informatica Data Quality, Data Engineering, Data Catalog, Data Preparation & Data Privacy Management customers and prospects who want to take advantage of updated Hadoop distribution support as well as fixes to the core platform and other functionality. You can apply this service pack after you install or upgrade to Informatica 10.4.1. If you are already on 10.4.1 or 10.4.1.1 or 10.4.1.2 you can directly apply 10.4.1.3.

What’s in this release?

Data Engineering

PAM

  • Databricks 7.3
  • Amazon EMR 6.1

Data Quality

PAM

  • Cloudera CDP Public Cloud 7.2 - AWS
  • Cloudera CDP Private Cloud Base 7.1.4
  • Amazon EMR 6.1

Data Engineering Streaming

PAM

  • Cloudera Data Platform (CDP) Public Cloud 7.2 on AWS

Connectivity

  • Ability to switch connections to JDBC in Data Engineering Integration

Enterprise Data Catalog

  •      Roll-up of all emergency patches and bug fixes

Enterprise Data Preparation

PAM

  • Cloudera Data Platform (CDP) Data Center Edition 7.1.4
  • Amazon EMR 6.1

Data Privacy Management

Unstructured Scans through Remote Agent

  • Support for additional data domains

PAM

  • Axon 7.1
  • Cloudera Data Platform (CDP) 7.1.1 (Hive)

Java update – OpenJDK Java updated to version 1.8.0_265

Release Notes & Product Availability Matrix (PAM)

Informatica 10.4.1.3 Release Notes:  Informatica 10.4.1.3 Release Notes

PowerExchange Adapters for Informatica Release Notes: PowerExchange Adapters for Informatica Release Notes

Informatica Release Guide: https://docs.informatica.com/data-integration/shared-content-for-data-integration/10-4-1/release-guide--10-4-1-3-/preface.html

PAM for Informatica 10.4.1.3: https://network.informatica.com/docs/DOC-18676#comment-82535

HotFix Downloads link: https://network.informatica.com/downloadsView.jspa

What are we announcing?

The release of Informatica 10.4.1

 

Who would benefit from this release?

This release is for all customers and prospects who want to take advantage of the latest PowerCenter, Data Engineering Integration, Data Engineering Quality, Data Engineering Streaming, Data Privacy Management, Enterprise Data Catalog,  Enterprise Data Preparation and Test Data Management capabilities.

 

What’s in this release?

This Release provides new features, latest ecosystem & connectivity support, security enhancements, cloud support, and performance enhancements while improving the user experience.

 

In addition, Data Privacy Management and Test Data Management are now included in the Informatica Services installer to improve product compatibility.

Data Engineering Integration (DEI)

New Features:

  • Macro Transformation
    Provides dynamic functionality to transformation logic contained in a mapplet. You can add a transformation that does not support dynamic functionality to a mapplet and assign the mapplet to a Macro transformation.
  • Hierarchical Data on Hive Sources and Targets
    Read from and write to Hive tables with hierarchical data in a mapping that runs on the Spark engine. When you use Hive tables with hierarchical data, you can perform schema synchronization on the mapping.
  • SAML Authentication for Mass Ingestion
    Configure SAML authentication to log in to the Mass Ingestion tool. SAML authentication allows you to use a third-party identity provider to manage user credentials and authorization.

PAM Update

  • CDP-DC 7.1.x (Technical Preview)
  • CDH 5.13
  • WANdisco on HDP 3.14
  • WANdisco on CDH 6.3
  • Isilon support on HDP 3.1.4 with Single Zone

PowerCenter

  • Internet Protocol version 6 support:Informatica supports Internet Protocol version 6 (IPv6) address format in addition to the Internet Protocol version 4 (IPv4) address format.
  • Improved session error logging with new timezone and process ID information.
  • Oracle instant client support:  Enabled for PowerCenter Repository Service, PowerCenter Integration Service, and source and target connections.
  • Security: Update to third party libraries to improve overall security.   

Platform

  • Internet Protocol version 6 (IPv6) support: Deploy the PowerCenter domain, services, repositories, PowerCenter clients, and source and target connections on IPv6. All existing features of PowerCenter continue to work on IPv6.  IPv4 continues to be the default mode. See the support statement for more details  -  https://network.informatica.com/docs/DOC-16182 > Informatica Support Statement for IPv6
  • Domain authentication support: Added for F5 Networks BIG-IP SAML SSO and NetScaler IdP SAML SSO
  • Platform PAM
    • Database support added:  PostgreSQL 11.7
    • Java support updated - IBM JDK 8.0.6.10
    • Tomcat updated- 7.0.103
    • Browser support updated -
      • Microsoft Edge Chromium - Version 81.0.416.53
      • Chrome Version - 80.x
      • Microsoft edge - v44
      • Internet Explorer - 11.10x
  • Model Repository

Added support for the following version control systems:

  • GitHub Enterprise Server
  • GitLab
  • Bitbucket Server
  • SVN
  • Informatica Container Utility
    • Enterprise Data Catalog integration with embedded and existing clusters
    • Data Profiling and Content Management Service
    • Persistent volume support

 

Data Engineering Streaming (DES)

  • Streaming Data Integration
    • Parquet data format for Complex File targets: Persist streaming data into targets in Parquet formats.
    • Dynamic mapping enhancements: Run streaming mappings with dynamic mapping enhanced by refresh-schema-enabled mapping flow. Create dynamic ports in a transformation to receive new or changed columns from an upstream transformation.
    • Bulk ingestion of streaming data: Ingest CDC data from multiple Kafka topics into HDFS and partitioned Hive tables.
    • Improved Hadoop certifications: Cluster security solution certifications.
  • Cloud Streaming Support
    • Databricks on AWS: Run streaming mappings on the AWS Databricks service in AWS cloud ecosystems.
    • Additional connectivity on Databricks: Amazon Kinesis, Amazon Kinesis Firehose, and Amazon S3.
    • JDBC V2 lookup transformation on Databricks cluster.
  • Connectivity Enhancements
    • Apache Kafka and Confluent Kafka support on Databricks.
    • Filename port support for Microsoft Azure Data Lake Store Gen2.
    • Rollover size and time parameters added for ADLS Gen2 and S3 targets (Technical Preview).

Enterprise Data Preparation (EDP)

New Features:

  • Filtered data import into the lake
  • User interface performance improvements
  • Functional improvements of data-preparation capabilities on Amazon S3 data lake

PAM Update

  • CDH 5.13
  • Isilon support on HDP 3.1.4 with Single Zone

 

Enterprise Data Catalog (EDC)

  • Data Asset Analytics: Optimize the data asset value in your data catalog by using analytics on data asset inventory, usage, enrichment, and user collaboration. You can either generate reports or directly connect to event data assets in Data Asset Analytics from business intelligence tools. The event data assets include information on user logins, searches, asset inventory over time, asset changes, asset configuration scan history, user collaboration, asset enrichment, asset lineage, and asset impact.
    You can also use the real-time out of the box dashboards in Data Asset Analytics for storytelling on user adoption, asset inventory, asset enrichment, collaboration, and data value.  Each dashboard comes with real-time, pertinent key metrics, trend charts, and filters for quick analysis.
  • Enhanced change summary: Identify changes to assets more efficiently by using the filter and search options. You can also export the change summary results as a CSV file.
  • Contextual walkthroughs: Accelerate onboarding of new catalog users with in-application tutorials like:
    • Introduction to Catalog Homepage
    • Introduction to Search Results
    • Introduction to Table Overview
    • Introduction to Lineage
    • Introduction to Column Overview
    • Enhancing Asset Credibility
  • Resource configuration permission: Grant resource management permissions to user groups, such as catalog administrators. You can also grant resource management permissions to users while creating a resource.
  • Service and Resource Log Collection: Collect logs for Catalog service and the corresponding Yarn applications, specific resources based on resource name (Technical Preview)
  • Uninterrupted Catalog Backup: Back up the catalog without disabling the Catalog Service (Technical Preview)
  • Discovery
    • Override rules for data domain discovery: You can control the data domain behavior if metadata and data rules conflict with each other.  Conflict resolution reduces the number of false positive data domain assignments in the catalog.
    • Auto assignment of Business Glossary terms
      • Handle cases that are not in order.
      • Factor word-based weight calculation into the overall match score to improve accuracy and reduce false positive cases.
  • Scanners
    • IBM InfoSphere DataStage is now GA.
    • SAP BW is now GA.
    • SAP BW/4HANA is now GA.
    • SAP ECC and S/4HANA: New scanner to extract SAP objects, attributes, descriptions, relationships, transaction codes, programs, and function modules. You can use the SAP Central Instance or SAP Load Balancer connection type. (Technical Preview)
    • ETL scanners improvements: View field-level lineage for flat files.
    • Informatica Cloud Services: View file lineage for cloud storage.
    • Microsoft SSIS: View detailed lineage for transformations, extract metadata from the SSIS database, view the field-level lineage for flat files, and view the control summary of SSIS assets.
    • MicroStrategy: Support for incremental loading and viewing lineage at the report level.
    • Informatica Master Data Management (MDM): Extract metadata from the MDM data source through APIs and view detailed lineage.
    • File partition detection for file system scanners: Identify and publish partitioned files as a single file in the Catalog.
    • Parquet file profiling on Amazon S3 and ADLS Gen2: Support for column profiling and data domain discovery of parquet files on Amazon S3 and ADLS Gen2.
    • ADLS Gen 2 (Profiling): Support for column profiling and data domain discovery for structured files, unstructured file types, and extended unstructured formats.
    • Cassandra (Profiling): Profile Cassandra database tables and views to extract column profiling and data domain discovery statistics.
    • Contextual lineage support for the custom metadata framework: Allows representation of lineage for the same object with multiple execution instances.
    • Hive and Microsoft SQL Server scanner improvements: Reference objects enabled for external database objects allowing to link object across resources through connection assignments.

PAM Update

Scanners:

  • Informatica Platform 10.4.1
  • Informatica PowerCenter 10.4.1
  • Informatica Business Glossary 10.4.1
  • Informatica Data Quality 10.4.1
  • Teradata 16.20
  • DB2 z/OS 12
  • SSIS 2012 to 2016
  • Informatica MDM 10.4

Deployment:

  • EDC (External Clusters)
    • CDH 5.13.x
    • HDP 3.1.4 on Isilon
    • Data Asset Analytics:
      • Oracle DB 18c, 19c
      • MS SQL Server 2017, 2019
      • PostgreSQL 10.6

Informatica Metadata Manager

  • New HTML based data lineage diagramming, replacing Adobe Flash based lineage diagrams.
  • Support for IPv6 naming convention for nodes

 

Data Privacy Management (DPM)

  • New model for domain discovery of unstructured sources: 

A new approach to scanning unstructured data sources for domain discovery with the following benefits:

  • 4x performance improvements with a Remote Agent option that is deployable closer to data sources.
  • Processing of scans on a server separate from the DPM hosted server.
  • Includes natural language processing, keywords, and file tags to improve accuracy.
  • Capture of additional file metadata to provide greater visibility into data  context supporting data minimization and privacy and security operations.
  • An algorithm for calculating confidence scores.
  • Delta scans based on file metadata.
  • A new flat view for listing all unstructured files to support large lists

Users can choose to use existing scan mechanisms or the new Remote Agent-based scans for supported sources. Refer to the DPM Product Availability Matrix (PAM) for a list of unstructured sources supported by the Remote Agent.

  • Privacy Dashboard:

A new Privacy Dashboard for expanded insights into privacy status and privacy-oriented metrics with the following advantages:

  • Provides a quick one-stop view of the status of privacy operations.
  • Call-to-action alerts for critical time-bound subject-related tasks.

Users can easily switch between the Privacy and Security dashboards if they are entitled to the required privileges.

  • DPM Installer Updates:

Data Privacy Management is now included in the Informatica Services installer to improve product compatibility. The Informatica installer includes an option to install Data Privacy Management. This provides clarity on supported versions of Informatica Services and Enterprise Data Catalog when you plan scheduled updates for DPM. Refer to the DPM section in Platform PAM for Supported Operating Systems and Databases for repositories on which DPM can be installed.

  • PAM Updates:
    • Added support for the following repositories:
      • Microsoft SQL Server 2019
      • Oracle 19
  • Added connectivity support for domain discovery and subject registry:
    • Microsoft SQL Server 2019
    • Oracle 19c
    • SAP Hana
    • Snowflake (native)

Test Data Management

Installer:

The Test Data Management installer is now merged with the Informatica Services installer. To install Test Data Management, install Informatica domain services and choose the appropriate install option. The latest version of Test Data Management will now be available with the latest Informatica platform version.

Enhancements:

  • Support for IPv6 naming convention for nodes
  • Fixed high-risk vulnerabilities in application code
  • Optimize dictionary value usage when using substitution masking
  • Improved logging for substitution masking
  • Support for Test data Warehouse in a multi-realm Kerberos environment

Connectivity Updates:

  • Support for new versions of the following databases and distributions: MongoDB, Cassandra, Teradata
  • Support for new version of Cloudera distribution
  • Support for new versions of Mainframe operating (iOS and zOS) and the corresponding IBM DB2 versions and IMS versions have been updated.

See the Product Availability Matrix (PAM) for details.

Data Engineering Quality (DEQ)

  • PAM Update
    • Support Oracle Connection Manager (OCM) for reference tables and exception management

Ecosystems and Connectivity

  • Amazon:

PowerExchange for Amazon Redshift (Data Engineering Integration, Data Quality)      

  • The Amazon S3 bucket to create staging files can be in a different region than the Amazon Redshift cluster.
  • Support to use Amazon Resource Name (ARN) key for SSE-KMS enabled buckets.

PowerExchange for Amazon S3 (Data Engineering Integration, Data Quality)

  • Use a manifest file to read data from Amazon S3 in the native environment.
  • Support to read data from and write data to the Hong Kong region.
  • Directory read support for the binary file format.
  • Support to use the Amazon Resource Name (ARN) key for SSE-KMS enabled buckets.
  • Support to update proxy server settings in the "developer.ini" file.
  • Microsoft Azure:

PowerExchange for Microsoft Azure Data Lake Storage Gen2 (Data Engineering Integration, Data Quality):

  • Read and write ORC flat files in the native environment, on the Spark engine, and on the Databricks engine.
  • Read and write JSON flat files in the native environment.
  • Configure the Azure Government endpoints in mappings in the native environment and on the Spark engine.
  • Configure the authenticated proxy server settings for the Data Integration Service to connect to Microsoft Azure Data Lake Storage Gen2.

PowerExchange for Microsoft Azure SQL Data Warehouse (Data Engineering Integration, Data Quality):

  • Read data from or write data to a Microsoft Azure SQL Data Warehouse endpoint that resides in a virtual network (VNet).
  • Snowflake
    PowerExchange for Snowflake (Data Engineering Integration, Data Quality):
    • Support for external tables as Snowflake sources.
    • Support for materialized views as Snowflake sources.

PowerExchange for Snowflake (PowerCenter):

  • Support for target update overrides in the Snowflake target.
  • Support for "on error abort" for Snowflake target sessions.
  • Support to use external tables as Snowflake sources.
  • Support to use materialized views as Snowflake sources.
  • Google
    PowerExchange for Google BigQuery (Data Engineering Integration, Data Quality):
    • Support for connected and unconnected lookups.
    • Support for Google BigQuery regions available on Google Cloud Platform.

PowerExchange for Google BigQuery (PowerCenter)

  • Support for CDC as a target for Google BigQuery.
  • Support for Google BigQuery regions available on Google Cloud Platform.
  • Support for connected and unconnected lookups.
  • Pushdown optimization enhancements
  • SFDC
    PowerExchange for Salesforce (PowerCenter, Data Quality)
    • Support for Salesforce API version 48.0.
  • SAP

PowerExchange for HANA (PowerCenter)

      • Requires a license (since 10.4).
      • HANA database support for calculation and analytical views.

PowerExchange for NetWeaver (PowerCenter)

      • Dropped support for non-unicode SAP systems (since 10.4).
      • Support to read from SAP tables, views (including CDS views) in HTTP mode of execution using PowerExchange for SAP Dynamic ABAP Table Extractor.
      • Enhancements in SAP Table Reader performance.

PowerExchange for NetWeaver (Data Quality)

      • Support for SAP Table Reader CDS views.

Relational:

    • IPv6 certification for DB2, JDBC, Microsoft SQL Server, ODBC, and Oracle in Data Quality.
    • IPv6 certification for DB2, Microsoft SQL Server, ODBC, Oracle, Sybase ASE and Sybase IQ in PowerCenter.
    • Support to connect to Oracle by using Oracle Connection Manager (OCM) in PowerCenter and Data Quality.
  • No-SQL:
    PowerExchange for MongoDB JDBC (PowerCenter)
    • Introduced a new native adapter "PowerExchange for MongoDB JDBC", with MongoDB 4.2 certification on PowerCenter.
  • Enterprise Data Warehouse

PowerExchange for Greenplum (PowerCenter)

  • Certification for Greenplum 5.8.x GPLoad connectivity on Windows 2012 R2 platform.

PowerExchange for Db2 Warehouse (PowerCenter)

  • Certification for PowerExchange for Db2 Warehouse on AIX and Windows using v11.5 IBM Data Server Driver Package (DS Driver).
  • Hadoop:
    PowerExchange for Hive (Data Engineering Integration)
    • Support to read and write Hierarchical (Htype) data type from Hive tables in a mapping that runs on the Spark engine.
  • Technology:

PowerExchange for Kafka (PowerCenter)

  • Support for additional security properties, such as SASL_PLAINTEXT authentication.

 

PowerExchange CDC and Mainframe

 

  • PAM Changes

Added support for database versions and editions:

  • Adabas Version 8.5.1 on z/OS
  • PostgreSQL Version 12.1 on Linux, Unix, and Windows for CDC
  • MySQL Community Edition on Linux and Windows for CDC, and Amazon Relational Database Service (RDS) implementations of MySQL for CDC with certain prerequisites

Note: Informatica has tested PowerExchange CDC for MySQL Community Edition using the native MySQL ODBC driver. PowerExchange does not provide this driver.

  • IBM i Installer Improvements
    • The IBM i Installer interface includes improvements based on early user feedback, including menu options to save installation parameters to a file, generate an encrypted password, and view the installation log file,  For more information, see the PowerExchange documentation.
  • Security and Connectivity Enhancements
    • For Db2 for z/OS sources, PowerExchange now detects and supports the use of IBM Db2 Huffman compression algorithms. While this support is mostly transparent to users, PowerExchange produces messages to indicate where Db2 Huffman compression has been detected.
  • Performance Enhancement for PowerExchange Express CDC for Oracle in ASM Environments
    • You can optionally write chunks of Oracle redo log to a staging file to improve CDC performance, significantly increase data throughput, and reduce CPU usage in an ASM environment. This feature, previously provided under controlled availability, is now generally available.

 

B2B

 

Intelligent Structure Discovery Enhancements for Data Engineering Integration and Data Integration Streaming:

  • Data type inference for Avro, Parquet and ORC files now uses the same data types that the native connectors use, resulting in unified output across platforms.
  • You can select which element in an array structure is the root node to prevent data loss in the output. For example, when you use an intelligent structure model in midstream in a mapping.

 

Release Notes & Product Availability Matrix (PAM)

 

PAM:

Informatica Platform 10.4.1: https://network.informatica.com/docs/DOC-18676

Test Data Management 10.4.1: https://network.informatica.com/docs/DOC-18677

 

Release Notes:

You can download the Hotfixes from: https://network.informatica.com/downloadsView.jspa.

What are we announcing?

Informatica 10.4.0.2

 

Who would benefit from this release?

This release is for all Informatica Data Quality, Data Engineering, and Data Catalog customers and prospects who want to take advantage of the updated Hadoop distribution support. This release also has fixes to core platform, connectivity and other functionalities. You can apply this Service Pack after you install or upgrade to Informatica 10.4.0. If you are already on 10.4.0 or 10.4.0.1, you can directly install 10.4.0.2.

 

What’s in this release?

This update provides the latest ecosystem & connectivity support, cloud support, and bug fixes.

 

Data Engineering

 

PAM

  • HDP 3.1.5
  • ADLS Gen 1 support for HDI 3.6

 

Enterprise Data Catalog

 

Application

  • Data domain curation using object import:

PAM

  • HDP 3.1.5

 

Enterprise Data Preparation

 

PAM

  • HDP 3.1.5
  • ADLS Gen 1 support for HDI 3.6

 

Release Notes & Product Availability Matrix (PAM)

 

Informatica 10.4.0.2 Release Notes: https://docs.informatica.com/data-engineering/shared-content-for-data-engineering/10-4-0/release-notes--10-4-0-2-/preface.html

 

PAM for Informatica 10.4

 

You can download the Service Pack files from here.

What are we announcing?

Informatica 10.4.0.1

Who would benefit from this release?

This release is for all Informatica Data Quality, Data Engineering and Data Catalog customers and prospects who want to take advantage of the updated Hadoop distribution support as well as fixes to core platform, connectivity, and other functionality. You can apply this Service Pack after you install or upgrade to Informatica 10.4.0. If you are already on 10.4.0, you can directly install 10.4.0.1.

What’s in this release?

Data Engineering PAM

  • HDI 3.6 WASB support

Data Engineering Streaming

  • General availability of Databricks Delta Lake targets in streaming mappings
  • General availability of Snowflake targets in streaming mappings
  • General availability of dynamic mapping support with Confluent Kafka sources in streaming mappings
  • Latest Apache Kafka 2.4, Confluent Kafka 5.4 & other PAM support
  • Performance enhancements

Connectivity 

  • Complex Files (DEI): When you read from or write data to complex files, the FileName port now includes data from the absolute path including the file name.
  • PowerExchange for Microsoft Azure Data Lake Storage Gen2: Reads data from the FileName port that contains the endpoint name and source file path.

Enterprise Data Catalog

      Scanners

  • Qlik Sense: New resource to extract metadata from applications, stories, and sheets. You can also view lineage derived from the data source.
  • Apache Kafka: New resource to extract metadata from topics in an Apache Kafka cluster. Enterprise Data Catalog integrates with Informatica Intelligent Structure Discovery to discover the message format or leverage the Confluent Kafka Registry.
  • MongoDB: New resource to extract metadata from collections. Enterprise Data Catalog integrates with Informatica Intelligent Structure Discovery to discover the record format. The resource supports metadata extraction only.

Application

  • In the Compact View for lineage enhancements, added transformation logic and expand and collapse functionality for all resources.

PAM

Support for:

  • Microstrategy 11.x
  • PowerCenter 10.2HF2
  • QlikSense 3.2
  • Apache Kafka 2.3.0 and Confluent Kafka 5.3.1
  • MongoDB 2.6, 3.4, 3.6, 4.0 and 4.2

Enterprise Data Preparation

  • Support for HDI 3.6 with WASB

Release Notes & Product Availability Matrix (PAM)

Informatica 10.4.0.1 Release Notes:  https://docs.informatica.com/data-engineering/shared-content-for-data-engineering/10-4-0/release-notes--10-4-0-1-/abstract.html

PowerExchange Adapters for Informatica Release Notes: https://docs.informatica.com/data-integration/powerexchange-adapters-for-informatica/10-4-0/powerexchange-adapters-for-informatica-release-notes-10401/abstract.html

Informatica Release Guide: https://docs.informatica.com/data-engineering/shared-content-for-data-engineering/10-4-0/release-guide--10-4-0-1-/version-10-4-0.html

PAM for Informatica 10.4.0.1:  https://network.informatica.com/docs/DOC-18443#comment-59638

You can download the Service Packs from here.

What is being announced?

 

Starting with the release of Informatica Platform 10.4, Solaris 11 Server will no longer be supported. Informatica Platform is a set of data services and information solutions powered by a state-of-the-art data management engine. The End of Life Announcement  is applicable for the following products:

  • PowerCenter
  • Big Data Management (BDM), Enterprise Data Catalog (EDC), Enterprise Data Preparation, (EDP), and Big Data Streaming (BDS) *
  • Data Quality (DQ)
  • Data Transformation (B2B DT)
  • Test Data Management (TDM) and Data Archive
  • Data Validation Option (DVO)
  • Data Integration Hub (DIH)
  • B2B Data Exchange (DX)
  • Metadata Manager, Profiling and Business Glossary
  • Master Data Management (MDM) including Multidomain MDM, Customer 360, Supplier 360, Product 360*, and Informatica Identity Resolution (IIR)

* These products currently do not support Solaris platform.

 

Why is Informatica announcing this product end of life?

 

In 2017, Oracle changed the roadmap for Solaris when they switched to Solaris 11.next instead of Solaris 12, a minor release that would cater only to security fixes and patches but no new features or advances in the operating system. Oracle will continue to provide minor updates to the Solaris operating system and promises to sustain support through 2034, but they do not plan to release major updates in the future. Recent product download data, customer support calls, and sales trends show decline in Solaris share.

 

How will this impact customers?

Informatica supports customers on Solaris servers on versions of Informatica that currently support Solaris and will continue to do so for as long as those versions are supported by Informatica. You could also refer to the EOL Announcement published on Informatica Network. For the full list of End of Life (EOL) announcements please refer to the Informatica Products EOL Notification.

 

What alternative does a customer have?

As part of an ongoing effort to enable organizations to derive more business value from their investments, Informatica has decided to focus its efforts on delivering superior technology and timely solutions on those platform combinations that are themselves benefiting from investment by their respective vendors. To avoid critical impacts to the business operation, customer should consider planning for a smooth transition to other IT platforms.

 

Informatica Global Customer Support

For more information, questions, or issues around any Informatica product, open a Support Case through Informatica Network. For additional information on Informatica Global Customer Support, refer to the Informatica Global Customer Support Guide.

What are we announcing?

The release of Informatica 10.4

 

Who would benefit from this release?

This release is for all customers and prospects who want to take advantage of the latest PowerCenter, Data Engineering Integration, Data Engineering Quality, Data Engineering Streaming, Enterprise Data Catalog, and Enterprise Data Preparation capabilities.

 

What’s in this release?

This update provides the latest ecosystem & connectivity support, security enhancements, cloud support, and performance enhancements while improving the user experience. Also, the Big Data product family is renamed to Data Engineering.

 

The following product names have changed:

  • Big Data Management has changed to Data Engineering Integration.
  • Big Data Quality has changed to Data Engineering Quality.
  • Big Data Streaming has changed to Data Engineering Streaming.
  • Big Data Masking has changed to Data Engineering Masking.

 

Enterprise Data Catalog and Enterprise Data Preparation are aligned within the Data Catalog product family.

Data Engineering Integration (DEI)

Enterprise Class

  • CI/CD & REST initiatives: Use REST APIs to deploy, update, and query objects and to compare mappings that you develop in a CI/CD pipeline.
  • CLAIRE® recommendations and insights: Provides best practices recommendations for mappings during design time. It also gives insights into mapping design patterns.
  • Debugging enhancements: Collect aggregated cluster logs for a mapping in the Monitoring tool or by using an infacmd ms command.
  • Blockchain support: Connect to a blockchain to use blockchain sources and targets in mappings that run on the Spark engine. (Technical Preview)

Advanced Spark

  • Data Processor on Spark: Process unstructured and semi-structured file formats using the Data Processor transformation on the Spark engine.
  • Profiling on Spark: Run profiles and choose sampling options on the Spark engine. You can perform data domain discovery and run scorecards on the Spark engine.
  • Hierarchical Data Processing enhancements:
    • Midstream hierarchical data parsing: Parse hierarchical JSON and XML data in a midstream string port using intelligent structure models and complex functions.
    • Data preview: Preview hierarchical data using the Spark Jobserver in the Amazon EMR, Cloudera CDH, and Hortonworks HDP environments. Spark Jobserver allows for faster data preview jobs.
    • Intelligent Structure Discovery improvements: Processes additional input types such as ORC, Avro, and Parquet, creates an intelligent structure model from a sample file at design time and arranges unidentified input data in the sample file as a structured JSON format in the output model.

PowerCenter

  • Security: Support for cross-realm Kerberos authentication and multiple LDAP servers in a single Informatica domain
  • Leverage cloud infrastructure: Installing PowerCenter on AWS is easier with added support for Azure Linux as server OS and PostgreSQL as a repository database
  • Transformation enhancements: Enhanced ability to consume REST web services using an HTTP transformation with added support for PUT, PATCH and DELETE methods
  • Productivity enhancements: New refresh option to refresh metadata in the PowerCenter Designer and Workflow Manager without requiring you to log in again
  • New connectors: PowerExchange for DB2 Warehouse, PowerExchange for PostgreSQL, PowerExchange for Dynamics 365 Sales (Rest API Based)

Operational Insights

  • New Advanced Edition:  New paid offering, Operational Insights Advanced Edition on top of Operational Insights Base Edition, which is free
  • New Operator Console: Operational analytics console with a projects view for effectively viewing PowerCenter, Data Engineering Integration, Data Engineering Quality, and Data Quality operational data with permissions management with Advanced Edition
  • Claire alerts: Auto-detection and alerts for job anomalies in PowerCenter workflows based on the elapsed time and data processed with Advanced Edition

Platform PAM

·      Database support added:

    • Oracle 19c
    • PostgreSQL
    • SQL Server 2019

·       Operating system support added:

    • Amazon Linux2
    • Ubuntu
    • Windows 2019 Server
    • zLinux

·       Operating system support dropped:

    • Solaris

· Java support

    • Azul OpenJDK 1.8.0_222
    • IBM JDK 8.0.5.40
    • Tomcat 7.0.96
  • Browser support
    • Microsoft Edge Browser (Win 10) 44.18
    • Internet Explorer 11.x
    • Google Chrome 75.x
    • Safari 12.1.1

Platform Update

  • Support for cross realm Kerberos authentication to allow Informatica nodes, application services, and users to belong to different Kerberos realms.
  • Support for Smart card-based Kerberos single sign-on.
  • Support for multiple LDAP servers in a single Informatica domain.
  • Support for Oracle Universal Directory for LDAP authentication.
  • Support for defining custom LDAP types.
  • Support for Microsoft Azure Active Directory for secure LDAP authentication.
  • Support for Microsoft Active Directory Federation Services 4.0 and PingFederate as Security Assertion Markup Language (SAML) identity providers.

Model Repository

  • Version Control System Support added:
    • Collabnet Subversion Edge 5.2.4
    • Bitbucket Server 6.4
    • Perforce 2019.1
    • Visual SVN 4.0.2
  • Version Control System Support dropped:
    • Collabnet Subversion Edge 5.2.2
    • Perforce 2014.2
    • Visual SVN - 3.6, 3.7

Informatica Container Utility

Data Engineering Streaming (DES)

 

Streaming Data Integration

  • Data Quality transformations in streaming mappings: Apply real-time Data Quality transformations to streaming data.
  • Lineage for streaming mappings: Ability to view the lineage for streaming mappings in Enterprise Data Catalog.
  • Enhanced OS support: Data Engineering Streaming is now supported on SuSE Linux.
  • Dynamic mapping support: Ability to run streaming mappings with dynamic mapping support. (Technical Preview)
  • CLAIRE®integration for industry standard data parsing: Ability to parse HL7 messages using Intelligent Structure Discovery integration. (Technical Preview)
  • Enhanced support for CDC ingestion to Hadoop.
  • Enhanced monitoring capabilities for streaming jobs.
  • Latest Spark and Hadoop distribution support.

Streaming Analytics

  • Confluent schema registry support: Ability to parse complex messages from Kafka using schema from schema registry.
  • SSL support with Kafka: Ability to connect to secure Kafka cluster.

Cloud streaming support

  • Ephemeral cluster support: State support in cloud repositories and workflow support.
  • Serverless streaming in Azure Databricks: Ability to run streaming jobs in an Azure Databricks cluster.

Enterprise Data Preparation (EDP)

 

  • Upload files directly to the data lake: Data analysts and data scientists can now initiate the data preparation process by uploading files directly to the data lake, without waiting for IT to fulfill their request.
  • Microsoft Excel support: Excel files are now supported for data preparation. CLAIRE® technology helps in automatic table structure discovery used for data preparation and publication. (Technical Preview)
  • Publish as files: File-based data assets can now be prepared and published to the data lake as files without dependence on hive or relational layer.
  • ADLS Gen2 support: Support for file-based data preparation on ADLS Gen2.
  • NULL value handling: Intelligent handling of NULL values during data preparation and publication.
  • Privilege control: You can now enforce privilege control on various user activities.
  • Stabilization and performance: Stabilization and performance improvements of data preparation projects from intermittent failures and slowness.

Enterprise Data Catalog (EDC)

 

Scanners

  • Snowflake: New scanner that can extract object and lineage metadata. Lineage metadata includes view to table lineage.
  • Cassandra: New scanner to extract metadata Cassandra keyspaces, tables and views. Profiling is not supported.
  • AWS Glue: New scanner to extract metadata from the Glue catalog. The Glue scanner can extract metadata from sources in the AWS environment (S3, Redshift, DynamoDB, RDS) as reference objects. Scanner draws lineage from Glue objects to source objects. Lineage for ETL jobs is not supported.
  • Informatica Data Quality:
    • Extract rules, scorecards definitions and results as well as profiling and data domain discovery statistics from an IDQ or a BDQ model repository service and profiling warehouse. Users who have built Data Quality processes in IDQ/BDQ can now extract the quality scores and visualize them in EDC.
    • Extract profiling and data domain discovery statistics from an IDQ or a BDQ profiling warehouse. Users who have already run profiling and enterprise discovery in IDQ/BDQ can now extract these profiling results and visualize them in EDC.
  • Azure Power BI: New scanner to extract metadata for Workspaces, Dashboard, Reports, Datasets and Dataflows as well as lineage between them.
  • Google Cloud Storage: New scanner to extract metadata from files and folders. Refer to the PAM for supported file formats. Profiling is not supported.
  • SAP BW: New scanner to extract metadata, lineage, and relationships between SAP Business Warehouse objects. Profiling is not available. (Technical Preview)
  • SAP BW/4HANA: New scanner to extract metadata, lineage, and relationships between SAP BW/4HANA objects. Profiling is not available. (Technical Preview)
  • Informatica Data Engineering Streaming: The Informatica platform scanner now supports extracting metadata from streaming mappings, including streaming sources. Streaming sources are created as reference objects.
  • Google Big Query (Profiling): Support for column profiling and data domain discovery.
  • SAP HANA Database (Profiling): In addition to the extraction of the metadata, EDC is now capable of profiling the SAP HANA database tables and views to extract column profiling and data domain discovery statistics.

Scanner Framework

  • Reference Objects: Extract data lineage and referred objects directly from ETL, BI, and catalogs. Users can search, annotate, govern and view lineage for reference objects.
  • Offline scanner support added for:
    • Amazon Redshift
    • Amazon S3
    • Azure Data Lake Store
    • Azure Microsoft SQL Data Warehouse
    • Azure Microsoft SQL Server
    • Google BigQuery
    • Microsoft Azure Blob Storage
    • Salesforce
    • Workday
    • Axon
    • Business Glossary
    • Custom Lineage
    • Database Scripts
    • Informatica Intelligent Cloud Services
    • Erwin
    • SAP PowerDesigner
    • IBM Cognos
    • QlikView Business Intelligence
    • SAP HANA
    • Snowflake
    • AWS Glue
    • Google Cloud Storage
    • SAP BW
    • SAP BW/HANA
    • PowerBI
    • Cassandra
  • Custom Scanner Enhancements:
    • Support for profiling of sample files: Author of custom metadata can now provide sample data files that will be used to compute profiling statistics.

Business User Experience

 

  • Summarized lineage view: Users can view lineage at any level from the highest, system-wide view to the granular, field-level view. (Technical Preview)
  • Lineage filters: Users can now apply filters on the lineage view to hide object types and associated links from the view for better clarity.
  • Control lineage: Object dependency generated by SQL statement Where clauses or lookup are considered as control lineage and now reported in EDC in the tabular summary view of the lineage diagram.
  • Resource-level attributes: Administrators can create custom attributes assigned to specific resources instead of the class type of any resource.
  • Export from search results: Users can now export a list of objects from search results. Import is now possible at a global level containing objects from multiple sources. Import and export jobs can be monitored in a central UI.

Data Provisioning (GA)

 

  • Data Provisioning: After discovery, users can now move data to a target where it can be analyzed. EDC works with IICS to provision data for end-users. Credentials are supplied by the users for both the source and the target.

Sources:

    • Databases: Oracle, SQL Server, Teradata, Hive, Redshift, Azure SQLDB, Azure SQL DW, JDBC
    • Data Lakes: S3, ADLS, Blob, HDFS
    • Applications: Salesforce

Targets:

    • BI: Tableau Server, Qlik,
    • Data Lakes: S3, ADLS, Blob,  HDFS, Google Cloud Storage
    • Databases: Hive, Redshift, Google Big Query, Azure SQLDB, Azure SQL DW, JDBC, Teradata, Oracle, SQL Server
  • Live Data Preview: Users can now preview source data at the table level by providing source credentials.

CLAIRE®

 

  • Unique Key inference: The derived key (PK) information from datasets allows users better understand the characteristics of datasets.
  • Data Domain Discovery in Text (CLOB) fields: Data Domain discovery is now applied to CLOB fields during database source profiling.
  • Scalability
    • Profiling on spark:  Administrators can run profiles using the Spark engine for selected sources.

PAM

 

  • Deployment Support Added
    • Hortonworks HDP 3.1 GA
  • Source Support
    • Hive, HDFS on CDH 6.1, 6.2
    • Hive, HDFS on HDP 3.1
    • Informatica Data Quality 10.2HF2, 10.4
    • SAP BW 7.4 and 7.5
    • Oracle 19c
    • MS SQL Server 2019
    • Cassandra 3.11
    • Informatica Platform 10.2 HF2, 10.2.2HF1, 10.4
    • Informatica PowerCenter 10.2 HF2, 10.4
    • Azure Power BI
    • Google Cloud Storage
    • AWS Glue
    • Snowflake

Data Engineering Quality (DEQ)

 

Scalability

  • Profiling on Spark:  Administrators can now run profiles using the Spark engine for selected sources.

Features

  • Address Verification: Update to Address Verification Engine to 5.15

(PAM and Platform updates as per DEI)

 

Cloud Ecosystems and Connectivity

 

  • Amazon:
    • S3 deferred policy check
    • Support for Aurora Postgres
    • Filename ports for both batch and streaming
  • Microsoft/ Azure:
    • ADLS Gen 2: New connector for the native and Spark environments including streaming across HDInsight and Databricks
    • SQL DW: VNET SE authentication support, PDO support via ODBC, Proxy support
    • Blob: Support for Shared Access Signature (SAS) authentication
    • Azure SQL DB: Support for managed instance
    • SQL Server always encrypted support
    • New Dynamics 365 Sales (common data service) support
  • Snowflake
    • Dynamic mapping support for Snowflake
    • Performance improvement
    • Database Push Down Optimization (PDO)
    • Support for Snowflake target in streaming mappings. (Technical Preview)
  • Google
    • BigQuery connector optimized in performance and scale for Sparkexecution
    • Support for global regions
    • Folders support for Google cloud storage
  • Databricks
    • Databricks is now supported on both Azure and AWS ecosystems as well as for Snowflake
    • Databricks Delta Lake support with additional transformations including Streaming pipeline support (Technical Preview)
  • SFDC
    • Support for API 47
    • Salesforce Marketing Cloud support
  • SAP
    • Core Data Services (CDS) support
    • Calculation and Analytics Views
    • Additional datatypes support including:  HANA DB LTRIM RTRIM
  • Oracle
    • Oracle 19c RAC support
    • Essbase 11.1.2.4 Certification
    • JD Edwards Enterprise One 9.2 Certification
  • Enterprise Data Warehouses
    • Greenplum 5.1 support
    • DB2 Warehouse on Cloud support
    • Minor enhancements to Teradata connector
  • Technology
    • New Kafka connector for PowerCenter and PowerCenter real-time.
    • PowerExchange for JDBC V2: Support for Spark and Databricks to connect to Aurora PostgreSQL, Azure SQL Database, or any database that supports the Type 4 JDBC driver.
    • Enhancements to Complex File, Teradata, MongoDB, Cassandra connectors
    • Enhanced ability to consume a REST service using an HTTP transformation with added support for the PUT, PATCH, and DELETE methods
    • Support for MQ 9.1, JMS 2.0

PowerExchange (PWX Mainframe & CDC)

 

PAM Changes

  • Database version support added:
    • Db2 for i 7.4
    • Db2 LUW V11.5
    • Oracle 18c
    • MySQL 8.0
    • PostgreSQL 10.x and 11.4
    • Windows 2019 for source & target
  • Dropped support for CICS/TS 4.1
  • Database version support dropped:
    • z/OS Adabas 8.1 and 8.2
    • z/OS Datacom 12 and 14
    • z/OS Db2 9.1 and 10
    • z/OS IDMS 17 and 18
    • z/OS IMS 10, 11, and 12
    • Db2 for I 7.1
    • LUW Oracle 11g R2 & 12c R1
  • Operating system support dropped:
    • z/OS 1.11, 1.12, and 1.13
    • i5/OS 7.1

New and Extended Utilities

  • A new IBM I installer that runs on Windows guides users through installing and configuring PowerExchange on i5/OS. It can perform full and upgrade installations.
  • The z/OS Installation Assistant now supports IBM PDSE data sets.
  • The new PWXUMAP utility provides additional reporting capabilities for data maps, extraction maps, and source schemas.
  • Performance of the DTLURDMO utility when processing a large number of data maps has been improved.

General Enhancement or Feature Updates

  • PostgreSQL has been added as a CDC source.
  • PowerExchange can now read DBD information from the IBM IMS catalog when you create data maps or at CDC or IMS unload run-time.
  • Oracle 18c has been certified for operation with PowerExchange. Oracle Express CDC to run as per previous versions of PowerExchange for Oracle CDC capabilities.

B2B

 

Intelligent Structure Discovery Enhancements for Data Engineering Integration and Data Integration Streaming:

  • Ability to process additional input types: ORC, Avro, Parquet.
  • Ability to process HL7 messages. (Technical Preview)
  • Users can create a model based on a sample file in Data Engineering Integration at design time, without having to go through the Informatica Cloud design flow first.
  • The output of unidentified data is structured in a JSON format.

 

PAM: https://network.informatica.com/docs/DOC-18443

 

Release Notes:

 

Release Guide: https://docs.informatica.com/big-data-management/shared-content-for-data-engineering/10-4-0/release-guide/version-10-4-0.html

What are we announcing?

Informatica 10.2.0 HotFix 2

 

Who would benefit from this release?

Customers who want to take advantage of fixes to the core platform and products based on it - PowerCenter, Data Quality, and Big Data Management. It includes support for new environments as well as fixes to support stable deployments.

 

PowerExchange for 10.2.0 HotFix 2 will be releasing on 17th May 2019.

 

What’s in this release?

  • Platform Update
    • Informatica domain support for cross-realm Kerberos authentication (using Global Catalog). Informatica nodes, application services, and users can belong to different Kerberos realms. Smart card based Kerberos single sign-on is also supported.
  • Platform PAM Update
    • Oracle 18c - Added
    • Azure SQL Database (single database, managed instances, and elastic pool) - Added
    • Java support
      • Azul OpenJDK 1.8.0_192 - Added
      • Oracle Java 8 - Removed
      • The Informatica platform now supports Azul OpenJDK, instead of Oracle Java because Oracle has changed its Java licensing policy, ending public updates for Java 8 effective January 2019. Azul OpenJDK comes bundled with the product.
      • IBM JDK 8.0.5.27 - updated
    • Authentication - Active Directory - Kerberos for Windows 2016, 2012 R, and LDAP for Azure Active Directory
    • Model Repository - Version control system support - GIT and Collabnet Subversion Edge
    • Other
      • Microsoft Edge Browser (Win 10) 41.16 - updated
      • Internet Explorer -11.x - updated
      • Google Chrome- 73.x - updated
      • Safari - 12.0.3 ( MacOS 10.13 10.14) - updated
  • Big Data PAM Update
    • Hadoop Distributions Updates
      • Cloudera CDH: 5.9, 5.10, 5.11, 5.12, 5.13, 5.14, and 5.15
      • Hortonworks HDP: 2.4, 2.5, 2.6
      • MapR: 5.2 with MEP 2.x, 3.x
      • Azure HDInsight: 3.6 supported
      • Amazon EMR 5.4.x, 5.8.x
    • Security Support:
      • LDAP
      • Kerberos support for the Informatica domain and Hadoop clusters
      • Kerberos authentication for clusters and LDAP authentication for Hive (USPS use-case)
      • MapR Tickets
      • MapR Tickets + Kerberos
      • Azure Active Directory
    • Authorization Support:
      • Sentry on all supported distributions
      • Ranger on all supported distributions
    • Encryption Support:
      • SSL / TLS
      • Encrypted zones / Transparent Data Encryption
      • Java based KMS
      • Ranger based KMS
      • Navigator based KMS
    • Resource Scheduling Support:
      • YARN queues
      • Node labeling
    • Perimeter Security Support:
      • Knox
    • High Availability Support:
      • Hive
      • HBase
      • Namenode
      • Resource Manager
      • Hive Metastore
      • Sentry
      • Ranger
      • KMS
      • Zoo keeper
    • Google Big Query: SQL Override and CustomQuery
  • Connectivity Updates
    • New Tableau v3 connector with support for Tableau Hyper target file format
    • Added support for Pushdown Optimization for PostgreSQL
    • Added ODBC based Pushdown Support for Google Big Query
    • Enhancement for Azure SQL DW PDO Support via ODBC
    • Upgraded ODBC and JDBC Drivers to 2.5.8
    • Connector Enhancements
      • Snowflake
      • Azure SQLDW
      • Redshift
      • AWS
      • SAP
    • CCI Enhancements to support new features across the connectors
  • PowerExchange Connector for Kafka
    • Support for Kafka connectivity for PowerCenter as source and target
  • Any Other
    • New PowerCenter transformation function for binary data processing
  • Informatica Metadata Manager PAM Update
    • Repository
      • Oracle 18c - Added
    • Sources
      • Oracle 18c - Added

      • Informatica PowerCenter 10.2 HF2 - Added

      • Informatica Platform 10.2 HF2 and 10.2.2 - Added

Release Notes & Product Availability Matrix (PAM)

Release Notes

 

Product Availability Matrix (PAM)

 

You can download the Hotfixes from here.

What are we announcing?

Informatica Service Pack Release 10.1.1 HF2 SP1

Who would benefit from this release?

This release provides the latest updates and fixes for customers who have deployed Informatica Data Quality 10.1.1 HF2.

Informatica recommends customers running 10.1.1 to upgrade to HotFix 2 and apply Service Pack1 to implement latest fixes for functionality and stability.

Note: This service pack is available for Windows and Linux environments and does not include any PAM changes for OS or connectivity.

Informatica 10.1.1 HotFix 2 Service Pack 1 Release Notes

You can download the Hotfix from here.

What are we announcing?

Informatica 10.2.0 HotFix 1

Who would benefit from this release?

This release is the latest version of 10.2 for all customers and includes support for new environments (see PAM) as well as all fixes to support stable deployments (see Release Notes)

What’s in this release?

Model Repository - Versioned Controlled

  • GIT Support - Added support for GitHub Server (hosting service for Git repositories)
  • Collabnet Subversion Edge - 5.2.2 - update

Informatica PowerCenter Docker Utility

Security updates

  • Third-party Library upgrades – 21 Vulnerable libraries upgraded
  • Migrated from legacy Struts to secure Spring MVC framework across entire product stack
  • Enhanced security for web applications through ‘Content Security Policy’ and advanced implementation of CSRF tokens

 

Platform PAM Update

 

  • Operating System Update:
    • AIX 7.1 TL4 - Added
    • AIX 7.1 TL2 & TL3 - Dropped
    • RHEL - 7.3 & 6.7 - Added
    • RHEL - 7.0 , 7.1 ,7.2 and 6.5 , 6.6 - Dropped
    • SUSE 12 SP2 - Added
    • SUSE 12 SP0 & SP1 -  Dropped
    • SUSE 11 SP4 - Added
    • SUSE 11 SP2 & SP3 - Dropped
    • Windows Server 2016 (Server) - Added
    • Windows Server 2008 R2 (Server)- Dropped
    • Windows Server 2008 , 2008 R2 (Client) - Dropped
  • Database support :
    • Oracle 12cR2 - Added
    • SQL Server 2017 - Added
    • Azure SQL DB (Single Database Model) - Added
    • IBM DB 9.7 & 10.1 - Dropped
    • MS SQL Server 2012 & 2008 R2  - Dropped
  • Authentication Support
    • Windows 2012 R2 & 2016 (LDAP only) - Added
    • Windows 2012, 2008, 2003 - Dropped
    • Oracle Directory Server (ODSEE) LDAP - Added
  • Tomcat Support Update:
    • v 7.0.88 - update
  • JVM Support Update:
    • Oracle Java 1.8.0_171 - update
    • IBM JDK 8.0.5.17- update
  • Others
    • Visio 2007, 2010 (Mapping Architect for Visio) - Dropped
    • Visio 2007, 2010 (Mapping Analyst for Excel) - Dropped
    • Microsoft Edge Browser (Win 10) 40.15 - updated
    • Internet Explorer -11.1155 - updated
    • Google Chrome- 68.0.3440.84 - updated
    • Safari - 11.1.2 ( MacOS 10.13 High Sierra) - updated
    • Adobe Flash Player - 27.x - updated

Big Data PAM Update

  • Hadoop Distributions Update
    • IBM BigInsights - Dropped

Metadata Manager Updates

  • Security Enhancements:
    • SAML support
    • Replaced vulnerable Struts with Spring 
  • Lineage Enhancements:
    • Upgraded to latest version of graph db to fix memory leak related issue and improve performance
    • SkipLineage option in MMREPOCMD
  • PAM update: New Versions Support Added for MM Resources:
    • Oracle 12cR2
    • Microsoft SQL Server 2017
    • Microsoft SSIS 2016
    • Microsoft ASRS 2016
    • ERWin 9.7
    • Microstrategy 10.9
    • Teradata 16.x
    • Informatica PowerCenter 10.1.1 HF2; 10.2.0 HF1
    • Informatica Platform 10.2.1 and 10.2.0 HF1

 

PowerExchange Mainframe & CDC Updates

       

  • PAM upgraded support
    • z/OS 2.3
    • CICS/TS V5.4
    • Adabas V8.4.x
    • IMS V15
    • MySQL Enterprise Edition V5.7
    • Amazon RDS(Oracle)
    • Oracle 12cR2 (toleration mode)
    • New CDC Source Capabilities
    • MySQL (Enterprise Edition) is now supported as a source for Changed Data Capture
    • Amazon RDS support of Oracle is now supported as a source for Changed Data Capture
  • General Enhancements
    • PWXCMD commands can now be used to communicate with the following Environmental Change Capture Routines:
      • Adabas
      • Datacom
      • IDMS
      • IMS
    • New PowerExchange Mainframe & CDC Utilities
      • PWXUCRGP this utility allows for the contents of the CCT files to be printed
      • PWXUGSK this utility allows PowerExchange to provide SSL configuration reporting for z/OS PowerExchange listeners.

 

Release Notes

 

Informatica 10.2.0 Hotfix 1 Release Notes

Informatica PowerExchange Release Notes

 

Adapters Release Notes:

 

PAM for Informatica 10.2.0 HotFix 1

 

You can download the Hotfixes from here.

What are we announcing?

Informatica Big Data Release 10.2.1

 

Who would benefit from this release?

This release is for all customers and prospects who want to take advantage of the latest Big Data Management, Big Data Quality, Big Data Streaming, Enterprise Data Catalog, and Enterprise Data Lake capabilities.

 

What’s in this release?

This update provides the latest ecosystem support, security, connectivity, cloud, and performance while improving the user experience.

 

Big Data Management (BDM)

 

Enterprise Class

 

  • Zero client configuration: Developers can now import the metadata from Hadoop clusters without configuring Kerberos Keytabs and configuration files on individual workstations by leveraging the Metadata Access Service
  • Mass ingestion: Data analysts can now ingest relational data into HDFS and Hive with a simple point and click interface and without having to develop individual mappings. Mass Ingestion simplifies ingestion of thousands of objects and operationalizes them via a non-technical interface
  • CLAIRE integration: Big Data Management now integrates with Intelligent Structure Discovery (that is part of Informatica Intelligent Cloud Services) to provide machine learning capabilities in parsing the complex file formats such as Weblogs
  • SQOOP enhancements: SQOOP connector has been re-architected to support high concurrency and performance
  • Simplified server configuration: Cluster configuration object and Hadoop connections are enhanced to improve the usability and ability to perform advanced configurations from the UI
  • Increased developer productivity: Developers can now use the "Run mapping using advanced options" menu to execute undeployed mappings by providing parameter file/sets, tracing level and optimizer levels in the Developer tool. Developers can also view optimized mappings after the parameter binding is resolved using the new "Show mapping with resolved parameters" option.
  • PowerCenter Reuse enhancements: Import from PowerCenter functionality has been enhanced to support import of PowerCenter workflows into Big Data Management
  • GIT Support: Big Data Management administrators can now configure GIT (in addition to Perforce and SVN) as the external versioning repository

 

    Advanced Spark Support

 

  • End to end functionality: End to end Data Integration and Data Quality use-cases can now be executed on the Spark Engine. New and improved functionality includes Sequence Generator transformation, Pre/Post SQL support for Hive, support for Hive ACID Merge statement on supported distributions, Address Validation and Data Masking.
  • Data science integration: Big Data customers can now integrate pre-trained data science models with Big Data Management mappings using our new Python transformation.
  • Enhanced hierarchical data processing support: With support for Map data types and support of Arrays, Structs and Maps in Java transformations, customers can now build complex hierarchical processing mappings to run on the Spark engine. Enhancements in gestures and UI enable customers to leverage this functionality in a simple yet effective manner
  • Spark 2.2 support: Big Data Management now uses Spark 2.2 on supported Hadoop distributions

 

Cloud

 

  • Ephemeral cluster support: With out-of-the-box ephemeral cluster support for AWS and Azure ecosystems, customers can now auto deploy and auto scale compute clusters from a BDM workflow and push the mapping for processing to the automatically deployed clusters
  • Cloudera Altus support: Cloudera customers can now push the processing to Cloudera Altus compute clusters.
  • Improved AWS connectivity: Amazon S3 and Redshift connectors have received several functional, usability and performance updates
  • Enhanced Azure connectivity: Azure WASB/Blob and SQL DW connectors have received several functional, usability and performance updates

 

Platform PAM Update

 

Oracle 12cR2

Added

SQL Server 2017

Added

Azure SQL DB

(PaaS / DBaaS , Single database model)

Added

SQL Server 2008 R2 & 2012 (EOL)

Dropped

IBM DB2 9.7 & 10.1 (EOL)

Dropped

Suse 12 Sp2

Added

Suse 12 Sp0

Dropped

AIX

Not Supported

Solaris

Not Supported

Windows Server

Not Supported

Model Repository - Versioned Controlled

Status

Git

Added

 

Oracle Java 1.8.0_162

Updated

IBM JDK

NA

Tomcat 7.0.84

Updated

 

Big Data Quality (BDQ)

 

Capabilities

  • Enable data quality processing on Spark
  • Updated Address Verification Engine (AddressDoctor 5.12)
  • Support for custom schemas for reference tables
  • Updated workflow engine

Benefits

  • Support Spark scale and execution with Big Data Management
  • Enhanced Address Verification engine with world-wide certifications
  • Flexible use of reference data with enterprise DB procedures
  • Faster start times for workflow engine

 

Big Data Streaming (BDS)

 

Change in Product Name: The product name has changed from "Informatica Intelligent Streaming" to "Big Data Streaming"

 

Azure Cloud Ecosystem Support

 

  • Endpoint Support: Azure EventHub as source & target and ADLS as target
  • Cloud deployment: Run streaming jobs in Azure cluster on HDInsight

 

Enhanced Streaming Processing and Analytics

 

  • Stateful computing support on streaming data
  • Support for masking streaming data
  • Support for normalizer transformation
  • Support for un-cached lookup on HBase tables in streaming
  • Kafka Enhancements - Kafka 1.0 support & support for multiple Kafka versions

 

New Connectivity and PAM support

 

  • Spark Engine Enhancements - Spark 2.2.1 support in streaming, Truncate table, Spark concurrency
  • Relational DB as target - SQL Server and Oracle
  • New PAM - HDInsight
  • Latest version support on Cloudera, Hortonworks, EMR

 

Enterprise Data Lake (EDL)

 

Change in Product Name: The product name has changed from "Intelligent Data Lake" to "Enterprise Data Lake"

 

Core Data Preparation

 

  • Data Preparation for JSON Lines (JSONL) Files: Users can add JSONL files to a project and structure the hierarchical data in row-column form. They can extract specific attributes from the hierarchy and can expand (or explode) arrays into rows in the worksheet.
    Pivot and UnPivot: Users can pivot or unpivot columns in a worksheet to transpose/reshape the row and column data in a worksheet for advanced aggregation and analysis.
  • Categorize and One-hot-encoding functions: Users can easily categorize similar values into fewer values to make analysis easier. With one-hot-encoding, the user can convert categorical values in a worksheet to numeric values suitable for machine learning algorithms.
  • Column Browser with Quality Bar: A new panel for browsing columns is added to the left panel in the worksheet. This easy to use column browser interface allows users to show/hide columns, search for columns, highlight columns in the worksheet, etc. The panel also has a Quality bar that shows unique, duplicate and blank value count percentages within the column. The panel can also show any associated glossary terms.
  • Project Level Graphical View: For a project with a large number of assets, the graphical view helps users understand the relationships between input data sources, sheets created, assets published, and Apache Zeppelin notebooks created. Users can navigate to the asset, notebook or the worksheet directly.
  • Insert recipe step, add a filter to an existing step: Users can insert a new step at any location in the recipe. They can also add/modify existing filters for any recipe step.
  • Data Type Inferencing optimization: Users can revert undesired inferencing done by data preparation engine and apply appropriate functions. They can revert or re-infer types as needed.
  • Show where the data in a column comes from: The column overview in the bottom panel now has a Source property that shows if the column corresponds to a physical input source column, another worksheet or a step in the recipe. If the user hovers over a data source name, the application shows details of the formula when available and highlights the appropriate recipe step.
  • UX Improvements in Filter-in-effect, Sampling, Join and Apply Rule panels: The user interface has been improved for clarity of icons and language used, visibility of information and button and better user flow for these panels. Users can also input constant values as inputs in the Apply Rule panel for text based user inputs.

 

Self-service and Collaboration

 

  • Self-service scheduling: Data Analysts now have the ability to schedule import, publish and export activities. The Import/Publish/Export wizard offers the choice to perform the activity now, or to schedule it. For publish, a “snapshot” of recipes is saved for execution at the scheduled time. Users can continue to work on the project and modify recipes without affecting scheduled activity.
    The “My Scheduled Activities” tab provides details of upcoming activities. The “Manage My Schedules” tab provides details of schedules and enables users to modify schedules.
    Scheduled activities can be monitored on the My Activities page. Functionally it has the same effect as running the activity manually. All the schedules created in Enterprise Data Lake and activities scheduled in Enterprise Data Lake are also visible in the Administrator Console tool.
  • Project History: Users (and IT/Governance staff) can view the important events that happened within a given project. These include events related to Project, Collaborators, Assets, Worksheets, Publications, Scheduled Publications, Notebook etc.
  • Copy-Paste Recipe Steps: Users can copy specific steps or the whole recipe and paste into another sheet in the same project or another project. There is also a way to map the input columns used in the source sheet to the columns present in the target sheet. This enables reuse of each other’s or their own work in the creation of repetitive steps.
  • Quick Filters for asset search in the data lake: In the search results, users have a single-click filter to get all the assets in the data lake that match the search criteria.
  • Recommendation Card UX Improvements: The Recommendation cards in the Project view now show the reason an asset was recommended for inclusion in the project, and what action user should take.
  • Details of Source Filters during Publish: During Publication, the Publish Wizard shows the details of "Source Filters" so the user understands the impact of including or not including the filters.

 

Enterprise Focus

 

  • Single Installer for Big Data Management, Enterprise Data Catalog and Enterprise Data Lake: The installation and upgrade flows have been improved and simplified with a single installer. Enterprise Data Lake customers can now install all three products in a single install. The total size of the single installer is just ~7GB due to better compression, as compared to the previous combined size of ~13GB. The process requires fewer domain restarts, and additional configurations can also be enabled in the same single flow.
  • Blaze as Default Execution Engines for Enterprise Data Lake: All Enterprise Data Lake processes using Big Data Management mapping execution now use Blaze as the default engine. This has improved performance and consistency.
  • SAML based SSO: Enterprise Data Lake now supports SAML based Single-Sign-On.
  • Lake Resource Management UI: Administrators can manage the Enterprise Data Catalog resources that represent the external data sources and metadata repositories from which scanners extract metadata for use in the data lake. The Lake Resource Management page also verifies the validity of resources, the presence of at least one Hive resource, etc. so that Enterprise Data Lake functionality is usable. Changes done through the Lake Resource Management page do not require a service restart.
  • Data Encryption for Data Preparation Service node: The temporary data created on Data Preparation Service nodes is encrypted for better security.
  • Demo Version of IT Monitoring Dashboard: A dashboard created in Apache Zeppelin allows administrators to monitor Enterprise Data Lake user activities. The dashboard is not a product feature, but an example to show what is possible with the audit information. The dashboard is an Apache Zeppelin Notebook built on top of the Enterprise Data Lake user event auditing database. The Zeppelin Notebook and associated content are available on request, but it is unsupported. The Audit mechanism has been changed and improved now to support direct queries using JDBC.  
  • Performance Improvement in Import process using CLAIRE: Using the profiling metadata information available in CLAIRE, the import process optimizes the number of sub-processes created thereby improving the overall performance of Import

 

Enterprise Data Catalog (EDC)

 

  • Intelligence
    • Enhanced Smart Discovery: By clustering similar columns from across data sources, EDC enables users to quickly associate business terms as well as classify data elements. Unsupervised clustering of similar columns is now based on names, unique values and patterns in addition to the existing data overlap similarity.
    • Enhanced Unstructured Data Discovery (Tech Preview): Enhanced unstructured data support for accurate domain discovery using NLP and new file system connectivity.
    • New Data Domain Rules: Override rules and new scan options for more granular control on rule based data domain inference.
  • Connectivity
    • New Filesystems: Added support for cataloging of Sharepoint, Onedrive, Azure Data Lake Store(ADLS), Azure Blob and MapRFS
    • New File Formats: Avro and Parquet support added in 10.2.1.
    • Remote File Access Scanner: Mounting folders on Hadoop nodes not required for Linux and Windows filesystem, instead the new remote file access scanner uses SMB for Windows and SFTP for Linux for cataloging.
    • Deep Dive Lineage support for BDM: End to End data lineage from Big Data Management with transformation logic and support for dynamic mappings
    • Data Integration Hub: Users can now scan DIH to access metadata for all objects and its subscriptions and publications.
    • Data Lineage from SQL Scripts(Tech Preview): End to End data lineage from hand coded SQL scripts to understand column level data flows and data transformations- includes support for Oracle PLSQL, DB2 PLSQL, Teradata BTEQ, HiveQL. Stored Procedures are not supported in this release.
    • Qlikview: Scan reports and report lineage from Qlikview.
  • User Experience Improvements
    • Manage business context with in-place editing of wikipages of data assets. Business user friendly data asset overview page that provides all the business context about the data asset. Inherit descriptions from Axon associations or type your own.
    • SAML Support: For Single Sign-On.
    • Multiple Business Term Linking: Allows custom attribute creation with Axon or BG term type to allow users to link multiple business terms with a single asset.
    • Search Facet Reordering: Catalog Administrators can now reorder the default facet orders making business facets show up higher than the technical facets.
    • New Missing Asset Link Report: To help users identify linked and unlinked data assets for a lineage-type source.
  • Open and Extensible Platform
    • New REST APIs for starting and monitoring scan jobs
    • S@S Interop: Shared Infrastructure, Metadata Repository, Data Domain Definitions and Curation Results shared across EDC and S@S. Users can now scan a resource once to see it in both EDC and S@S.
    • Reduced Sizing: Upto 3X reduction in computation cores required on the Hadoop cluster across all sizing categories
    • Ease of Deployment – Improved validation utilities, updated distro(HDP v2.6) for embedded cluster.

 

Release Notes & Product Availability Matrix (PAM)

 

PAM for Informatica 10.2.1

 

Informatica 10.2.1 Release Notes

 

What are we announcing?

Informatica 10.1.1 HotFix 2

 

Who would benefit from this release?

This release is for all PowerCenter and Data Quality customers and prospects who want to take advantage of the fixes to the Core Platform, Connectivity and installing new HotFix 2, or upgrading from previous versions.

 

What’s in this release?

  • This update provides the latest HotFix improving the user experience
  • Domain Rename - Allows customer to rename an existing domain to a new name. This is beneficial to the customers splitting their mixed use-use Informatica domain.
  • TPL Upgrades - Upgraded several security-critical Third-Party Libraries (TPLs)
  • PAM Updates – Upgrading the Operating systems, Databases, Java and Tomcat
  • Azure Blob/DW (V1/V2) are certified to work with 10.1.1 HF2 release
  • SAP NW 7.5 Connectivity update

 

PAM

  • Added support for Windows 2016 (Server and Client)
  • Added support for AIX 7.2
  • Updated support for SUSE 12 SP2
  • Updated support for RHEL 7.4
  • Dropped support for AIX 6.1
  • Updated Java version -  IBM java - 8.0 Service Refresh 5  and Oracle Java - Java SE 8u144
  • Updated Tomcat version - Tomcat - 7.0.82

 

Informatica 10.1.1 Hotfix 2 Release Notes

 

Informatica PowerExchange 10.1.1 HotFix 2 Release Notes

 

Informatica PowerExchange Adapters - 10.1.1 HotFix 2 Release Notes

 

Informatica PowerExchange Adapters for PowerCenter - 10.1.1 HotFix 2 Release Notes

 

PAM for Informatica 10.1.1 HotFix 2

 

You can download the Hotfixes from here.

The Informatica Platform is a set of data services and information solutions powered by a state-of-the-art data management engine. The end of support for the Informatica Platform includes the following products:

 

  • PowerCenter
  • Metadata Manager and Business Glossary
  • PowerExchange (PWX)
  • Data Quality (DQ)
  • Data Transformation (B2B DT)
  • Big Data Management (BDM)
  • Data Integration HUB (DIH)
  • B2B Data Exchange (DX) without OEM Cleo MFT products (see Informatica Product Lifecycle Guide for more details and DX end of life)

 

Support for all Informatica Platform products with versions 9.0.x, 9.1, 9.5.x, and 9.6.x will end on the following dates:

 

Version

Release Date

Minimum Support Period

End of Support

Extended Support*

Sustaining Support*

9.6.x

Jan 2014

31 Jan 2018

31 Mar 2018

31 Mar 2019

31 Mar 2021

9.5.x

Jun 2012

30 Jun 2016

31 Jul 2017

31 Jul 2018

Not Available

9.1

Mar 2011

31 Mar 2015

31 Jan 2017

31 Jan 2018

Not Available

9.0.x

Dec 2009

31 Dec 2013

31 Jan 2017

31 Jan 2018

Not Available

 

* Extended and Sustaining Support are available at an additional charge; Sustaining Support is not available for all product releases. For further information please contact: dlicare@informatica.com.

 

For more information on product lifecycle, extended support policy, and end of life details of various Informatica products, view the Informatica Product Lifecycle Guide.

Filter Blog

By date: By tag: