Authors: Vidya Skip navigation

Data Integration Hub

7 Posts authored by: Vidya

Data Integration Hub 10.0  introduces the following main features:

 

Publish from and subscribe to cloud-based applications

Publish from and subscribe to cloud-based applications using Informatica Cloud Services tasks.

 

Share files between applications that reside outside the Data Integration Hub network

Publish files from and subscribe to files from remote applications, that reside outside the Data Integration Hub network, through secure SSH File Transfer Protocol (SFTP).

 

Monitoring and Notifications

Data Integration Hub operators can create event monitors that track publications and subscriptions based on their event status. The operators create rules that instigate actions when an event is in a defined status.

 

Refer to the Data Integration Hub Release Guide for a full list of additional new features introduced in version 10.0.

 

Informatica Data Integration Hub - 10.0.0 - Release Notes - (English)

PAM for Data Integration Hub 10

Data Integration Hub 9.6.2  introduces Data Integration Hub for Big Data with the following main features:

 

Hadoop-based publication repository

  • Define Hadoop-based publication repository and manage some or all of your topics on Hadoop. You can now use all DIH functionality with Hadoop-based publication repository.
  • Data Integration Hub 9.6.2 introduces an hybrid approach that allows you to define multiple types of publication repositories: relational database, file-based, Hadoop-based.

Support HDFS sources and targets with automatic mapping

  • Publish and deliver flat files from and to a Hadoop Distributed File System (HDFS) with publications and subscriptions that use automatic mapping.


Data Integration Hub 9.6.2  also introduces the following main features:


Changes to Wizard

  • The publication and subscription wizards are now customized based on the type of publication or subscription that is selected.

 

File-based publication repository

  • New pass-through publications to publish files “as-is” to a file-based publication repository without parsing the file and loading it to relational database publication repository. User can now use  pass-through subscriptions to consume files that were stored in a file-based publication repository.

 

Topic Structure Updates

  • Updates to topic structure that do not require Data Integration Hub to delete tables or columns do not cause the associated publications and subscriptions to become not valid, and cause no data loss.

 

Disable and enable publications and subscriptions

  • Operators can disable and enable publications and subscriptions from within the Operation Console. A disabled publication or subscription does not run according to schedule or by an external API.

 

Improved Feedback from Run Publication and Subscription APIs

  • User can track whether the publication or subscription process is still running, and when the process is complete, whether the publication or subscription process completed successfully or failed. If the process fails, the response to the query includes the cause of the failure.

 

Refer to Data Integration Hub Release Guide for a full list of additional new features introduced in version 9.6.2.


Informatica Data Integration Hub - 9.6.2 - Release Notes - (English)

PAM for Data Integration Hub 9.6.2

Data Integration Hub 9.6.1 HotFix1 is a security fix. It introduces enhancements that tighten client and server security. Most of the enhancements are implemented on the server and have no impact on users. There are few enhancements that might affect system usage:

 

  • User Name and Password Environment Variables in Command Line Utilities
  • Restrict Remote Data Integration Hub Server Shutdown and Startup
  • Protect Calls from PowerCenter Workflows to the Data Integration Hub Server with a Secret Token
  • Secure Communications with PowerCenter Services.

 

You can download the Hotfix from here.

Informatica Data Integration Hub - 9.6.1HF1 - Release Notes - (English)

Data Integration Hub 9.6.1 includes the following main features:

 

Self Service:

 

  • Enable table and field mapping for publications and subscriptions with auto-generated mappings
  • Extends the use of auto generated mappings to cases where the structure of the source is not identical to the structure of the target.
  • Users can manually map publication source tables and fields to the topic and map topic tables and fields to the subscription target.

 

Unbound subscription:

A subscription that is not restricted to specific publication instances. An unbound subscription subscribes to all the data that a publication publishes and consumes the data based on the subscription filter

 

Publish files when they are ready to be published:

A scheduling option for file-based publications that runs the publication immediately when published files are ready

 

Security:

  • Control data access at the topic level
  • Publication and subscription privileges

 

High availability:

Support deployment of Data Integration Hub in a clustered environment in an active/active configuration to allow resilience and a highly available environment

 

