How to Integrate Paxata and Oracle Eloqua

How to Integrate Paxata and Oracle Eloqua

May 18, 2016 0 Comments

Do you want the best in marketing automation AND the best in data preparation? Integrate Paxata and Eloqua with DataDirect Cloud.

Oracle Eloqua enables marketers to plan and execute campaigns while delivering a personalized customer experience for their prospects. Paxata is an enterprise-grade solution built for interactive, self-service data preparation at scale. Integrate them in this step-by-step tutorial with DataDirect Cloud!

Step-by-Step

  1. Signup for a ProgressID/login to DataDirect Cloud by starting here and clicking "Get Started": https://www.progress.com/cloud-data-integration
  2. Once you have a ProgressID, log in to DataDirect Cloud:

    Signup for a ProgressID/login to DataDirect Cloud

  3. Create a new DataSource by choosing Data Sources / +New Data Source

    Create New DataSource by choosing ‘Data Sources / +New Data Source’

  4. Choose Eloqua as the source and add your Eloqua connection information (User, Password, Company). Test connect to confirm a successful connection and click Save:

    Choose Eloqua as the source and add your Eloqua connection information Choose Eloqua as the source and add your Eloqua connection information

    Choose Eloqua as the source and add your Eloqua connection information
  5. Next, log in to Paxata. Once logged in, create a DataSet within your Library by clicking on Library and +Add from a database:

    (You will use this data later when creating your Project.)

    Create a dataset within your Library

  6. Add the DataDirect Cloud JDBC connection information for the DataSource you created in Step #3 and click ‘Next’:

    jdbc:datadirect:ddcloud:database=Eloqua
    (Note: Database=the Data Source Name you created in Step #3, and the user and password are your DataDirect Cloud credentials—not your Eloqua credentials.)

    Add the DataDirect Cloud JDBC connection information for the DataSource

  7. Test your connection by issuing/previewing a SQL Query, then click Finish in order to complete your new DataSet:Test your connectionTest your connection
  8. Next, create a new Project that uses your new DataSet by choosing Projects and +add:

    Create a new Project

  9. Add a Project Name and click Save and Open. Select your DataSet, which was created in steps 5 & 6, as a base for the new Project:

    Add Project Name and click ‘Save and Open’Add Project Name and click ‘Save and Open’

    Choose your DataSet:

    Choose your DataSet

    Preview of DataSet within Project:

    Preview of DataSet within Project

    Once the DataSet is in the Project, it is initially in Preview mode in order to review and confirm it is the correct DataSet. Hit Save to commit the DataSet to the Project.

  10. At this point you can add Filters to your DataSet. 
    For example: hover over a column in order to change all text to become uppercase or lowercase, or convert text characters into numeric. You can also separate a single column into multiple columns, rename column headings and more. Or you can use DataSet Operations to change the entire DataSet (pattern highlighting—duplicate records, duplicate values, remove white spaces, etc.)

    Add Filters to your DataSetAdd Filters to your DataSet

    The above is a text filter to only show Custom TableNames.

  11. Once you have your desired DataSet, publish the new ‘AnswerSet’ to Hive as a clean DataSet ready for reliable analytics.

    Publish the new ‘AnswerSet’ Publish the new ‘AnswerSet’

    New Eloqua AnswerSet with a Filter of Custom Tables:

    New Eloqua AnswerSet with a Filter of Custom Tables

  12. Once published, connect to the DataSet via a Hive JDBC Driver with the provided connection information:

To dataset via Hive JDBC Driver

All Finished

Now that you are finished, you are well on your way to having the best self service data preparation for the best marketing automation platform. Our team at DataDirect values you, and we want to help you  succeed in any way we can. Please leave a comment if you have a question or give us a call at 1-800-477-6473. Considering DataDirect Cloud? Pick up a free trial today!

Try Now

Sumit Sakar

Sumit Sarkar

Technology researcher, thought leader and speaker working to enable enterprises to rapidly adopt new technologies that are adaptive, connected and cognitive. Sumit has been working in the data access infrastructure field for over 10 years servicing web/mobile developers, data engineers and data scientists. His primary areas of focus include cross platform app development, serverless architectures, and hybrid enterprise data management that supports open standards such as ODBC, JDBC, ADO.NET, GraphQL, OData/REST. He has presented dozens of technology sessions at conferences such as Dreamforce, Oracle OpenWorld, Strata Hadoop World, API World, Microstrategy World, MongoDB World, etc.

Comments
Comments are disabled in preview mode.
Topics
Latest Stories
in Your Inbox

Subscribe to get all the news, info and tutorials you need to build better business apps and sites

More From Progress
progress-next-logo
ProgressNEXT: Premier Event for Modern Application Development
Read More
 
kinvey-console-thumbnail
Getting Started with Kinvey
Read More
 
whatdevsthink
Low-Code Platforms: What Developers Think and Why
Read More