Real time Salesforce reporting via Pentaho BI Native JDBC - Are you serious?

Real time Salesforce reporting via Pentaho BI Native JDBC - Are you serious?

June 08, 2011 0 Comments


Gartner is talking about it.

Salesforce is talking about it.

Many users in the Pentaho community are aware of the input using Pentaho Data Integration (Kettle ETL).  This is certainly a competent first step.  But now Progress DataDirect has completely changed the game by enabling real time reporting against corporate data in via native JDBC.  We are now in a full sprint within the industry's race to Business Intelligence 2.0.  And Progress Software knows a thing or two about operational responsiveness.  Pentaho also promotes responsiveness through Agile BI, and hired Samuel Hon from Progress Software as VP of professional services in early 2011.  Both Pentaho and know Progress DataDirect, and you should too!

This tutorial shows you how to deploy ConnectXE for JDBC driver into your Pentaho Environment, configure Salesforce as a native JDBC data source, and inspect the metadata layer.

The preliminary steps are: 1. Install Pentaho Enterprise Edition 3.8.

2 . Install Progress DataDirect ConnectXE for JDBC using the instructions in the Progress DataDirect Connect for JDBC Installation Guide.  Click here to download a free 15-day trial.

3. Configure Pentaho for use with ConnectXE for JDBC drivers (Same steps apply for any DataDirect Connect for JDBC Type 5 drivers including Oracle, DB2, SQL Server, and MySQL).  Copy the driver JAR files into the various Pentaho tools and servers.  Download my useful BAT script to make deployment easier on Windows.

4. Restart the Pentaho Enterprise Console to complete configuration.  Login to Enterprise Console and click “Administration” and then “Database Connections”

Configure DataDirect JDBC with Pentaho

Click the “Plus” icon to add a new database connection.  Select the Driver Class as com.ddtek.jdbc.sforce.SForceDriver from the drop down menu, and specify the connection URL. jdbc:datadirect:sforce://

Configure DataDirect JDBC with Pentaho Enterprise Console

Click “Test” to test connect to

Test Connect DataDirect JDBC with Pentaho

Next, launch the MetaData Editor to model the business layers.  Select Connection Type as "Generic Database" and Access as "Native (JDBC)".  Then pass the settings similar to what was configured in Enterprise Console.

Configure real time Salesforce data with Pentaho

Import Salesforce "Tables"

Import Salesforce Tables

Expand the physical data layer to see "Columns" in Account "Table".

Now you can begin designing your reports as if is any other corporate JDBC data source.

Other Key Benefits:

  • Combine Salesforce data with other data sources.
  • View current and historical data about customers side-by-side.
  • Reconcile data across systems to gain complete view of customers.
  • Supplement data warehouse data with up-to-the-minute information.
  • Enhance Salesforce reporting with a full breadth of BI capabilities from Pentaho Agile BI.

Yes, we seriously integrated as a native JDBC data source for use with Pentaho.   I hope having real time Salesforce data in high performance reporting for your organization will get you talking to your business users and executive teams today!

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

Sitefinity Training and Certification Now Available.

Let our experts teach you how to use Sitefinity's best-in-class features to deliver compelling digital experiences.

Learn More
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