Announcement
Benjamin De Boe · Jan 8, 2019

Survey: using Tableau or Power BI with InterSystems products

Hi, 

As we announced at our Global Summit in October, we are developing dedicated connectors for a number of third-party data visualization tools for InterSystems IRIS. With these connectors, we want to combine an excellent user experience with optimal performance when using those tools to visualize data managed on InterSystems IRIS Data Platform.

If you are already using Tableau or Power BI products to access our data platform through their respective generic ODBC connectors today, we're interested in learning more about your experiences thus far and would be very grateful if you could spend a few minutes on our survey.

Thanks,
benjamin

10
0 3 552 3

Replies

@Benjamin De Boe 


Have you made any progress on this?

We just starting playing around with using Web Data Connectors in Tableau to call APIs into Cache.  

Best,

Mike

@Mike Davidovich 
I am working with Benjamin on an Alpha version of the Tableau connector.  Interested in your experience with using OBDC or JDBC connection to Tableau.  Have you used that and what else would you like to see with a Tableau connector?

Feel free to post here or email directly -- carmen.logue@intersystems.com

@Carmen Logue 
Thanks, Carmen!  I'm not sure I can add too much to your Alpha development I personally haven't been using the OBDC to connect into Cache.  What I do know is that some other groups have used ODBC to connect into Cache with SQL projections.  

My team want's to avoid projections specifically (at this point at least) because we tend to only use them to get data from Cache to our Data Warehouse (Oracle).  Other than that, we still traverse our database via globals and good old MUMPS programming.  The project I'm working on is taking those many many routines that we have that traverse globals for reporting, and transforming the data to JSON streams.  An %CSP.REST API will call those routines and provide the data to a Tableau web data connector so we can get instant, live data without projecting our whole database.  

I'm just getting start with Tablaue and Cache so I may have some more input in the future.

Best,

Mike