Informatica Power Center 9. 6 have been released with new capabilities that make it easier to develop and deploy a wide range of data tasks, from integration jobs to new cloud and big data projects
Informatica continues to drive innovative capabilities with this release. With enriched features that mirror the increasing need for business-driven data governance, data integration, data management and ease of deployment across hybrid cloud and on premise data environments, and more agile application development.
Informatica 9.6 is offered in PowerCenter Standard, Advanced and Premium editions, along with a new PowerCenter Big Data trial. The editions feature built-in business-IT collaboration functionality, built-in profiling and rapid prototyping, advanced scaling and metadata management, and state of the art data stewardship, data validation and proactive monitoring that guarantees safe data. The Vibe Virtual Data Machine architecture provides risk-free big data integration experimentation.
Now let’s see the new features in this version.
You can configure the Informatica domain to use Kerberos authentication. When you install the Informatica services, you can enable Kerberos authentication for the domain. A page titled Domain – Network Authentication Protocol appears in the Informatica services installer. To install the domain with Kerberos authentication, select the option to enable Kerberos authentication and enter the required parameters.
Informatica encrypts sensitive data such as passwords when it stores data in the domain. Informatica uses a keyword to generate a unique encryption key with which to encrypt sensitive data stored in the domain. A page titled Domain – Encryption Key appears in the Informatica services installer. If you create a node and a domain during installation, you must specify a keyword for Informatica to use to generate a unique encryption key for the node and domain. If you create a node and join a domain, Informatica uses the same encryption key for the new node.
Secure Communication :
You can provide an SSL certificate or use the default Informatica SSL certificate to secure communication between services in the domain. To use your SSL certificate, specify a keystore and truststore file and password during installation.
Version 9.6.0 includes the following enhancements to the Analyst Service:
• You can select a Data Integration Service configured to run Human tasks. If the Data Integration Service associated with the Analyst Service is not configured to run Human tasks, choose a different Data Integration Service.
• You can select a Search Service to enable searches in the Analyst tool.
• You can set the location of the export file directory to export a business glossary.
Content Management Service:
You can set the location of the SendRight report file on the Content Management Service.
Generate a SendRight report when you run an address validation mapping in certified mode on New Zealand address records. The report verifies that the address records meet the certification standards of New Zealand Post.
Version 9.6.0 includes the following enhancements to high availability for services:
• When the Model Repository Service becomes unavailable, the Service Manager can restart the service on the same node or a backup node. You can configure the Model Repository Service to run on one or more backup nodes.
• When the Data Integration Service becomes unavailable, the Service Manager can restart the service on the same node or a backup node. You can configure the Data Integration Service to run on one or more backup nodes.
• When the Data Integration Service fails over or restarts unexpectedly, you can enable automatic recovery of aborted workflows.
• You can enable the PowerCenter Integration Service to store high availability persistence information in database tables. The PowerCenter Integration Service stores the information in the associated repository database.
You can aggregate logs at the domain level or service level based on scenarios with the Administrator tool. You can also compress the log files that you aggregate to save disk space.
Informatica Domain Security
This section describes security enhancements to the Informatica domain.
Authentication: You can run Informatica with Kerberos authentication and Microsoft Active Directory (AD) directory service. Kerberos authentication provides single sign-on capability to Informatica domain client applications. The Informatica domain supports Active Directory 2008 R2.
Two-Factor Authentication (TFA): Informatica clients can run on a Windows network that uses two-factor authentication.
Encryption Key: You can specify a keyword to generate a unique encryption key for encrypting sensitive data such as passwords that are stored in the domain.
Workflow Security: You can configure the PowerCenter Integration Service to run PowerCenter workflows securely. The Enable Data Encryption option enables secure communication between the PowerCenter Integration Service and the Data Transformation Manager (DTM) process and between DTM processes.
Administrator Group: The Informatica domain includes an Administrator group with default administrator privileges. You can add users to or remove users from the Administrator group. You cannot delete the Administrator group.
Administrator Account Lockout: When you configure account lockout in the Administrator tool, you can enforce account lockout for administrator user accounts. The Admin Account Lockout option enables lockout for administrator user accounts. When you enable the Account Lockout option, you can also enable the Admin Account Lockout option.
Connection to Secure Relational Databases: You can use the Informatica relational database drivers to connect to a secure Oracle, Microsoft SQL Server, or IBM DB2 database. You can create repositories, sources, and targets on databases secured with SSL certificates.
Audit Reports: In the Administrator tool, you can generate audit reports to get information on users and groups in the Informatica domain. For example, you can get information about a user account, such as the privileges and permissions assigned to the user and the groups associated with the user.
Pushdown Optimization for SAP HANA:
The PowerCenter Integration Service can push transformation logic to SAP HANA sources and targets when the connection type is ODBC.
High Availability Persistence in a Database:
You can enable the PowerCenter Integration Service to store high availability persistence information in database tables. The PowerCenter Integration Service stores the information in the associated repository database.
PowerCenter Advanced Edition
Business Glossary comprises online glossaries of business terms and policies that define important concepts within an organization. Data stewards create and publish terms that include information such as descriptions, relationships to other terms, and associated categories. Glossaries are stored in a central location for easy lookup by end-users.
Business Glossary is made up of glossaries, business terms, policies, and categories. A glossary is the high level container that stores other glossary content. A business term defines relevant concepts within the organization, and a policy defines the business purpose that governs practices related to the term. Business terms and policies can be associated with categories, which are descriptive classifications. You can access Business Glossary through Informatica Analyst (the Analyst tool).