Prev: proc glm
Next: Free Project Management Software
From: arun on 4 Jun 2010 19:04
Can anyone please help as I am trying to connect the SAS to MYSQL
database which in other domain. The flow goes like this.

SAS will generate the output file in production and then manually we
are pushing this output file into MYSQL which is in corp domain. So we
want to connect to the MYSQL database directly from sas and dump the
output file in MY SQL.Can we connect in that way without SAS Connect
using SAS Access.

Please help
From: Patrick on 4 Jun 2010 21:48
Hi Arun

SAS\Connect is used to connect to SAS\Servers, SAS\Access modules are
used to connect a SAS Server with a Database (or MS Office files).

You should be fine with an appropriate SAS\Access module, i.e: (http://
support.sas.com/documentation/onlinedoc/91pdf/sasdoc_912/
access_mysql_8139.pdf)

If you have a scheduler then the process could also be automated (the
scheduler just waits until one of your text files is delivered into a
dropping area and then starts a SAS process which loads this file).

If the MySQL server is accessible from the Prod domain then the SAS
process reading the source could also directly load the data without
first creating text files.

And even if an intermediary step is needed: As SAS is used for
creating the output as well as the input using SAS tables might be
easier.

If you have anyway to create text files: Instead of using SAS to load
the data into MySQL there would also be the alternative to use a MySQL
loader (http://dev.mysql.com/doc/refman/5.1/en/load-data.html).

HTH
Patrick
From: arun on 5 Jun 2010 13:33
On Jun 4, 6:48 pm, Patrick <patrick.mat...(a)gmx.ch> wrote:
> Hi Arun
>
> SAS\Connect is used to connect to SAS\Servers, SAS\Access modules are
> used to connect a SAS Server with a Database (or MS Office files).
>
> You should be fine with an appropriate SAS\Access module, i.e: (http://
> support.sas.com/documentation/onlinedoc/91pdf/sasdoc_912/
> access_mysql_8139.pdf)
>
> If you have a scheduler then the process could also be automated (the
> scheduler just waits until one of your text files is delivered into a
> dropping area and then starts a SAS process which loads this file).
>
> If the MySQL server is accessible from the Prod domain then the SAS
> process reading the source could also directly load the data without
> first creating text files.
>
> And even if an intermediary step is needed: As SAS is used for
> creating the output as well as the input using SAS tables might be
> easier.
>
> If you have anyway to create text files: Instead of using SAS to load
> the data into MySQL there would also be the alternative to use a MySQL
> loader (http://dev.mysql.com/doc/refman/5.1/en/load-data.html).
>
> HTH
> Patrick

Thanks for your response Patrick but my main concern was if we can
connect sas to the MYSQL database which are in totally different
domains - SAS (prod) and MYSQL (Corp). Can you please respond if
there is a possbility that we can connect sas to database of different
domain.
From: Patrick on 5 Jun 2010 23:08
Hi Arun
The general answer to your question is: Yes, of course, you can
connect to a Server (ie. a DBMS) in a different domain.
If it will be possible in your environment will depend on how the
network infrastructure and security is set-up. It has nothing to do
with SAS as such.
A company with high security needs might not allow to connect the PROD
domain to any other domain.
I assume you're able to connect to both domains from your PC (which
sits in only one domain).You could run a test using your user and pw
for the MySQL DB (in the libname connection options part).
You will also need a mySQL client installed on the server where SAS
runs.
HTH
Patrick

From: Patrick on 7 Jun 2010 09:12
Hi Arun

The message you get looks to me as if the MySQL server is not known.
Why it is not known could have several reasons.

You didn't post any information like username or servername - which I
believe was a wise decision. "Problem" is: To see the full syntax
(except the password) is necessary in order to be sure that you pass
the parameters correctly.

I would suggest that you contact our friends from SAS Tech Support and
get their help. Send them as much information and logs as you can.

HTH
Patrick
 | 
Pages: 1
Prev: proc glm
Next: Free Project Management Software