Data Sources
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.
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:
- Go to Data Sources and select Add Data Source.
- Select a Technology
- Enter a name for the Data Source. Name can be a maximum of 63 characters.
- Enter Hostname (Machine name, FQDN, or IP of Host).
- Enter Database when required.
- Select Test Connection. Test Connection tests if the host is reachable, but doesn't authenticate.
- To create connections for the data source later, select Add without Connection.
- If you know the Credential you want to use with this Data Source, select Next to add the connection now.
- 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).
- In the Select... dropdown, select an existing credential or Create New Credential.
- Enter a Credential Name. It should indicate the purpose of the account.
- Enter a Username. It should be for built-in auth to the database, not a Windows user account.
- Enter a Password. It's the password for manual auth to the database.
- Select Test Connection. The test authenticates to the Data Source.
- 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.