Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here

Connecting to a Data Source not Listed in Supported Data Sources

Alteryx
Alteryx
Created

How To: Connecting to not Supported Data Sources

Alteryx Designer offers connecting to a plethora of different data sources. What can you do if your data source is not listed? There might be still other options of connecting from Designer.

Prerequisites

  • Alteryx Designer
    • Version
    • All 
  • Database


Procedure

The help documentation contains an exhaustive list of supported Data Sources. If a data source is not listed there that means that it has not been tested by Alteryx and therefore Alteryx cannot support it. There are three options in this case as will be explained below.
When referring to Help Documentation make sure to use the version of the documentation that matches your Designer version.
 

Connecting to REST API

If the data source you are trying to connect to offers a RESTful API to connect to, why not build your own connector to use the data source in Designer. Simply follow the steps in the Blog article connecting to REST API in 5 Minutes No Coding. In some cases a user on Alteryx Community already did the work and created the connector. 
Additionally, the Download tool is an option to retrieve data from a data source. See this post to get you started using the Download tool: APIs in Alteryx: cURL and Download Tool.
Note, that in some cases 3rd party software (potentially as a paid for offering) offer the functionality you are interested in.

 

Use ODBC Driver

If an ODBC driver is available for your data source, it may be possible to connect using the Generic ODBC option in the Input tool. The driver might provide the connectivity you are interested in, and while Alteryx cannot offer Customer Support for it, Community might still be a valuable resource.
 

Suggest new Product Idea

To suggest a new product feature, for example support of a currently unsupported data source, create a new product idea in Community. If it already exists you can increase its visibility within Product Management  by upvoting it or commenting on it.
 

Additional Resources