Upcoming Connectors - Additional Enterprise ERPs
Oracle Fusion
Source System Prerequisites
Create Integration user with integration role
Configure REST API access and verify endpoints
Enable BI Publisher for reports and large datasets
Set up authentication (Basic, OAuth 2.0, or JWT)
Connection Configuration
|
yaml Type: API-Based (REST) Instance URL: https://[instance].oraclecloud.com Auth: Basic, OAuth 2.0, or JWT Token Version: Latest stable API version |
Delta Support
LastUpdateDate, CreationDate, LastModifiedDate fields
Audit history with configurable policies
BI Publisher for large incremental extracts
REST API with date range parameters
Workday
Source System Prerequisites
Create Integration System User (ISU)
Configure security groups and permissions
Enable required Web Services
Generate OAuth 2.0 client credentials
Connection Configuration
|
Yaml Type: API-Based Auth: OAuth 2.0 Client Credentials Endpoints: REST API or Reports-as-a-Service Token Validity: 1 hour |
Delta Support
Use transaction log for changes
WQL (Workday Query Language) with date filters
Effective dating for time-based data
JD Edwards
Source System Prerequisites
Configure AIS Server
Create service account
Enable REST services or JDBC access
Set up orchestrations (if needed)
Connection Configuration
|
yaml Option 1: REST API via AIS Server Option 2: Direct database (JDBC) Auth: Basic or token-based |
Delta Support
Audit fields (UPMJ, UPMT)
F0011 table for batch updates
Custom views with timestamps
PeopleSoft
Source System Prerequisites
Configure Integration Broker
Set up Component Interfaces
Create service operations
Enable REST services
Connection Configuration
|
yaml Type: API-Based Protocol: REST or SOAP Auth: Basic over HTTPS |
Delta Support
LASTUPDDTTM field
Audit records
Incremental publish via Integration Broker
Epicor
Source System Prerequisites
Enable REST API
Create API key
Configure user permissions
Set up custom BAQs (Business Activity Queries)
Connection Configuration
|
yaml Option 1: REST API via AIS Server Option 2: Direct database (JDBC) Auth: Basic or token-based |
Delta Support
SysRevID for change tracking
Modified date fields
Change logs via BAQs
IFS
Source System Prerequisites
Enable OData provider
Configure projections
Set up API permissions
Create integration user
Connection Configuration
|
yaml Type: API-Based (OData) Auth: OAuth 2.0 Format: JSON |
Delta Support
Modified date attributes
Rowversion for optimistic locking
Custom change tracking projections