02-21-2017 07:59 AM
We bought SAS/ACCESS for sql and for oracle on unix in order to read data from SQL and oracle databases..
However now we want to connect to a Poistgresql database. Is there a easy way of doing that via these without spending more money on SAS/access modules? we want to connect via out UNIX server from PC EG. Thanks in advance.
02-21-2017 08:05 AM
my best suggestion would be to change your SAS/ACCESS license to ODBC. THen you can connect to as many databases as they have ODBC drivers. Of course, this would have an impact on your library definitions and you won't have in-database process support, but if you don;t use in-database processes, you won;t lose much.
In any case, please bear in mind that these communities are mostly based on experiences, and most of us are not part of SAS, therefore question related to the licenses are better supported by the SAS team. I would strongly recommend you to contact SAS Technical Support or your account manager at SAS, they will be happy to support your question.
Hope it helps.
02-21-2017 01:37 PM - edited 02-21-2017 01:40 PM
I'm currently an admin juggling multiple SAS/ACCESS interfaces. Like JuanS_OCS said, you might want look into SAS/ACCESS for ODBC. Keep in mind that the driver manager for SAS/ACCESS ODBC can be different than the other SAS/ACCESS interfaces. For example, I know that SAS/ACCESS for Greenplum and MSSQL use a DataDirect driver manager. This required special configuration on our part and help from SAS to get these interfaces to work well with our ODBC connections. I don't know for sure what your "sql" and "oracle" use. Probably DataDirect too. Our SAS/ACCESS for ODBC used unixODBC for the driver manager, but now we have it configured to use DataDirect.
I do see that SAS offers a SAS/ACCESS interface for PostgreSQL. Might want to look into that. But, if you don't need to do in database stuff, then look at that ODBC interface like Juan said.
02-23-2017 11:51 AM
02-24-2017 12:28 AM
Thanks for the answers. It is a bit surprising that SAS not out-of-the-box reads postgresql as we have enablet APM
and as I know it reads information from an internal postgresql database ?
02-27-2017 08:45 AM
I don't know which products you have licensed. If SAS Web Infrastructure Platform is the only product using an instance of SAS Web Infrastructure Platform Data Server, as you describe, it may not come with SAS/ACCESS to PostgreSQL. I believe that product accesses its data via direct JDBC. I would have to check the packaging overview for any specific product to see if it comes with ACCESS to PostgreSQL The SAS Solutions that I've been working with do to support DBMS access using SAS Libraries. The SAS/ACCESSS license may have a usage restriction for use with that product only. Tech Support can probably help you interpret your licensing structure.