Birst Connect to any JDBC data source starting with Eloqua for SaaS BI

Birst Connect to any JDBC data source starting with Eloqua for SaaS BI

May 01, 2014 0 Comments

Our orange friends at Birst put on an exciting show at Birst Forward #BF14 in San Francisco; and I was inspired to take a test drive and run some analytics through our marketing automation system in Eloqua to analyze Progress’ appdev road show. I chose to use Birst Connect’s generic JDBC capabilities to automate the data extract from Eloqua into Birst; and DataDirect Cloud supplied the JDBC interface to Eloqua.

Birst Connect is a Java Web Start load utility that can be installed anywhere to load data into the Birst multi dimensional cloud database securely over https.  Once the data is loaded and processed, you can start to build visual analytics on the Birst SaaS BI platform.

Unlimited JDBC connectivity options out of the box from DataDirect

Forget manual processes and flat files.  DataDirect has amazing JDBC connectivity options such as Eloqua which is one of many sources available, including, Salesforce, Microsoft Dynamics, Progress Rollbase, Marketo, Hubspot, and we make a living connecting to anything you can think of.

Getting started with Birst Connect to Generic JDBC

1-     Log into (or login to your trial at

2-     Select your “Space” and click “Admin” (Upload and manage data, invite users)

3-     Choose “1- Load and Connect Sources” > “Use Birst Connect”

4-     Launch the Default configuration to generate a .jnlp file and download

5-     Unzip and copy the .jnlp to a $BIRSTCONNECT_HOME directory, “C:\apps\birstconnect”

6-     Sign up for a trial of DataDirect Cloud and create a connection to Eloqua.


7-     Download the DataDirect Cloud JDBC client installer and then copy “ddcloud.jar” into $BIRSTCONNECT_HOME\dist\lib.

8-     Modify “$BIRST_HOME\commandline\cmdui.bat” and set local values for JAVA_HOME, BirstConnect_Home and specify the .jnlp file.

set JAVA_HOME=C:\Program Files\Java\jdk1.7.0_51
set BirstConnect_Home=C:\apps\BirstConnect
"%JAVA_HOME%\bin\java" -cp "%BirstConnect_Home%\dist\*;%BirstConnect_Home%\dist\lib\*" -Djnlp.file="%BirstConnect_Home%\315cbfce-3301-48c2-bfb9-47efbd8cb0f3.jnlp" -Xmx1024m com.birst.dataconductor.DataConductorApp

9-     From command prompt, run $BIRSTCONNECT_HOME\commandline\cmdui.bat

10-  Click Add Task

Birst Connect to SaaS data


11-  Enter Task Name

Birst Connect to Eloqua

12-  Click Sources > Add Table(s)

Driver Name is: com.ddtek.jdbc.ddcloud.DDCloudDriver

Connection String is: jdbc:datadirect:ddcloud://;databaseName=eloqua

Login with your DataDirect Cloud Credentials

Click Get Tables

Birst Connect to Generic JDBC sources

13-  Select Table and click OK.  Alternately, you could write a SQL-92 query against Eloqua if you wish to flatten the objects with JOINs.

The data is now available from Birst for processing, and you know what to do from there.  For my simple chart, we'll assume it's something like bounce rates for campaign forms since it's going down over time :)



Get started loading unlimited data into Birst until it Birsts (couldn’t resist)

1. Download a trial for any DataDirect Connect JDBC driver or try the DataDirect Cloud Connectivity Service to load data from any JDBC source.

2. Or call 1-800-876-3101 to speak with a systems engineer on JDBC data connectivity to SaaS, Big Data, SQL, NoSQL, and more.


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 are disabled in preview mode.
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
Then, Now and Beyond: The Future of Back Office Software
Read More
2020 Progress Data Connectivity Report
2020 Progress Data Connectivity Report
Read More
Getting Ahead of the Hybrid Data Curve
Read More