Tibco Spotfire connections to Salesforce via ODBC (includes Silver Spotfire)

Following my presentation at Dreamforce, several shops shared their excitement about the unique analytics and data discovery enabled by DataDirect ODBC and JDBC access to SaaS.  In an ideal world, self service minded analysts have always wished for direct access to LIVE data.  Most of us gave up on this dream and accept that fetching live data is taboo.  But, that dream is reborn with the introduction of the DataDirect Connect XE for ODBC Salesforce driver – direct real-time connectivity from standards based applications such as Spotfire to SaaS data.

Getting started with Tibco Spotfire and Salesforce.com ODBC for self service analytics

I was able to complete this tutorial in 15 minutes last week waiting for my flight at Boston Logan.  Tibco Spotfire versions (including Silver Publisher and Analyst) support any ODBC compliant data source, and therefore the DataDirect drivers are fully supported. Spotfire’s Application Data Services is not required for this tutorial.

1. Download and install the 15 day trial of the latest 32-bit or 64-bit DataDirect Connect XE for ODBC Salesforce driver for Microsoft Windows which supports the latest Salesforce.com API versions.

2. Create an ODBC data source to Salesforce.com.  Here is a great video by Jeff Leinbach to create the data source.

3. Configure Salesforce ODBC data source and click configure and go to the “SQL Engine” tab and change SQL Engine Mode to “1- Server”.

odbc70sp1-server1

Click Edit Server Settings and click “Start” button to launch the Salesforce Service.  The button label will change to “Stop” meaning the service has started.

odbc70sp1-server2

4. Launch Tibco Spotfire 5.x

5. Add Data Tables  and select “Odbc data provider”

6. Connect using your personal Salesforce.com login and view your objects and fields to construct a SQL-92 statement.  Note that I used a SUBSTRING function, and INNER JOIN syntax between ACCOUNT and OPPORTUNITIES since the ODBC driver supports SQL-92.

7. Quickly build visualizations against the data and you can perform a real-time reload at anytime.  I had a lot of fun with the 3D scatter plot!

What about direct SQL access from Spotfire to other SaaS sources?

The reason we all love standards based SQL access is that everyone can access the data.  Other SaaS solutions provide ODBC drivers such as NetSuite, Microsoft Dynamics, Service Now, Plex Online, etc.  Or for direct SQL access from Tibco Spotfire to sources such as Aprimo, Eloqua, SugarCRM, RightNow,Success Factors, Taleo, ADP. Intaact, Concur we encourage you to check out the recently announced DataDirect Cloud.

Questions?

Post a blog comment or call 1-800-876-3101 to speak with a live Solutions Consultant to learn how other organizations are making progress with direct real-time SQL access to Salesforce from Tibco Spotfire.

 

Shares
Sumit Sarkar

Sumit Sarkar

Principal Systems Engineer, Progress DataDirect at Progress Software
Data Access Evangelist, Speaker and World's leading consultant on direct SQL access to Cloud Data. Sumit Sarkar has been working in the data connectivity field for 10 years. His 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 IUC34, IUC35, Progress Revolution, Oracle User's Group, Collaborate 12, Dreamforce 2012, Cloud Computing Expo 2012, PRGS13 Exchange, Dreamforce 2013, Oracle OpenWorld 14, PRGS14, DF14 Presented related webinars in collaboration with IOUG, DZone, Progress DataDirect and Progress Communities.
Sumit Sarkar

@SAsInSumit

Data Access Evangelist, Speaker and World's leading consultant on open data standards for Cloud Data. TDWI, Pescatarian, Simcity Celeb - I tweet my own tweets.
Check out Pivotal @PivotalBigData share on testing #DataDirect JDBC for Hawq / Greenplum http://t.co/eT3MdfpbPX - 20 hours ago
Sumit Sarkar

2 Comments

  1. HI Sumit, I am very interested in this driver, unfortunately I am not able to get it to to my SFDC instance work. The driver seems to install fine and test connect is successful, but connecting to SFDC in Spotfire stalls out at the login screen when trying to connect to the SFDC ODBC source. I enter my SFDC username and password, and it will not accept it. Any suggestions?

    Thx,

    CW

    Reply
    • CW, sorry for not seeing your question sooner. If you are having issues logging in from Spotfire specifically, I recommend configuring the logon domain on the security tab since some applications do not expect logins to be email addresses.

      Reply

Submit a Comment

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>