Connect Alteryx to SQL Server Database

[zz1237]

Hi everyone,

I want to connect Alteryx10.6 to SQL Server 2016 database. I have tried to conenct through input-data tool, but could not find the option of "New Microsoft SQL Server Bulk Connection". Then, I tried to connect through Connect-in-DB, but error message kept poping up.  Here is the pic of error message.

Can anyone help me? Thank you.

Best,

Roger

[Bob_Blackey · Accepted solution]

Hi Roger,

Here's a link to a page on connecting to SQL server. Unless you are familiar with and need the InDB functionality I would go with the Input Data tool. (Not that In-DB is difficult)

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Connecting-to-an-ODBC-Datasource/ta-p/17590

Hope that helps, please reply if you need any additional assistance.

Cheers,

Bob

[zz1237]

Hi Bob,

Thank you for the reply.

It is indeed easier to use the tool to connect to the database. Thank you.

Roger