This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
How To: Create an In-Database (In-DB) Connection Apart from making standard database connections, which allow for data to be pulled from the database directly into Alteryx, Designer also has In-Database functionality. The In-Database tools allow for the workflow created to be converted into a query which will then be executed on the database, and not locally in Designer. Prerequisites Alteryx Designer Windows Operating System Procedure In Designer, drag and drop theConnect In-DB tool (located in the In-Database tool palette) onto the canvas Select the “Manage Connections…” option to establish a new In-DB connection The Manage In-DB Connections window should appear. To configure this window: Select the Data Source/Database type from the Data Source drop-down. Under Connection Type, select User, System or File connection. For file connections, see this article:How To: Create an Alteryx In-DB Connection File If you do not see the System option available, see this article:Unable to create System Connection/System Connection type missing Under Connections, select New. Under Connection Name, enter a name for this connection. Under Driver, select the method of connection to use. Click the Connection String drop-down. You can choose to use an existing connection or create a new connection by clicking the New database Connection…option. You can also paste in the full connection string if you have it available. Repeat steps 5 and 6 for the Write tab. Click OK. If the connection was successful, the Choose Table or Specify Querywindow should appear. The connection will now be stored in the Connection Name drop-down. Additional Resources Troubleshooting Database Connections FAQ: How Do the In-Database tools Work? Database Issues – Working with Alteryx Customer Support Engineers (CSEs)
There is a comprehensive list of Data Sources Alteryx Designer / Server can connect to. While only these are supported you still might be able to build your own connector. Additionally a product feature can be requested.
User is attempting to connect to Hadoop Hive with Active Directory Kerberos (Kerberos SSPI) in Alteryx and getting an error: Failed to get username: Routine Error: Unspecified GSS failure. Minor code may provide more information.
The test button in the ODBC DSN is successful.
Alteryx has the ability to connect with MIT Kerberos and Active Directory (Kerberos SSPI) based Hadoop implementations. With this feature came the need to tell the driver that you are using Windows Kerberos/Kerberos SSPI and not MIT's version.
Alteryx can connect to databases using different methods. This guide will focus on setting up an OleDB connection to SQL server, however, the same general process can be followed to connect to any database via OleDB.