Connecting Alteryx with Azure SQL DB | Connectionstring

[ulrichfelgenhauer]

Hello all,

I unfortunately have little experience with Alteryx in combination with MS Azure/In-Database. I am running Alteryx Designer on a MS Azure VM and trying to connect to a MS Azure SQL Database via the 'Connect In-DB' tool by checking off the instructions from the following:

https://help.alteryx.com/current/designer/connect-db-tool.

From the looks of it, the connection string seems to be the problem because when I run the workflow I get the following error message:

"Error: Connect In-DB (2): The file "Driver={ODBC Driver 13 for SQL Server};Server=tcp:{SERVERNAME}.database.windows.net,1433;Database={DATABASENAME};Uid={USERID};Pwd={PASSWORD};Encrypt=yes;TrustServerCertificate=no;Connection Timeout=30;" is not a known format." (--> The values {SERVERNAME}, {DATABASENAME} & {PASSWORD} I inserted afterwards, the rest is original).

I have never worked with connection strings before and suspect that the composition is wrong, maybe information needs to be adjusted ({ODBC Driver 13...}), or similar.

Can someone help me here?

Many thanks and best regards,

Ulrich

[TrevorS · Accepted solution]

Hello @ulrichfelgenhauer 

Please take a look at the below resources regarding connecting to the Azure SQL DB in Alteryx.
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Alteryx-to-Azure-SQL-Database/td-p/553...
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Connect-Alteryx-to-Sql-Server-Azure/td...
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Create-an-In-Database-Connec...

These should help to get you started.
If you are still having trouble, please upload a copy of your workflow so that the Community can see what you have attempted so far, but make sure you remove any sensitive information before sharing!

Thanks!
TrevorS

[ulrichfelgenhauer · Accepted solution]

Perfect, that helped a lot!!