For available SAS/ACCESS features, see Microsoft SQL Server supported features. For more information about Microsoft SQL Server, see your Microsoft SQL Server documentation.
In SAS 9.4M4, support that enables you to connect to row-based Microsoft Azure SQL database tables was added. As a best practice, set the EnableScrollableCursors ODBC driver option to 3.
SAS/ACCESS Interface to Microsoft SQL Server has been tested and certified against Data Direct Technologies Connect ODBC and Data Direct SequeLink ODBC products.
SAS/ACCESS Interface to Microsoft SQL Server includes SAS Data Connector to Microsoft SQL Server. The data connector enables you to load large amounts of data into the CAS server for parallel processing. For more information, see these sections: