[progress News] [progress Openedge Abl] Integrate Cloud Data Sources In Denodo With...

Status
Not open for further replies.
I

Idaliz Baez

Guest
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.png


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


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

run-the-installere7b44d6c326040ca885a8f43153814e8.png


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


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


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


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


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

6.png


select-from-activityrecord-table-statement.png


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!

Continue reading...
 
Status
Not open for further replies.
Top