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.

eloqua1

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

birstjdbc4

 

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
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
570x321__Top 7 Considerations Before Choosing a Chatbot for Your Enterprise
Top 7 Considerations Before Choosing a Chatbot for Your Enterprise
Read More
 
232-132_How to Simplify Application Usage & Deployment with Microapps
How to Simplify Application Usage & Deployment with Microapps
Read More
 
kinvey-console-thumbnail
Getting Started with Kinvey
Read More