Informatica Enterprise Data Catalog Advanced Scanners 10.4.1.0.1 has been released to shipping and is available immediately.
What are we announcing?
The release of Informatica Enterprise Data Catalog Advanced Scanners 10.4.1.0.1
Who would benefit from this release?
This release is for all customers and prospects who want to take advantage of the advanced metadata extraction capabilities with Informatica Enterprise Data Catalog.
What’s in this release?
This release provides new features included in Informatica Enterprise Data Catalog Advanced Scanners
IBM InfoSphere DataStage is now GA.
SAP BW is now GA.
SAP BW/4HANA is now GA.
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.
Oracle stored procedures and scripts: Ability to extract detailed data lineage at asset and column level for stored procedures, functions, and packages. PL/SQL and loader scripts for Oracle including static and dynamic SQL statements.
MS SQL Server stored procedures and scripts: Ability to extract detailed data lineage at asset and column level for stored procedures, functions, and packages. Transact-SQL scripts for MS SQL Server including static and dynamic SQL statements.
Teradata stored procedures and scripts: Ability to extract detailed data lineage at asset and column level for stored procedures. Macros, BTEQ, Fastload, MultiLoad, FastExport scripts for Teradata including static and dynamic SQL statements.
IBM DB2 stored procedures and scripts: Ability to extract detailed data lineage at asset and column level for stored procedures, functions, and packages. PL/SQL and loader scripts for IBM DB2 LUW including static and dynamic SQL statements.
Netezza (IBM PureData systems) stored procedures and scripts: Ability to extract detailed data lineage at asset and column level for stored procedures, functions, and packages. NZPLSQL and nzload Scripts for Netezza including static and dynamic SQL statements.
Sysbase ASE stored procedures and scripts: Ability to extract detailed data lineage at asset and column level for stored procedures, functions, and packages. Transact-SQL scripts for Sysbase ASE including static and dynamic SQL statements.
SAS base: Ability to extract object metadata as well as detailed lineage at asset and column level from SAS programs.
Microsoft SSRS: Extract datasets and report metadata including lineage at field level from Microsoft SSRS.
Microsoft SSAS: Extract data sources, cubes, measures, and dimensions metadata including lineage at field level from Microsoft SSAS.
JCL: Extract JCL program metadata including lineage between data objects (DB2 assets, VSAM Files, etc.)
COBOL: Extract metadata from COBOL program and copybooks.
Advanced Custom Metadata Loader: Accelerate the creation of custom metadata model and automate load of custom metadata from CSV, XLS, XML, JSON, or databases into the catalog using the EDC Advanced Custom Metadata Loader.
Stored procedures and scripts for Oracle 11gR2, 12c,12cR1, 12cR2, 18c, 19c
Stored procedures and scripts for MS SQL Server 2012, 2014, 2016, 2017, 2019
Stored procedures and scripts for Teradata 15.10, 16.00, 16.20
Stored procedures and scripts for IBM DB2 10.5, 11.1
The Informatica Global Customer Support Team is excited to announce an all-new technical webinar and demo series – Meet the Experts, in partnership with our technical product experts and Product management. These technical sessions are designed to encourage interaction and knowledge gathering around some of our latest innovations and capabilities across Data Integration, Data Quality, Big Data and so on. In these sessions, we will strive to provide you with as many technical details as possible, including new features and functionalities, and where relevant, show you a demo or product walk-through as well.
Get a deep-dive into how you can leverage the best of human expertise and AI with EDC 10.2.2. Subject matter expertise and social curation combined with the power of AI deliver a collaborative experience for data discovery, cataloging and management.
Informatica Enterprise Data Catalog 10.2.1 Update 1 has been released to shipping and is available immediately.
“Enterprise Data Catalog 10.2.1 Update 1” addresses several limitations and issues to improve usability and stability of the product.
Cloudera CSD Integration for HTTP Keytab management: Secure EDC deployment with creation of an Informatica EDC specific Cloudera Service Descriptor(CSD), that removes the requirement of provisioning http keytabs on Informatica Edge nodes. Starting 10.2.1 Update 1, Informatica CSD, when enabled from Cloudera Manager UI, will automatically copy the http keytab to the ramdisk specified on the node while creating the service.
WANdisco Support: WANDisco Fusion allows continuous availability of data with guaranteed consistency across clusters spanning Dev/Test, Production and Disaster Recovery environments. Starting 10.2.1 Update 1 EDC can be deployed on a WANDisco enabled Cloudera or Hortonworks cluster, enabling users getting all the benefits of WANDisco Fusion like data replication on an EDC cluster.
sudo-less Embedded Cluster Deployment: Catalog Administrators can now turn off sudo access on embedded EDC cluster post deployment. Requires Ambari-server and agent to be up before bringing up the catalog service.
Ambari User Customization for Embedded Cluster Deployment: Embedded Cluster Deployment now includes options to customize users for Ambari instead of using default users created by the service. This will allow administrators to configure local/AD users as Ambari service users.
Scanner Upgrades: Large number of scanner fixes that include an updated MITI distribution(v10) for reliable and high-performance metadata scans for databases, ETL and business intelligence tools.
Scanner log aggregation: Enhanced scanner error diagnosis with REST API that aggregates the scanner log, resource configuration and catalog service details.
Performance Improvements: Major improvements in performance for Informatica PowerCenter(2X) and SAP Business Objects(10X) scanners.
Performance Improvements: Major improvements in data profiling performance for high volume scans(>10k tables or files) across sources: relational databases(1.5x) to flat files(2.5X) with a 25X-100X reduction in Profiling Warehouse space required. ~4X Performance improvements in Similarity Profiling.
Unstructured Discovery Performance: Improved domain discovery performance in unstructured files with a scan throughput of 2.75 GB/Hour/20 data domains.
Informatica EIC 10.2.0 Update 1 has been released to shipping and is available immediately.
Enhanced Tableau Integration
Informatica Enterprise Information Catalog (EIC) Discover Plugin for Tableau: EIC Discover for Tableau is a Chrome browser plugin that automatically detects the active Tableau report or dashboard and provides rich contextual information catalogued in EIC. This brings all governance context, business classifications, data sources and other important metadata to self-service BI users within the context of the Tableau app. EIC Discover Chrome plugin needs an existing EIC deployment to function.
Tableau Data Extract (TDE) Export: This capability is for data analysts, data scientists and business users who want to access data in Tableau for adhoc analysis after they find the right data asset in EIC. EIC allows users to securely and quickly get access to data in TDE format, which they can visualize and analyze in Tableau.
Ease of Deployment and getting started
Prereq utility for embedded cluster validation: To help run prerequisite checks on the Informatica server and intended cluster nodes to ensure they meet the requirements for EIC install.
Utility to generate merged key tabs: This utility is for creating, validating and merging key tabs required for EIC installations on Kerberos enabled clusters.
Import Metadata Manager Resources into EIC: Import existing connections from Metadata Manager to EIC, to help customers to quickly kickstart their EIC deployments.
Improved Operations and Administration:
Catalog Service HA Support: Catalog Service can now be configured in the Active-Passive HA mode.
Improved Catalog Service Startup Catalog service startup performance has been improved by performing on-demand deployment of scanner binaries to the cluster.
Phone Home Support: Built-in capabilities to anonymously provide configuration and usage statistics back to Informatica.