Create Informatica Mappings From/To a JDBC Data Source for HCL Domino

Informatica provides a powerful, elegant means of transporting and transforming your data. By utilizing the CData JDBC Driver for HCL Domino, you are gaining access to a driver based on industry-proven standards that integrates seamlessly with Informatica's powerful data transportation and manipulation features. This tutorial shows how to transfer and browse HCL Domino data in Informatica PowerCenter.

Deploy the Driver

To deploy the driver to the Informatica PowerCenter server, copy the CData JAR and .lic file, located in the lib subfolder in the installation directory, to the following folder: Informatica-installation-directory\services\shared\jars\thirdparty.

To work with HCL Domino data in the Developer tool, you will need to copy the CData JAR and .lic file, located in the lib subfolder in the installation directory, into the following folders:

• Informatica-installation-directory\client\externaljdbcjars
• Informatica-installation-directory\externaljdbcjars

Create the JDBC Connection

Follow the steps below to connect from Informatica Developer:

1. In the Connection Explorer pane, right-click your domain and click Create a Connection.
2. In the New Database Connection wizard that is displayed, enter a name and Id for the connection and in the Type menu select JDBC.
3. In the JDBC Driver Class Name property, enter: cdata.jdbc.domino.DominoDriver
4. In the Connection String property, enter the JDBC URL, using the connection properties for HCL Domino.

   Prerequisites

   The connector requires the Proton component to be installed. Normally, Proton is distributed as part of the AppDev pack. See the HCL documentation for instructions on acquiring and installing Proton or the AppDev pack.

   Once the Proton service is installed and running, you will also need to create a user account and download its Internet certificate. This certificate can be used to set the connector certificate connection properties.

   Authenticating to Domino

   • Server: The name or IP address of the server running Domino with the Proton service.
   • Port: The port number that the Proton service is listening on.
   • Database: The name of the database file, including the .nsf extension.
   • SSLClientCertType: This must match the format of the certificate file. Typically this will be either PEMKEY_FILE for .pem certificates or PFXFILE for .pfx certificates.
   • SSLClientCert: The path to the certificate file.
   • SSLServerCert: This can be set to (*) if you trust the server. This is usually the case, but if you want to perform SSL validation, you may provide a certificate or thumbprint instead. See the documentation for SSLServerCert for details.

   Additional Server Configuration

   The connector supports querying Domino views if any are defined. Before views can be queried by the connector they must be registered with the design catalog.

   Please refer to the Catalog Administration section of the AppDev pack documentation for details on how to do this.

   Built-in Connection String Designer

   For assistance in constructing the JDBC URL, use the connection string designer built into the HCL Domino JDBC Driver. Either double-click the JAR file or execute the jar file from the command-line.

   java -jar cdata.jdbc.domino.jar

   Fill in the connection properties and copy the connection string to the clipboard.

   A typical connection string is below:

   jdbc:domino:Server=https://domino.corp.com;Database=names.nsf;Port=3002;SSLClientCertType=PEMKEY_FILE;SSLClientCert=full_path_of_certificate.pem;SSLServerCert=*

Browse HCL Domino Tables

After you have added the driver JAR to the classpath and created a JDBC connection, you can now access HCL Domino entities in Informatica. Follow the steps below to connect to HCL Domino and browse HCL Domino tables:

1. Connect to your repository.
2. In the Connection Explorer, right-click the connection and click Connect.
3. Clear the Show Default Schema Only option.

You can now browse HCL Domino tables in the Data Viewer: Right-click the node for the table and then click Open. On the Data Viewer view, click Run.

Create HCL Domino Data Objects

Follow the steps below to add HCL Domino tables to your project:

1. Select tables in HCL Domino, then right-click a table in HCL Domino, and click Add to Project.
2. In the resulting dialog, select the option to create a data object for each resource.
3. In the Select Location dialog, select your project.

   Create a Mapping

   Follow the steps below to add the HCL Domino source to a mapping:

   1. In the Object Explorer, right-click your project and then click New -> Mapping.
   2. Expand the node for the HCL Domino connection and then drag the data object for the table onto the editor.
   3. In the dialog that appears, select the Read option.

   Follow the steps below to map HCL Domino columns to a flat file:

   1. In the Object Explorer, right-click your project and then click New -> Data Object.
   2. Select Flat File Data Object -> Create as Empty -> Fixed Width.
   3. In the properties for the HCL Domino object, select the rows you want, right-click, and then click copy. Paste the rows into the flat file properties.
   4. Drag the flat file data object onto the mapping. In the dialog that appears, select the Write option.
   5. Click and drag to connect columns.

   To transfer HCL Domino data, right-click in the workspace and then click Run Mapping.