Goal

This document explains how to configure Informatica Cloud to connect to a Denodo Virtual DataPort database.

Content

Overview

Informatica Cloud is an on-demand subscription service that provides a platform for cloud integration and data management. Informatica Cloud provides the ability to configure connections, create users, and create, run, schedule and monitor tasks.

This document is focused on explaining how to configure Informatica Cloud to connect to a Denodo Virtual DataPort database.

Architecture

Informatica Cloud runs on the Informatica Cloud hosting facility which stores all the tasks and organization information. The Informatica Cloud Secure Agent is a lightweight program that Informatica Cloud needs to integrate and manage your data and runs within your network. To use Informatica Cloud Secure Agent, you must install the agent on your network.

Connect from Informatica Cloud to Virtual DataPort

Informatica Cloud and Secure Agent configuration

1. Download and install the Informatica Cloud Secure Agent.

1. Login into Informatica Cloud and go to the Administrator section.
2. Click on the Runtime Environments tab placed on the left side menu.
3. Click on the Download Secure Agent button.

4. Select the right platform.
5. Install the Secure Agent.

2. Login into Informatica Cloud Secure Agent with your account credentials.

1. Note that in order to run the Secure Agent it is needed to do it as an Administrator user.

3. Login into the Informatica Cloud Web app.

4. The new Runtime Environment should be automatically configured. If not, configure a new Runtime Environment including the Cloud Secure Agent installed by doing the following:

1. Go to the Administrator section.
2. Click on New Runtime Environment.
3. Select the new environment anc click on Add or Remove Secure Agents option.
4. Select the Secure Agent.
5. Click on Select.

5. Create a User Group granting all the available permissions and add your user to this user group.

1. Click on User groups section.
2. Click on Add Group.
3. Set a name to the User Group.
4. Grant all the available permissions in this group.
5. Add your user account to this group.
6. Click on Save.

JDBC connection to Denodo Virtual DataPort

1. Go to Informatica Cloud web app.
2. Go to the Administrator section.
3. If you do not have previously installed the JDBC_IC (Informatica Cloud) connector, click on Add-On connectors, look for the JDBC_IC connector and install it.
4. Click on Connections.
5. Click on New Connection.
6. Set name and description.
7. Select JDBC_IC as type.
8. Select the previously configured runtime environment.
9. Set the JDBC connection URL. (syntax: jdbc:vdb://host:port/database)
10. Set the JDBC Jar Directory to the folder containing the Denodo Platform JDBC jar.
11. Set JDBC Driver Class Name to com.denodo.vdp.jdbc.Driver.
12. Set the Schema to the name of the Virtual Database you want to connect to.
13. Set a valid username and password in order to connect to the corresponding Virtual DataPort database.
14. Click on Test.
15. Click on Save.

ODBC connection to Denodo Virtual DataPort

1. Create a System DSN data source from the Windows “ODBC Data Source Administrator” tool  using the Denodo ODBC driver to connect to a Virtual DataPort database. You can check the “Set Up a DSN on Windows” section of the VDP Developer Guide for more information.

1. It has to be a System DSN data source since Informatica Cloud is not able to find  User DSN data sources. An error saying the datasource name has not been found is shown.

2. Configure an ODBC connection to Virtual DataPort database in Informatica Cloud.

1. Go to Informatica Cloud web app.
2. From the Administrator section.
3. Click on Connections.
4. Click on New Connection.
5. Set name and description.
6. Select ODBC as type.
7. Select the previously configured runtime environment.
8. Set a valid username and password in order to connect to the corresponding Virtual DataPort database.
9. Set the Data Source name to the name of the ODBC data source previously configured in Windows (System DSN).
10. Set the Schema to the Virtual Dataport database name.
11. Set Code Page to “UTF-8”.
12. Set ODBC subtype to Other.
13. Click on Test.
14. Click on Save.

Testing the Virtual DataPort connection

1. Create a Data Synchronization task in order to export the content of a particular  Virtual DataPort view into a specified file.

1. Go to the Data Integration section.
2. Inside of the Recent Assets section, click on Create.
3. From Tasks expand Integration > .
4. Click on Copy data to a new target.
5. Definition section:

1. Set a name and a description.
2. Select the Runtime Environment created before.
3. Give a Mapping name

6. Click on Next.
7. Source section:

1. Set Connection to the required ODBC/JDBC connection previously created to connect to your Virtual DataPort database.
2. Set Source Type to Single.
3. Set Source Object to the Virtual DataPort view you want to export.

8. Click on Next.
9. Target section:

1. Create a new Connection to the export file by clicking on “New”.

1. Set the Connection Name and Description.
2. Set Type to Flat File.
3. Set the Runtime Environment.
4. Set manually the Directory to the file system directory where you want to export the data.
5. Set Code Page to UTF-8.
6. Click on Test.
7. Click on Ok.

2. Set the Target Object to the file you want to export the data by clicking on Create Target and setting the corresponding Object name.

10. Click Ok.

11. Click on Next.
12. Input Parameters section: Select the default settings for the Input Parameters section.

13. Click on Next.
14. Schedule section: Select the default settings for the Schedule section.

15. Click on Finish.

2. Click Run.
3. Finally you can check the result of the Mapping task by taking a look at the export file.

References

1. Denodo VDP Developer Guide: Set up a DSN on Windows
2. Informatica Cloud Documentation
3. Informatica Cloud Knowledge Base