Alteryx designer Discussions

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

Performance Input DB vs SSMS

Highlighted
6 - Meteoroid

Hi,

 

Is it common to experience a big difference in run time between running an SQL query via Alteryx In DB and SSMS?

That Alteryx is taking much longer to execute it.

 

Thanks!

 

/T

Highlighted
Alteryx
Alteryx

Hi @Tjabo

 

There shouldn't be a huge difference between the two, there may well be some.

 

What driver are you using in Alteryx to connect to SQL?

Highlighted
6 - Meteoroid

Thanks for your quick answer JoeS.

 

ODBC Data Sources (64-bit)

 

Is this an answer to your question? 

 

 

/T

Highlighted
Alteryx
Alteryx

When you create an ODBC connection, you get the option to chose a driver.

 

If you go through these stages:

 

Step 1:

Step1.png

 

Step 2:

Step2.png

 

Step 3:

Step3.png

 

Step 4:

Step4.png

 

 

What options do you see in Step 4?

 

If you do have a native one, I'd recommend choosing that.

Highlighted
6 - Meteoroid

Hi @JoeS,

 

Thanks for your reply.
And sorry for the delayed response.

 

I did as you described.
However, once I test the connection I get the error that Windows logins are not supported in this version of SQL Server.

Do you think this is correct error or have I done something wrong?

And what other options do I have?

 

Br,

Max

Highlighted
Alteryx
Alteryx

Hi Max,

 

That looks like it's a setting within your SQL server.

 

Do you have a DBA or IT person you can work with to get access to the server? (Unfortunately there could be a fair few different options to go through that may take some back and forth on here)

Labels