Comprehensive solution for crafting and managing sophisticated digital experiences
Build engaging websites with intuitive web content management
Leverage a complete UI toolbox for web, mobile and desktop development
Build, protect and deploy apps across any platform and mobile device
Build mobile apps for iOS, Android and Windows Phone
Rapidly develop, manage and deploy business apps, delivered as SaaS in the cloud
Automate UI, load and performance testing for web, desktop and mobile
Host, deploy and scale Node.js, Java and .NET Core apps on premise or in the cloud
Optimize data integration with high-performance connectivity
Automate decision processes with a no-code business rules engine
Transform your businesses in order to survive in a completely digitized and connected world driven by software innovation.
Globally scale websites with innovative content management and infrastructure approaches
Content-focused web and mobile solution for empowering marketers
Faster, tailored mobile experiences for any device and data source
UX and app modernization to powerfully navigate today's digital landscape
Fuel agility with ever-ready applications, built in the cloud
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!
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 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.
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 © 2016, 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 or appropriate markings.