Data Integration Hub Transformations Overview
A Data Integration Hub transformation is a set of functions that process Data Integration Hub data in PowerCenter.
When you install Data Integration Hub, you can install a set of transformations that you use in PowerCenter workflows to process Data Integration Hub data. When you create mappings, you can use the transformations to perform the functions that you require in the same way you use other PowerCenter transformations.
Data Integration Hub transformations are custom Java transformations that you use to access the Data Integration Hub API without writing Java code. You can use these transformations, the Unstructured Data transformation, and other transformations to process publications and subscriptions.
The following table describes the Data Integration Hub transformations:
Transformation | Description |
|---|
DX_Add_Document_To_Event | Attaches a document to an event. |
DX_Event_Attrribute | Gets or sets the values of event attributes. |
DX_Event_Details | Gets or sets the values of a property of an event. |
DX_Generate_Temporary_File | Generates a file name for a file in the Data Integration Hub document store. |
DX_Notification | Notifies the Data Integration Hub server that processing was successful. |
DX_Publication_Parameters | Adds placeholders for the publication instance ID and for the publication date in the Data Integration Hub publication repository. |
DX_Start_Publication | Starts a publication process. |
DX_Throw_Error | Sets an event status to error if the transformation fails. |
Installing and Registering Transformations
To add Data Integration Hub transformations to PowerCenter, use the Data Integration Hub installer.
You install the following components:
- •Data Integration Hub PowerCenter server plug-in. Use the Administrator tool to register the plug-in.
- •Data Integration Hub PowerCenter Client plug-in. The installer registers the plug-in during the installation process.
After you install and register the plug-ins, verify that the transformations are enabled in the PowerCenter Designer. For more information about installing and configuring the plug-ins, see the Data Integration Hub Installation and Configuration Guide.
Configuring Transformations
After you add a Data Integration Hub transformation to a mapping, you edit and configure the transformation based on your document processing requirements.
When you edit a Data Integration Hub transformation, you can configure the transformation components on the following tabs:
- •Transformation tab. Rename the transformation and add a description.
- •Ports. Add, edit, or delete ports. You can also designate ports as input or output ports.
- •Properties tab. Configure transformation properties, such as module and function identifiers, transaction properties, and the runtime location. The properties that appear on this tab are the same as the properties for other PowerCenter Custom transformations. For more information about the Properties tab, see the PowerCenter Transformation Guide.
- •DX Properties tab. Set the default values for the ports in the transformation. You can also set the default values for other Data Integration Hub transformation properties.
Handling Transformation Errors
You can use certain transformation ports to define how to handle errors that occur during a workflow run.
Each Data Integration Hub transformation uses the following ports to handle errors:
- •DXErrorCode. When a transformation fails, the transformation sets the DXErrorCode to a value greater than zero.
- •DXErrorMessage. When a transformation fails, the transformation sends an error message that describes the failure to the DXErrorMessage port.
When a transformation generates an error, the transformation writes the error to the PowerCenter session log. The error log includes the exception class, description, cause, and stack trace. The logging level is based on the PowerCenter configuration. Up to 1K of the document associated with the error will be included in the log.
If the option to set the event status to error when a transformation fails is set to true, the transformation also sets the status of the event to error.
You can set the error handling ports as input ports to prevent the transformation from running if an input error occurs.
Data Integration Hub Transformations Rules and Guidelines
When you work with Data Integration Hub transformations in PowerCenter, follow rules and guidelines to optimize performance and prevent errors.
The following list describes rules and guidelines for working with Data Integration Hub transformations:
- •Data Integration Hub transformations are based on the PowerCenter Custom transformation and they provide the same configuration options as other custom transformations. You can use them as you use other PowerCenter transformations.
- •Data Integration Hub transformations are connected transformations. Connected transformations pass data to or from other transformations.
- •Data Integration Hub transformations are passive transformations.
- •If a transformation port has a corresponding Data Integration Hub property, the value of the port takes precedence over the value of the property during runtime. When the session runs, if the value of the port is not null, the PowerCenter Integration Service uses the value of the port for processing. If the value of the port is null, the PowerCenter Integration Service uses the value of the Data Integration Hub property for processing.
- •Port names are case insensitive and prefix insensitive. DXEventID, dxEVENTid, and eventid are all treated as the same port.
- •When you run a PowerCenter workflow that uses a Data Integration Hub transformation, PowerCenter tries to connect to the Data Integration Hub repository to get the list of event statuses and types to use in the transformation. An error message indicates a failed connection. If the connection fails, PowerCenter gets the event type values from the Client plug-in configuration file. To resolve connection errors, verify that the connection section in the dxplugin.ini file contains the following configuration:
[DX_REPOSITORY]
; ODBC connection string to the DX repository
; CONNECTION_STRING=DRIVER={DataDirect 7.0 Oracle Wire Protocol};
UID=%1;PWD=%2;Host=localhost;Port=1521;SN=orcl
; CUSTOM_CONNECTION_STRING
; ODBC DSN to the DX repository
; DSN_NAME=dxOdbcResourceName
USER_NAME=DX
USER_PASSWD=DX
EVENT_TYPE_NAME=SELECT event_type_name FROM dx_event_type ORDER BY 1
EVENT_STATUS_NAME=SELECT event_status_name FROM dx_event_status ORDER BY 1