Salesforce, Python, SQL, & other ways to put your data where you need it

Need event music? 🎸

Live and recorded jazz, pop, and meditative music for your virtual conference / Zoom wedding / yoga class / private party with quality sound and a smooth technical experience

Can eProcurement reach Banner?

13 Aug 2022 🔖 databases integration
💬 EN

Table of Contents

Accountants never work directly with servers running Ellucian’s Integration for eProcurement (IFEP) “middleware” software (syncing Ellucian Banner with Jaggaer a.k.a. SciQuest), but engineers do.

Here are tricks engineers can try to ensure that communications are running smoothly from the eProcurement middleware to the Jaggaer spending management tool.


eProc web config panel

Connections tab

Under eProc Connection, under Sync Message to Vendor, click “HTTP URL

Is the Hostname, Port, Server Path, Protocol Adapter, Username, and Password what Jaggaer Support (or a Jaggaer admin from your accountancy team) told you should be there?

Be careful if you have a password management tool like LastPass set up and doing autofill – if your eProcurement web portal is hosted at your university’s .edu domain, you might see your own e-mail username autofilled here, rather than the actual value.

Turn off your password manager before entering this page, because not only will they fake you out about what data you’re reading, but they’re a great way to accidentally overwrite the correct username and password if you click Save while trying to tidy up a field like Hostname.

An accountant with administrative access to Jaggaer can look in Jaggaer under Setup -> General Site Settings -> Document Export Settings. Next to the dashboard tab in the connection mgt tab, they can click through the various links listed under a box labeled Connections until they find one where, at right under Selected Connection, has the “Supports Banner” checkbox checked. The Identity in Jaggaer should match the Username in eProcurement, and the Shared Secret in Jaggaer should match the Username in eProcurement. (TODO: IS THIS CORRECT?)

If things don’t match, don’t have an accountant or an engineer touch anything in eProcurement or Jaggaer just yet.

Instead, schedule a screenshare-enabled conference call with Jaggaer Support, Ellucian’s Action Line, your eProcurement sysadmin, and one of your accountants serving as a Jaggaer administrator, and work through the troubleshooting live.

Take notes about what exactly was wrong and what exactly got fixed, for future reference.

Be careful about recording the screenshare, as there will be passwords visible during part of your configuration exploration and modification.

You won’t find the value that should be in Hostname in Jaggaer’s administration panel, so you’ll have to open a ticket with Jaggaer Support to get that value. Note that if you’re working in a test environment and you recently copied data from your production Banner database into your test Banner database, the value of Hostname in your test eProcurement system could be showing Jaggaer-production’s domain name instead of Jaggaer-test’s domain name, and you’ll need to fix it (hopefully you took good notes when you set up eProcurement-test; if not, contact Jaggaer Support for the correct Jaggaer-test hostname).


Posts In This Series

--- ---