Alteryx Designer

Share your Designer product ideas - we're listening!
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.

OData Connector or Input Tool (RESTful API)

It would be wonderful for Alteryx to be able to connect to and query OData feeds natively, rather than using a 3rd-party driver or custom macro.   

 

OData querying is supported by quite a few familiar products, including Excel and PowerBISSIS/SSRS, FME SafeTableau, and many others. And the protocol is used to publish feeds from Microsoft Dynamics and Sharepoint, as well as many of the 10,000 publically available government datasets with API's (esp. those hosted by Socrata)   

 

I didn't see it as in the Idea section, but questions and workarounds have been discussed in the community a few times (11/15, 3/18, 4/18), and suggestions seem to be just to buy the $400-600 ODBC driver from CDATA (or ZappySys), or I could use a VBA script in Excel trigger a refresh, or create my own Alteryx connector macro (great series btw, though most was beyond my understanding!) 

   

While not opposed paying, kludging, or learning to program, they're just one more thing to build/buy, install, maintain, and break at the most inconvenient time 🙂

 

Thanks,
Chadd

 

OData Overview:

OData (Open Data Protocol) is an ISO/IEC approvedOASIS standard that defines a set of best practices for building and consuming RESTful APIs. OData helps you focus on your business logic while building RESTful APIs without having to worry about the various approaches to define request and response headers, status codes, HTTP methods, URL conventions, media types, payload formats, query options, etc. OData also provides guidance for tracking changes, defining functions/actions for reusable procedures, and sending asynchronous/batch requests.  OData RESTful APIs are easy to consume. The OData metadata, a machine-readable description of the data model of the APIs, enables the creation of powerful generic client proxies and tools.

More info at at http://odata.org

13 Comments
16 - Nebula
16 - Nebula

@TashaA and I were discussing the potential for splitting out RestAPI connector from the download tool.

This idea from you @ChaddB would fit in well with a refreshed RestAPI connector since this would be just another kind of RestAPI connection.

5 - Atom

Thanks @SeanAdams (still looking for user ID tag or upvote on the WYSIWYG!) 

11 - Bolide

@SeanAdams and @TashaA It was nice to meet and talk briefly at Inspire 2018!

 

I have added my 'star' to this idea as well. It would be very helpful to have a separate RESTful API tool, as this class of connections seems to be growing.

Alteryx
Alteryx

One more Star for a ootb OData connector

Alteryx
Alteryx

One more Star for a ootb OData connector as well

8 - Asteroid

Ding....another star

6 - Meteoroid
I added another star
5 - Atom

Add another star to provide OData connector in Alteryx

5 - Atom

OData Feed is necessary to import data from MS Project Online. This would be very useful for every PMO using Project Online!

Moderator
Moderator
Status changed to: Revisit

Thank you for your post! This idea is being updated to the Revisit status as we like this idea and it's something we'd like to keep in mind for future updates, but cannot put on the roadmap at this time. We'll update the status however once we have a better idea on if and when it could be included in the roadmap.