Oracle PeopleSoft + Nectar Integration

Connect Oracle PeopleSoft HCM to Nectar with a scheduled, secure file feed that keeps your employee directory current.

Overview

PeopleSoft HCM remains the system of record for many large employers, universities, and public-sector organizations. Nectar connects to it through a scheduled SFTP feed that your PeopleSoft team controls: a query exports the employee fields Nectar needs, and Nectar creates, updates, and deactivates users from that file. It fits enterprise change-control processes and keeps sensitive data limited to exactly what you choose to send.

Ideal for:

• Large enterprises, higher education, and public-sector organizations on PeopleSoft HCM
• HRIS and IT teams that require file-based, change-controlled integrations
• Organizations that want to share only a minimal set of fields
• Companies running recognition across many business units

How It Works

Nectar reads employee data from Oracle PeopleSoft and uses it to create, update, and deactivate Nectar accounts. Data flows one way, from Oracle PeopleSoft into Nectar, so Oracle PeopleSoft stays your single source of truth.

What data syncs

• First name, last name, and work email (required)
• Preferred name
• Employee ID (recommended as the unique identifier)
• Manager email
• Department and office location
• Hire date and birthday (month and day only; birth year is never processed)
• Phone number, country, and preferred language
• Active status
• Custom fields you add to the report, which become Custom Properties in Nectar

Every field has a job inside Nectar. Manager relationships assign manager roles and Team Insights automatically. Hire dates and birthdays drive work anniversary and birthday celebrations in Nectar Recognition. Departments and locations power analytics filters, Group Give, and audience targeting in Nectar Comms, Nectar Engage, and Nectar Flows. Hire dates and work anniversaries can also trigger Nectar Flows, and manager relationships assign reviewers in Nectar Perform and build the org view in Nectar Signals. Country keeps the rewards catalog relevant for each employee, and phone numbers enable SMS delivery in Nectar Comms.

Sync behavior

• Runs each time Oracle PeopleSoft delivers a new file; most teams schedule a daily delivery early on weekday mornings
• New rows create users, changes update existing profiles, and employees who no longer appear in the file are deactivated. If your report includes an active column, Nectar follows that status instead
• Matching on employee ID means an email change updates the existing account instead of creating a duplicate
• Fields you leave out of the report are never overwritten in Nectar

New users are created quietly by default. When you are ready to launch, turn on "Send Nectar platform email invitations to new users" so every future hire gets an invite automatically.

Authentication method

Files are delivered over SFTP to a destination unique to your Nectar account and authenticated with an SSH key pair. Oracle PeopleSoft keeps the private key, and you share only the public key with Nectar. Every file is encrypted in transit over SSH.

Where users interact

Admins connect, monitor, and pause the integration in Nectar under Workspace Settings, then Integrations. Employees never touch it: they just find an accurate profile, the right manager, and their teammates already in Nectar when they log in.

Key Features + Benefits

• Automatic provisioning: new hires in Oracle PeopleSoft get Nectar accounts without a manual upload
• Always-current profiles: title, department, manager, and location changes flow into Nectar
• Automated offboarding: terminated employees are deactivated, not deleted, so access ends and records stay intact
• You control the data: only the columns you include in the report are shared, and custom fields become Custom Properties in Nectar
• Celebrations on autopilot: birthdays and work anniversaries are recognized automatically from synced dates
• Controlled launch: accounts are created quietly, and invitations go out only when you turn them on
• Import monitoring: the Activity Console shows every import, and email alerts flag any file that fails

Setup and Implementation

Setting up the Oracle PeopleSoft integration follows four steps: Connect, Authorize, Map, and Enable. Your Nectar Customer Success Manager guides you through each one.

High-level setup steps

1. Connect: In Nectar, go to Workspace Settings, then Integrations, then HRIS SFTP Sync, and click Connect SFTP.
2. Authorize: Add your public SSH key and a notification email, then save to generate your unique hostname and username.
3. Map: Build a PS Query scheduled through Process Scheduler and delivered to an SFTP report node, using Nectar's template columns. First name, last name, and email are required; employee ID and manager email are strongly recommended.
4. Enable: Schedule the export to run daily, confirm the first import in Nectar's Activity Console, and turn on invitations when you are ready to launch.

Requirements

• A PeopleSoft resource who can build a PS Query and schedule it to an SFTP report node
• Outbound network access on TCP port 22
• Nectar admin access

Estimated setup time

Connecting in Nectar takes minutes. Building, testing, and scheduling the PeopleSoft export typically takes a few weeks, depending on your change-control process.

Your integration should never delay your launch. If the connection is not live yet, Nectar's Bulk Upload loads your employees from a spreadsheet so you can launch on schedule and switch to the automated sync when it is ready.

Detailed, step-by-step instructions are available in the Nectar Help Center.

Use Cases

• Provision employees across business units from one scheduled feed
• Share only the fields Nectar needs, keeping compensation and other sensitive data out
• Bring custom PeopleSoft fields such as business unit into Nectar for analytics
• Keep manager hierarchies accurate for large, layered organizations
• Deactivate employees automatically when they leave the feed

Security & Compliance

Nectar protects employee data at every step of the Oracle PeopleSoft connection.

• SFTP over SSH encrypts every file and credential in transit
• Each account has its own delivery destination, and files cannot be read by other customers
• OpenSSH key-pair authentication; your private key is never shared with Nectar
• Data is encrypted in transit
• Nectar only uses the profile fields listed above and never syncs compensation, bank details, or benefits elections
• Only Nectar admins can connect, pause, or remove the integration
• Birth year is never processed; Nectar uses month and day only
• Nectar maintains a SOC 2 Type II report, audited annually, with security documentation available in the Nectar Trust Center

Learn more on the Nectar Security page and in the Nectar Trust Center.

Support & Resources

• Nectar Help Center
• How to sync employee data with Nectar using SFTP
• How to monitor and manage your HRIS SFTP sync
• Bulk upload users (to launch before your sync is live)
• Nectar Trust Center
• Email Nectar Support at [email protected], or contact your Customer Success Manager