04-14-2016 03:11 PM - edited 08-03-2021 01:24 PM
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
Procedure
Additional Resources
Can In-Database connections be configured in Gallery to support uploading and scheduling of your In-Database workflow on Alteryx Server?
Do you have instructions for connecting In DB to Oracle DB? I'll keep looking for those instructions in the Community.
You can check out the Help for the In-D tools for instructions on how to connect to database. https://help.alteryx.com/2018.1/index.htm#cshid=LockInInput.htm. Every database may be setup slightly different, so you may need your database Admin to assist you with the setup.
@CraigAustin the section you are asking is something that you will have to know based on the connection received from your database Admin. A 'user' connection is a connection that you can only use and would be specific to your machine. If you are planning on sharing the workflow that you are using this connection in; you will want to use a system connection, which can be shared across machines. This is something that your database Admin will have to assist you with as Alteryx does not provide this connection information. If you are still having issues after speaking with your Database Admin please feel free to reach out to support@alteryx.com for assistance.
Thanks
Can the connection strings you create be deleted? For example, some failed attempts still show up and would like to clean it up. Thanks!
@karaclayton, Yes, Connections can be deleted in the "Manage In-DB Connections" option in the "Connect In-DB" tool. You'll see a "delete" button next to create new data connections.
Hi @AliS, I meant the connection string options for ODBC. I've attached a screenshot. Even when I've deleted the connections, the connection strings from past attempts are still listed.
Worked like a charm! Thanks so much for posting this solution!