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

Data Extract much slower in Alteryx vs. MS SQL Server 2017

Meteoroid

Hello, 

 

I have a fairly large data set (2 million records with 24 columns) and in SQL Server it takes around 4 minutes to extract, but in Alteryx it takes around eight hours.  

 

In Alteryx use an ODBC connection.  I'm not sure what the connection is in SQL server but the login screen looks like the attached screen shot.  I have confirmed that the two login strings are exactly the same.  Any ideas?  

 

Alteryx
Alteryx

@mikeyd1276 Try using OleDB driver or the In-db tools. 

Highlighted
Asteroid

How are you doing this in Alteryx? What do you mean by extracting? 

Labels