Informatica Data Integration Hub - 9.6.1 - Release Notes - (English)

PAM for Data Integration Hub 9.6.1

Data Integration Hub 9.6 includes the following main features:

 

Topic introduction and Multiple publishers to same topic


A topic is an entity that represents data domain that is  published and consumed by application in the hub. A topic defines the data structure (canonical) for the data domain.

Multiple applications can publish to the same topic. Publications publish data with the structure as presented by the topic. Topics can be consumed by multiple applications.

 

Select columns and filter conditions  to Consume in Subscribers with Automatic Mapping

When you create a subscription that uses an automatic mapping, you can define which parts of the data to consume: tables, columns, and rows. Data Integration Hub uses the definitions when creating the automatic mapping for the subscription.

 

Publication Real-Time Workflow

Publish data from real-time sources to the Data Integration Hub publication repository using PowerCenter real-time workflows. Group published data into a single publication according to predefined intervals.

Dashboard and Reports

Dashboard and reports option  includes a set of charts that present a high level view of publication and subscription activities in Data Integration Hub.

 

See DIH Release Guide for a full list of additional new features introduced in Data Integration Hub 9.6.

 

Informatica Data Integration Hub - 9.6.0 - Release Guide - (English)

PAM for Data Integration Hub 9.6

Data Integration Hub 1.0 HotFix 1 includes the following main features:

 

Additional Sources/Targets in Automatic Mapping

Data Integration Hub can generate automatic mappings also  for the following data sources and data targets:

  • IBM DB2 database
  • Flat file

 

Publication Pre-Processing

If there is a need for  a preparation process before the publication, it can be run and managed from DIH as  a publication pre-process. Data Integration Hub triggers the preparation process before it triggers the publication process. The operator has full end-to-end visibility to the entire publication process, including both the preparation and the publication steps.

 

Run Publications and Subscriptions from a Command-Line API

DIH provides a command-line API that triggers  a specific publication, or a specific subscription.

This API can be used to trigger DIH publications and subscription from an external scheduler or with an external trigger.

 

Auto Managed Partitioning for Publication Repository

DIH enables partitioning for the publication repository. DIH manages the partitioning schema and function with no need for DBA involvement.

Enabling partitioning is highly recommended for improving publication management performance.

 

PAM for Data Integration Hub 1.0 Hotfix 1

Informatica Data Integration Hub - 1.0.0 HotFix 1 - Release Notes - (English)

Data Integration Hub 1.0 includes the following main features:

  • Application, Publication, and Subscription Management:
    • You can add and manage applications in your organization that share data through Data Integration Hub. The applications share data with the publish/subscribe model, where an application can publish a single data set and multiple applications can consume the same data set.
    • Each application can have associated publications and subscriptions. A publication is a set of instructions to extract data from a source application system and publish the data to the publication repository. A subscription is a set of instructions to write the published data from the publication repository to a target application system. You create, manage, and run publications and subscriptions manually or at scheduled intervals.
  • Publications Catalog
    • You can use the publications catalog to view all available publications in Data Integration Hub and directly subscribe to them. You can drill to the publication details, view associated subscribers, and search for a publication or a subscription.
  • Automatic Publication and Subscription Mapping
    • You can create a publication or a subscription with an automatic mapping that Data Integration Hub generates, or with a custom mapping that the Data Integration Hub developer creates in PowerCenter. If you choose to create a publication or a subscription with an automatic mapping, Data Integration Hub creates the PowerCenter workflow, session, metadata folders, and connections when you create the publication or subscription. When you create a publication with an automatic mapping, Data Integration Hub creates the mapping based on the tables and columns in the metadata connection that you select when you create the publication. When you create a subscription with an automatic mapping, Data Integration Hub creates the mapping based on the publication definitions.
  • Publication Repository
    • You can publish data sets from source applications to the publication repository. The publication repository is a database that stores published data sets that applications publish and consume. After all subscribers consume the data and the data retention period ends, Data Integration Hub deletes the data from the publication repository. You install the publication repository when you install Data Integration Hub. You can set up database partitions on the publication repository to optimize performance.

 

 

 

Data Integration Hub - 1.0.0 - Release Notes - (English)

PAM for Data Integration Hub