Home Services Partners Company
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 Force.com, 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 birst.com (or login to your trial at https://freetrial.bws.birst.com)

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 BirstConnect.zip

5-     Unzip BirstConnect.zip 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://service.datadirectcloud.com;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

Sumit Sarkar is a Chief Data Evangelist at Progress, with over 10 years experience working in the data connectivity field. The world's leading consultant on open data standards connectivity with cloud data, Sumit's interests include performance tuning of the data access layer for which he has developed a patent pending technology for its analysis; business intelligence and data warehousing for SaaS platforms; and data connectivity for aPaaS environments, with a focus on standards such as ODBC, JDBC, ADO.NET and ODATA. He is an IBM Certified Consultant for IBM Cognos Business Intelligence and TDWI member. He has presented sessions on data connectivity at various conferences including Dreamforce, Oracle OpenWorld, Strata Hadoop, MongoDB World and SAP Analytics and Business Objects Conference, among many others. 

Read next Building Hybrid Mobile Apps on Existing Systems via OData
Comments are disabled in preview mode.