Data Sources

Version:
Current
Last modified: March 05, 2021

Supported Data Sources

Analytics Hub fully supports these data source technologies:

  • Amazon Redshift
  • Microsoft SQL Server
  • MySQL
  • Oracle
  • PostgreSQL
  • SAP HANA
  • Snowflake

Full support includes metadata loading, workflow dependency resolution, and usage in workflows. Workflow dependency resolution is limited to a subset of dependencies displayed and configured in Designer. This subset includes Input Data tools and Output Data tools in non-bulk load configurations. More tools capable of input and output connections and macros are functional within the workflow but won't appear in workflow dependencies. 

Other Data Sources are partially supported only as Input and Output tools in workflows. These data sources can't be used with metadata loading or workflow dependencies. These data sources require the appropriate ODBC driver and DSN configuration to be defined on Analytics Hub engine workers.

Data Sources and Drivers
Technology Format Driver
MS SQL DSN-less ODBC Driver 17 for SQL Server
Redshift DSN-less MySQL ODBC 8.0.20 *
Snowflake DSN-less Oracle Instant Client
MySQL DSN-less PostgreSQL 11.01
Oracle DSN-less Simba Redshift ODBC 1.04.06.1
PostgreSQL DSN-less Simba Snowflake ODBC 1.02.00.1005
SAP HANA DSN-less SAP HANA 1.00.85.02 *
(Any ODBC) DSN Various drivers as supported by Alteryx Designer. Driver must be installed and configured on AAH Engine Workers.
File Share UNC Path (\\Servername\dir) N/A

*All of the drivers for the supported technologies are installed with the Analytics Hub installer except for SAP HANA 1.00.85.02 (64-bit) and MySQL ODBC 8.0.20 (64-bit), which you have to install separately.

Add a Data Source

Users with the role of Site Admin, Data Steward, or Contributor can add data sources. 

To add a data source, follow these steps:

  1. Go to Data Sources and select Add Data Source.
  2. Select a Technology
  3. Enter a name for the Data Source. Name can be a maximum of 63 characters. 
  4. Enter Hostname (Machine name, FQDN, or IP of Host).
  5. Enter Database when required.
  6. Select Test ConnectionTest Connection tests if the host is reachable, but doesn't authenticate.
  7. To create connections for the data source later, select Add without Connection.
  8. If you know the Credential you want to use with this Data Source, select Next to add the connection now.
  9. Enter a Connection Name and Description that describe what is being accessed in the Data Source (for example, Connection Name: CS_PROD_SQL_ANALYSTS Description: Standard query access to production SQL Server).
  10. In the Select... dropdown, select an existing credential or Create New Credential.
    Screenshot of Create New Credential Settings
  11. Enter a Credential Name. It should indicate the purpose of the account.
  12. Enter a Username. It should be for built-in auth to the database, not a Windows user account.
  13. Enter a Password. It's the password for manual auth to the database. 
  14. Select Test Connection. The test authenticates to the Data Source. 
  15. Select Add.

In-Database Configuration

A file connection must be used and the file (.indbc) itself must be packaged with the workflow or on an accessible network file share. Learn more about In-Database tools and how to manage in-database connections in Designer. 

Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.