Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Connect Alteryx to SQL Server Database

zz1237
5 - Atom

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.

111.PNG

 

Can anyone help me? Thank you.

 

Best,

 

Roger

2 REPLIES 2
Bob_Blackey
11 - Bolide

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
5 - Atom

Hi Bob,

 

Thank you for the reply.

 

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

 

Roger

Labels