Home Partners Company
Integrate Cloud Data Sources in Denodo with DataDirect Cloud

Integrate Cloud Data Sources in Denodo with DataDirect Cloud

April 25, 2016 0 Comments
Integrate Cloud Data Sources in Denodo with DataDirect Cloud 870x220

Integrate all of your cloud data sources in Denodo with DataDirect Cloud in six easy steps and take advantage of one stop shop data virtualization.

The Denodo Platform is a data virtualization platform that offers a wide range of features—including data manipulation, joins, imports, exports, stored procedures, and more. With this one stop shop for your data virtualization needs, you don’t want to have to scramble across different vendors to find connectivity too all of your important data sources. That is where DataDirect Cloud comes into the picture!

DataDirect Cloud is your hybrid connectivity hub that allows you to create secure connections to all of your cloud and on-premise databases, and then access these databases through an ODBC, JDBC, or OData interface. In this tutorial I’m going to walk you through how to utilize the DataDirect Cloud JDBC driver to connect to your Marketo data, but these same steps apply to connecting to any of the data source connections you have created within DataDirect Cloud!

Step 1: Create Connection to Marketo

Log in to DataDirect Cloud and ensure that you have the Marketo data source created. (Note that the Data Source Name field will be important to remember later.)

Edit Marketo Data Source

Data Source Name: The name you want to identify the source with.

User Name: The Oracle Service Cloud User ID.

Encryption Key:  This can be found in the Admin Section of your Marketo instance by clicking on the Web Service tab. After clicking on Web Services, this information is listed under the SOAP API section.

Soap Endpoint: This can also be found in the Admin Section of your Marketo instance by clicking on the Web Service tab. After clicking on Web Services, this information is listed under the SOAP API section.

Step 2: Download the DataDirect Cloud JDBC Driver

Go to the Downloads link (on the left of the DataDirect Cloud website) and click on the Windows JDBC Driver.

Go to the downloads link

Once the download is complete, run the installer (as an administrator if possible) to walk through the DataDirect Cloud JDBC driver installation.

Run the installer

Step 3: Create Your Oracle Service Cloud DB Connection within Denodo

Launch Denodo’s Virtual DataPort Administration Tool and right click on the Denodo admin database to select New > Data Source > JDBC.

Launch Denodo’s Virtual DataPort Administration Tool

Step 4: Complete the Database Connection Information

Fill out the provided Data Source fields as follows:

Database Adapter: Generic

Driver Class Path: Click on browse and navigate to the ddcloud.jar file located in the DataDirect Cloud JDBC driver’s lib folder (The default installation path is C:\Program Files\Progress\DataDirect\Cloud_for_JDBC_20)

Driver Class:

com.ddtek.jdbc.ddcloud.DDCloudDriver

Database URI:

jdbc:datadirect:ddcloud:database=Your_DataDirectCloud_DataSource_Name

Note: The “database” value is your Data Source Name from Step 1.

Login: DataDirect Cloud User Id

Password: DataDirect Cloud Password

Complete the Database Connection Information

Step 5: Select Your Tables

In this step you are able to select which Marketo tables you want to integrate with your Denodo application. Once you have made your selection you can select Create selected base views.

Select Your Tables

Once this step is complete you can see your selected tables listed under your new JDBC Data Source along with a successful import message.

successful import message

The below pictures are an example of executing a SELECT * FROM activityrecord table statement and a sample of the results within Denodo.

SELECT * FROM activityrecord table statement

SELECT * FROM activityrecord table statement

Step 6: Enjoy Your Marketo Integration with Denodo

You are now ready to execute queries, create joins, manage stored procedures, and fully utilize your Denodo application with your Marketo data thanks to DataDirect Cloud! Best of all, you can follow these steps with your other cloud sources such as Eloqua, Microsoft Dynamics CRM, Google Analytics, and more. If you do not already have DataDirect Cloud and are interested in trying this solution, pick up a free trial today!

Idaliz Baez

Idaliz is a Sales Engineer with Progress. After receiving her undergraduate degree from Duke University in Civil and Environmental Engineering, Idaliz Baez spent a year at NASA Goddard Space Flight Center gaining on-the-job experience before returning to Duke in pursuit of her Masters of Engineering Management degree. 

Read next Meet “Mustang,” the New Approach to Real-Time Data Access
Comments
Comments are disabled in preview mode.