- andrewrichardsonAsked on April 16, 2012 at 02:00 PM
Good afternoon - I use a data viz software called Tableau. It gives me the functionality to connect to a valid OData url. Is this something that I can get access to from JotForm? I'd like to be able to have my submitted data update in real time.
- JotForm SupportjonathanAnswered on April 16, 2012 at 05:05 PM
You can generate data out of the JotForm submitted data (in HTML, CSV, Excel formats) using the Reports . I am not familiar with Tableau, but did you mean to say that you wanted to JotForm data go to Tableau and be able to have the data updated at Tableau side? Can you pleae clarify more what we wanted to achieve.
Thank you for your patience.
- andrewrichardsonAnswered on April 16, 2012 at 07:52 PMI understand that I can manually download the data but I want Tableau to be able to speak directly to the database so that my Tableau data viz can update in real time to those that need to see it. Currently I have to manually download the data and then update Tableau with it.
- JotForm SupportidarktechAnswered on April 16, 2012 at 08:24 PM
Sorry but we do not have integrations for Tableau, currently. I know this a bit tedious but what you can do for now is to manually update your data to your Tableau software. However, we'll take note of this and consider this in the future. But, we'll tag this as low priority for now since there's no much request about this.
Thanks for your understanding. Have a great day!
- andrewrichardsonAnswered on April 17, 2012 at 08:02 AM
Thanks for the answer. I'm sure that connecting to Tableau directly isn't very high priority. But being able to connect directly to the database I'm sure would be high priority for MANY of your subscribers. Instead of having to export the data into another program, being able to have programs gain direct access to the data would be invaluable.
- Matt IrelandAnswered on June 14, 2012 at 11:45 PM
Firstly, Andrew - Good question, but the support guys have completely missed the point on oData.
There is a huge moving the industry to support oData as a standard for accessing data between different systems.
There's a new oData tool for Excel, and Telerik have just released an oData datasource control for binding webforms controls to oData feeds.
Microsoft Lightswitch has also just incorporated oData (in and out). Here is a huge potential. Lightswitch currently uses silverlight to build desktop applications, but there is a real need for customer facing surveys and forms which then integrate back into the database. You guys could expose oData feeds from your forms and then advertised to light switch community ( which is currently growing rapidly because of their announcement to support mobile platforms a few days ago). Take a look at the forums... you will see there is a massive need for the ability to integrate desktop HTML forms.
I'm posting this to other form builders and Jotform in the hope that one of you will take it up... whoever does will corner a huge extra segment of the market.
- jeanettebmzAnswered on June 15, 2012 at 12:39 AM
I am forwarding this petition made by you and andrewrichardson to the feature request list
Hopefully the development team will take into consideration your suggestion with a higher priority.
- NYSTEMAnswered on June 15, 2012 at 08:43 AM
Matt - Thanks for chiming in. I just read up on Lightswitch and it sounds great in being able to incorporate oData into the applications.
Jeanette - I think that this could be a real boon if JotForm was the first to offer this feature. If could tell my application (Lightswitch built, Tableau, etc.) where to go get the data as it is uploaded in real time, I'd have a HUGE reason to use JotForm exclusively for every form that we build.
Thanks for pushing this up the request list.
- jeanettebmzAnswered on June 15, 2012 at 11:39 AM
Thank you very much for your kind and supportive words
The request is already in the nice to do list. And though it currently has a low priority, it is already assigned to a developer to take in consideration once high priority issues and requests are sorted out. The timeframe is uncertain an this point, but I think we will see it in the near feature.