SAS Enterprise Guide 7.1 and Peoplesoft Tables

[eer_seer]

Friends,

For years, I was able to connect to BANNER tables using a simple statement as follows.

LIBNAME student odbc datasrc='studentprod-odbc' user='' password='' schema=student;

My new institution does not use BANNER.  They use peoplesoft. I cannot seem to find a similar way to connect SAS Enterprise Guide 7.1 to the peoplesoft tables for which I have read access.  There is also not a SAS server on campus, just a local connection.  Does that prohibit me from connecting? Can I connect to peoplesoft on campus using a local machine?  I can program relatively well in sas, i just don't understand the techie side of the connections so well.  What am I missing?

Any help would be appreciated.

[SASKiwi]

Peoplesoft is an HR application, it is not a database, so the question is what database is Peoplesoft implemented on at your work?. Are there any other SAS users who are connecting to the Peoplesoft database or are you the first to try? Others may be able to help you.

If you wish to use ODBC database connections from SAS then you must have SAS/ACCESS to ODBC both installed and licensed. Run PROC SETINIT and PROC PRODUCT_STATUS to check this:

proc product_status;
run;

proc setinit;
run;

[eer_seer]

To my knowledge, I'm the first to try. Thank you.  Here's what I think were the relevant results of the procedure:

For SAS/ACCESS Interface to ODBC ...
Custom version information: 9.4_M4
For SAS/ACCESS Interface to OLE DB ...
Custom version information: 9.4_M4
For SAS/ACCESS Interface to Teradata ...
Custom version information: 9.44
For SAS/ACCESS Interface to MySQL ...
Custom version information: 9.4_M4

---SAS/ACCESS Interface to DB2 31DEC2019
---SAS/ACCESS Interface to Oracle 31DEC2019
---SAS/ACCESS Interface to SAP ASE 31DEC2019
---SAS/ACCESS Interface to PC Files 31DEC2019
---SAS/ACCESS Interface to ODBC 31DEC2019
---SAS/ACCESS Interface to OLE DB 31DEC2019
---SAS/ACCESS Interface to Teradata 31DEC2019
---SAS/ACCESS Interface to Microsoft SQL Server 31DEC2019
---SAS/ACCESS Interface to MySQL

[SASKiwi]

OK, you have the SAS ODBC product installed and licensed. You now need an ODBC driver for the Peoplesoft database - again what database?. Check with your IT people regarding this. They should know what you need.

[Reeza]

How do you currently access the database? Do you have an ODBC connection or OLEDB connection set up? Check your settings in the windows ODBC in the control panel.

[eer_seer]

We currently access the tables using an older product called Hyperion which connects to .oce files?

[Reeza]

So you do have a connect, OCE is a connection file. You'll need to talk to your IT team.