Connect SAS to SQL Server without using ODBC/OLEDB

[fishwhat]

Are there any ways to connect to the sql server directly without using ODBC/OLEDB? We did a DB migration to Azure recently. The speed is very slow if we connect DB through ODBC now. I do some research but not find a way to do the connection without using ODBC/OLEDB. I have both SAS and SAS Entertainment on my PC. 

Thanks.

Fisher

[SASKiwi]

What SAS/ACCESS product are you using? I understand that SAS/ACCESS Interface to SQL Server uses ODBC behind the scenes anyway, so I'm not aware of any other options. I suggest you open a SAS Tech Support track to investigate further. Are all SAS and SQL Server users experiencing the same performance or is it just you?

[fishwhat]

All users have the same issue. When we connect it to the new DB, the speed is slower. That's why I am thinking if we have an alternative way to avoid connecting ODBC. My Microsoft Studio and Power BI connect to the server directly and their speeds are perfect. Also, my new DB is on Azure.

[Tom]

---

@fishwhat wrote:

All users have the same issue. When we connect it to the new DB, the speed is slower. That's why I am thinking if we have an alternative way to avoid connecting ODBC. My Microsoft Studio and Power BI connect to the server directly and their speeds are perfect. Also, my new DB is on Azure.

---

Distance from the database can explain a lot of performance issues.  

Where is the computer where SAS is running?

Where is the old database running?
Where is the new database running?

If everything is in AZURE them make sure they are co-located.

[SASKiwi]

Try running a very simple row count query. That will tell you whether the slowness is in bringing your data back to SAS on your PC or not - I'm assuming here you aren't using a remote SAS server.