1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'Progress Blog' started by Idaliz Baez, Apr 25, 2016.

Thread Status:
Not open for further replies.
  1. Idaliz Baez

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

    [​IMG]

    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.

    [​IMG]

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

    [​IMG]

    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.

    [​IMG]

    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

    [​IMG]

    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.

    [​IMG]

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

    [​IMG]

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

    [​IMG]

    [​IMG]

    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...
     
  2.  
Thread Status:
Not open for further replies.

Share This Page