Integrate all of your cloud data sources into 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!
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.)
Data Source Name: The name you want to identify the source with.
User Name: The Marketo 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.
Go to the Downloads link (on the left of the DataDirect Cloud website) and click on the Windows JDBC Driver.
Once the download is complete, run the installer (as an administrator if possible) to walk through the DataDirect Cloud JDBC driver installation.
Launch Denodo’s Virtual DataPort Administration Tool and right click on the Denodo admin database to select New > Data Source > JDBC.
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)
Note: The “database” value is your Data Source Name from Step 1.
Login: DataDirect Cloud User Id
Password: DataDirect Cloud Password
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.
Once this step is complete you can see your selected tables listed under your new JDBC Data Source along with a 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.
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 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.
Copyright © 2018 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.
Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.