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.
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.
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.
9- From command prompt, run $BIRSTCONNECT_HOME\commandline\cmdui.bat
10- Click Add Task
11- Enter Task Name
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
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 :)
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 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.
Copyright © 2018 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.
Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.