Goal

This document explains how to configure Informatica Cloud to connect to a Denodo Virtual DataPort (VDP) 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 Runtime Installer button, and select Environment Type Secure Agent.

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 and 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. Navigate to the following directory on the Secure Agent Machine:

<Secure Agent installation directory>/ext/connectors/thirdparty/

2. Create a folder named informatica.jdbc_v2, and inside create another folder named common.
3. Navigate to the following directory in your Denodo Server:

<DENODO_HOME>/tools/client-drivers/jdbc/vdp-jdbcdriver-core/

4. Copy the Denodo JDBC Driver  denodo-vdp-jdbcdriver.jar into the Secure Agent directory created on step 2 above.
5. Go to Informatica Cloud web app.
6. Go to the Administrator section.
7. Click on Connections.
8. Click on New Connection.
9. Set name and description.
10. Select JDBC2 as type.
11. Select the previously configured runtime environment.
12. Set JDBC Driver Class Name to com.denodo.vdp.jdbc.Driver.
13. Set the Connection String. (syntax: jdbc:vdb://host:port/database)
14. Set a valid username and password in order to connect to the corresponding Virtual DataPort database.
15. Click on Test.

16. 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. Above the  Home  section, click on New.
3. From Tasks expand Integration >
4. Click on Copy data to a new target.

5. Click on Create.
6. Definition section:

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

7. Click on Next.
8. Sources 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.

9. Click on Next.
10. Targets 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.

11. Click Ok.

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

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

16. 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

Set up a DSN on Windows

Informatica Cloud Documentation

Informatica Cloud Knowledge Base