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.
on 04-14-201603:11 PM- edited
3 weeks ago
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.
Windows Operating System
In Designer, drag and drop the Connect 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 Sourcedrop-down.
Under Connection Type, select User, System or File connection.
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 Query window should appear.
The connection will now be stored in the Connection Name drop-down.