topic Re: Connect Alteryx to SQL Server Database in Alteryx Designer Desktop Discussions

Connect Alteryx to SQL Server Database

zz1237 — Wed, 08 Mar 2017 14:57:07 GMT

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

Re: Connect Alteryx to SQL Server Database

Bob_Blackey — Thu, 09 Mar 2017 22:32:29 GMT

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

Re: Connect Alteryx to SQL Server Database

zz1237 — Mon, 24 Apr 2017 18:55:01 GMT

Hi Bob,

Thank you for the reply.

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

Roger