BookmarkSubscribeRSS Feed
KeithCostigan
Calcite | Level 5

Good Afternoon

 

I'm trying to understand the difference between the generic SAS ACCESS/ODBC Engine and that or the Vendor specific ACCESS engine. In this case MySQL. Any guidance would be very much appreciated.

2 REPLIES 2
Kurt_Bremser
Super User

The ODBC ACCESS engine uses the standardized ODBC layer to connect to a database; this removes the necessity for SAS to know the specifics of the DBMS. On the machine in question, you only need the ODBC driver of the DBMS.

With ACCESS to Relational Databases for MySQL, you need the DBMS client installed and configured. But you have the luxury that SAS can make better use of DBMS-specific capabilities when doing implicit pass-through.

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 877 views
  • 1 like
  • 2 in conversation