topic Re: SAS Enterprise Guide 7.1 and Peoplesoft Tables in New SAS User

SAS Enterprise Guide 7.1 and Peoplesoft Tables

eer_seer — Tue, 05 Nov 2019 18:40:37 GMT

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.

Re: SAS Enterprise Guide 7.1 and Peoplesoft Tables

SASKiwi — Tue, 05 Nov 2019 18:57:04 GMT

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;

Re: SAS Enterprise Guide 7.1 and Peoplesoft Tables

eer_seer — Tue, 05 Nov 2019 19:19:38 GMT

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

Re: SAS Enterprise Guide 7.1 and Peoplesoft Tables

Reeza — Tue, 05 Nov 2019 19:32:13 GMT

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.

Re: SAS Enterprise Guide 7.1 and Peoplesoft Tables

eer_seer — Tue, 05 Nov 2019 19:33:15 GMT

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

Re: SAS Enterprise Guide 7.1 and Peoplesoft Tables

SASKiwi — Tue, 05 Nov 2019 21:09:17 GMT

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.

Re: SAS Enterprise Guide 7.1 and Peoplesoft Tables

Reeza — Tue, 05 Nov 2019 21:45:25 GMT

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