Help using Base SAS procedures

Mysql connect to SAS

Accepted Solution Solved
Reply
Contributor
Posts: 50
Accepted Solution

Mysql connect to SAS

Hello Forum,

I need to connect mysql database to SAS.  I was wondering how it can be done? I appreciate any idea on syntax.

Thanks !!!


Accepted Solutions
Solution
‎01-06-2015 06:07 PM
Respected Advisor
Posts: 3,893

Re: Mysql connect to SAS

Not something I'm doing often - but I would say you need first the MySQL driver/connector installed MySQL :: Download Connector/ODBC

Installation must be on the machine where your SAS Server runs (and that's then also where you define the ODBC datasource).

View solution in original post


All Replies
Respected Advisor
Posts: 3,893

Re: Mysql connect to SAS

You need either SAS/Access to ODBC or SAS/Access to MySQL licensed, installed and configured.  SAS/ACCESS(R) 9.4 for Relational Databases: Reference, Sixth Edition What do you have?

There are code examples in the docu link posted above.

Contributor
Posts: 50

Re: Mysql connect to SAS

Hi Patrick,

We have SAS/ACCESS interface to ODBC. 

Thanks !!!

Contributor
Posts: 50

Re: Mysql connect to SAS

Hi Patrick,

In my computer, I can see only Oracle and SQL Server on ODBC data source (When I went to add).  How to connect to MySQL?

Thanks !!!

Super User
Super User
Posts: 6,500

Re: Mysql connect to SAS

I haven't used it myself, but there seems to be a nice MYSQL site with a driver for ODBC.

http://dev.mysql.com/downloads/connector/odbc/

Contributor
Posts: 50

Re: Mysql connect to SAS

Thanks, Patrick and Tom,

I realized I need to install ODBC Driver for MySql.

Solution
‎01-06-2015 06:07 PM
Respected Advisor
Posts: 3,893

Re: Mysql connect to SAS

Not something I'm doing often - but I would say you need first the MySQL driver/connector installed MySQL :: Download Connector/ODBC

Installation must be on the machine where your SAS Server runs (and that's then also where you define the ODBC datasource).

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 6 replies
  • 1020 views
  • 6 likes
  • 3 in conversation