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.
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.
Subscribe to get all the news, info and tutorials you need to build better business apps and sites
Copyright © 2019 Progress Software Corporation and/or its subsidiaries or affiliates.All Rights Reserved.
Progress, Telerik, Ipswitch, 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.