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
Solved! Go to 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
Hi Bob,
Thank you for the reply.
It is indeed easier to use the tool to connect to the database. Thank you.
Roger