Scalable Performance Data Server

[Atabarezz]

Does Alteryx connect to;

• read from and
• write over SAS's Scalable Performance Data Server?

Best

[dataMack · Accepted solution]

According to this documentation on the SAS website, you should be able to setup a connection to a SPD with the SAS 9.4 ODBC Driver.  Since Alteryx can run through any ODBC driver on your machine, once you do the SAS specific setup in the SAS ODBC Driver Configuration dialog box, you should then be able to point your Alteryx Input connector at that.

Of course, as with all things about SAS it looks a bit outdated.  The latest entry on their 'News' section on their driver home page is from 2011 and talks about it not working with SPD, but that referenced version 9.3.  Their latest driver version is 9.4 and since they do reference it in the docs, I assume they fixed that.

Curious as to why you'd want to hook Alteryx up to it?  Trying to migrate some legacy data sets that are marooned in SAS?

[Atabarezz]

Thanks for the detailed answer Jason,

Exactly the idea is to be able to reach out current SAS server and data files...

Companies are afraid of moving form one old system to another altogether

And that's why they are asking if Alteryx can communicate with those legacy systems, read and write to them...

Best

[JessieC]

@Atabarezz Did you have any companies successfully connect SAS's Scalable Performance Data Server?

[Atabarezz]

Yes, we have managed to connect to the SPDS using an ODBC connection.

Make sure the relevant up to date drivers are installed on your machine as well as the Server.

Also the system admin should help you because there may be absurd errors on the SAS side (as usual)

Best