05-10-2011 01:45 AM
02-03-2015 06:51 AM
SAS/ACCESS to ODBC means that you SAS installation can access data stored in ODBC compliant software, such as MS SQL Server, ORACLE, and any other RDBMS that support ODBC connections.
Accessing SAS tables via ODBC is completely different. You'll need
- Software licenses for either SAS/SHARE or SAS Scalable Performance Data Server (SPDS), or SAS Integration Technology
- A running server instance (SAS/SHARE, SPDS, Metadata Server/Object Spawner)
- The Corresponding SAS ODBC drivers installed on the Windows machine desired to access the SAS tables
Hope this helps,
02-03-2015 07:49 AM
Sorry I got confused by the various posts. Here is what I was trying to do. I have university edition of SAS and I also have data in MYSQL database. I was trying to get at my data from SAS. Now I know that ACCESS to ODBC is not on the product list of the university edition but I did a proc setinit and it clearly showed that ACCESS to ODBC is installed. I was wondering if there is a way to set up SAS to access my data on MYSQL. Any help you can provide would be much appreciated.
02-03-2015 08:10 AM
The way I understand it, SAS University Edition runs in its own virtual (Linux) machine, which is "completely" isolated from your Windows (I'm guessing) machine, and the only link between them is how you setup the SAS Shared Folder, based on the installation instructions.
With that said, I don't know of a way, whereby you can modify the pre-installed SAS software, nor the Virtual Linux Environment variables, in order to configure the SAS/ACCESS product.
By the Way, you'll need SAS/ACCESS to MySQL and NOT SAS/ACCESS to ODBC!! Having SAS/ACCESS to ODBC listed in the proc setinit listing/output, does not mean it is installed!
02-03-2015 08:47 AM
Thanks Ahmed. A SAS technical sales person told be that ACCESS to ODBC should get me connected to MYSQL in a normal installation. It might be a bit slower but theoretically it should work.
02-03-2015 09:44 AM
But, you do not have a "normal" installation. You have an isolated installation. SAS University Edition runs in a Virtual Machine that does not really ever see the files on your C: drive. It only sees the files that you define to Virtual Box or VMware Player as shared. As explained by Ahmed, you cannot get to the Virtual Machine to make any configuration changes, so the chances are good that you will not be able to read your MySQL database directly with the University Edition. This is a question for Tech Support when they understand your whole configuration and how you are running SAS -- whether what you want to do will work specifically when you are using the SAS University Edition.