Reading SAS Dataset into Oracle

1
votes

I have installed SAS Enterprise Guide 9.3 and SAS JDBC Drivers 9.3 and have some test SAS data sets that I need to load into Oracle. We have licenses for

ODBC SAS/ACCESS ODBC PCFILE SAS/ACCESS PC File Formats CONNECT SAS/CONNECT WKSPSRVLOCAL SAS Workspace Server for Local Access

I am using Windows 7. I am not sure about next steps

  1. Can I read SAS Datasets having just installed SAS EG?
  2. Which JAR files are required
  3. How will the connect string look like and what will be the port, username & password.

Appreciate any help I can get. Thanks

1
jdbcoracle11gsas

1 Answers

0
votes

Not an expert in this. If you can do this, you will need to connect through the local Workspace server. I've only connected through a server Workspace server to get a JDBC connection.

How I've done it in the past. Always possible this is not the best method.

Step 1. Connect to SAS workspace. http://support.sas.com/documentation/cdl/en/itechjcdg/61499/HTML/default/viewer.htm#connfact_direct.htm

Step 2. Use the DataService on the Workspace to get a JDBC connection to the current SAS session. http://support.sas.com/documentation/cdl/en/itechjcdg/61499/HTML/default/viewer.htm#jdbcconn.htm

Alternative: Connect through ODBC to Oracle in SAS and use SAS to write the tables into your Oracle DB. See the SAS/ACCESS documentation. http://support.sas.com/documentation/onlinedoc/access/index.html

Hope this helps!