community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Connect Alteryx to SQL Server Database

Alteryx Certified Partner

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

Alteryx Partner

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

 

Alteryx Certified Partner

Hi Bob,

 

Thank you for the reply.

 

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

 

Roger

Labels