ERP-Specific Connections
SAP S/4 HANA
Source System Prerequisites
Before creating a connection in JustPerform, configure the following in SAP S/4 HANA:
Step 1: Enable ODP Framework
Use Transaction SU01 to create RFC user
Use Transaction SICF to activate ODP services
Navigate to path: /sap/opu/odata/sap/
Verify ODP_EXTRACTION service is active
Step 2: Configure Operational Data Provisioning
Use Transaction RODPS_OS_EXPOSE to expose data sources for ODP
Select data sources to make available
Activate for operational data provisioning
Test using transaction RODPS_REPL_TEST
Step 3: Enable Delta for Data Sources
For delta extraction capability:
Check delta capability in RSA2 (for BW extractors)
For CDS views: Ensure @Analytics.dataExtraction.enabled: true
For tables: Enable change documents or use timestamp fields
Initialize delta queue using transaction ODQMON
Step 4: User Authorizations
RFC user must have the following authorization objects:
Authorization Object |
Description |
|---|---|
S_RFC |
Execute RFC functions |
S_TABU_DIS |
Table display authorization |
S_BTCH_JOB |
Background job scheduling |
S_ODPE |
ODP extraction authorization |
Recommended role template: SAP_BC_DWB_ABAPDEVELOPER (adjust as needed)
Connection Configuration in JustPerform
Connection Type: |
SAP Application |
|---|---|
Required Parameters |
yaml Application Server: [SAP system hostname/IP] System Number: [00-99] Instance Number: [instance_number] Router String: [Optional] Client: [3-digit client (e.g., 100)] Protocol: HTTP or HTTPS Authentication Type: Basic User: [RFC user created above] Password: [RFC user password] Path Variable: [specific path location for Service] Use OData: Enable Add Service Name Manually: Enable Service Name: [Enter Service Name] |
Optional Parameters |
yaml Connect Using JustPerform Agent: Enable/Disable Agent host: [hostname] Agent Port: [port] Agent User name: [username] Agent password: [password] |
Available Data Sources
After connection, the following data sources are available:
Data Source Type |
Description |
|---|---|
ODP_BW |
BW extractors (2LIS_, 0FI_, etc.) |
ODP_CDS |
CDS views marked for extraction |
ODP_SAPI |
DataSources via Service API |
ODP_HANA |
HANA views (if connected to HANA) |
Delta Configuration
Prerequisites for Delta
For Standard Extractors: Delta must be active in source system
-
For CDS Views: Use the following annotation:
abap
@Analytics.dataExtraction: {
enabled: true,
delta.changeDataCapture: {
automatic: true
}
}
For Tables: Timestamp field or change documents
Setting Up Delta in JustPerform
Create import rule with Delta mode
Select Load Type: Delta
Initialize delta on first run
Subsequent runs extract only changes
Monitoring Delta Extraction
SAP Transaction ODQMON: Monitor extraction queues
Check subscriber status
View data volume per extraction
Clean up old requests (retention typically 24 hours)
SAP SuccessFactors
Source System Prerequisites
-
Enable API Access
Log in to SuccessFactors as Administrator
Navigate to Admin Center → Company Settings
Enable OData API Access
Configure API call limits if needed
Create Integration User
Navigate to Admin Center → Manage Users
Create dedicated integration user
-
Assign appropriate role-based permissions:
Employee Central API
Reports Permission
Metadata Framework
Required module permissions
-
Configure OAuth Application
For OAuth 2.0 authentication:
Navigate to Admin Center → Manage OAuth2 Client Applications
Register new application
Generate X.509 certificate
Upload certificate and note the API key
Configure SAML assertion settings
-
Set Up Permissions
Integration user must have:
View permissions for required entities
Export permissions for data
Access to compound employee API (for delta)
Metadata API access
Connection Configuration in JustPerform
Connection Type: |
SAP SuccessFactors |
|---|---|
Required Parameters |
yaml IDP: https://[tenant_id]/odata/v2 Authentication Type: saml2-Bearer IDP URL: https://[tenant_id]/oauth Parameters: client_id: [client_id] user_id: [user_id] token_url: [token_url] private_key: [private_key] company_id: [company_id] grant_type: [grant_type] |
Setting Up Delta in JustPerform
Create import rule with Delta mode
Select timestamp field (usually lastModifiedDateTime)
System maintains watermark automatically
Configure appropriate time windows
Microsoft Dynamics 365
Source System Prerequisites
Step 1: Setup Azure AD Application
In Azure Portal:
Navigate to Azure Active Directory → App registrations
Create New registration with name "JustPerform_Integration"
Note the Application (client) ID
Create client secret and save value
-
Set API permissions:
Dynamics CRM → user_impersonation
Grant admin consent
Step 2: Create Application User in Dynamics 365
Navigate to Settings → Security → Users
Switch view to Application Users
Click New → Application User
-
Configure:
Application ID: From Azure AD
Full Name: JustPerform Integration
Primary Email: integration@company.com
Step 3: Assign Security Role
Create custom security role or copy existing
-
Configure the following required privileges:
Privilege Type
Access Level
Organization
Read
Business Management
Read all settings
Core Records
Read access
Custom Entities
Read access
Security Depth
Organization level
Step 4: Enable Change Tracking (For Delta)
Navigate to Settings → Administration → System Settings
Enable audit logs
-
For specific entities:
Navigate to Settings → Customizations → Entities
Select entity → Enable Change Tracking
Publish customizations
Step 5: Configure API Access
Verify OData endpoint is accessible
Check API limits are appropriate
Configure IP restrictions if needed
Connection Configuration in JustPerform
Connection Type: |
API-Based (OData) |
|---|---|
Required Parameters |
Yaml OData URL: https://api.businesscentral.dynamics.com/v2.0/TenantId Authentication Type: OAuth Credentials Type: Client Credential OAuth URL: https://login.microsoftonline.com/TenantId/oauth2/v2.0/token Client ID: [client_id] Client Secret: [client_secret] Scope: https://login.microsoftonline.com Resource: [Optional] Parameters: Company: [company_value] |
Infor LN (Custom API)
Connection Configuration in JustPerform
Connection Type: |
INFOR-LN ERP |
|---|---|
Required Parameters |
yaml EndPoint URL: https://aws.com/api Authentication Type: OAuth Credentials Type: Basic Auth OAuth URL: https://aws.com/auth User ID: [username] Password: [password] Token Field Response Name: GetDataResponse |
Delta Configuration
Prerequisites for Delta
Identify the following timestamp columns:
Timestamp Column |
Purpose |
|---|---|
modified_date |
Last modification timestamp |
audit_date |
Audit trail timestamp |
last_update |
Last update timestamp |
NetSuite
Source System Prerequisites
Before creating a connection in JustPerform, configure the following in NetSuite:
Step 1: Enable SuiteCloud Features
Navigate to Administrator → Setup → Company → Enable Features
Select SuiteCloud tab
Enable Web Services and REST Web Services
Enable Token-Based Authentication for secure access
Activate SuiteAnalytics Workbook for reporting capabilities
Step 2: Create Integration User
Navigate to Setup → Users/Roles → Manage Users
Create a dedicated integration user with appropriate permissions
-
Assign role with the following permissions:
Permission Type
Access Level
Web Services
Full access
Lists
View and Edit access for required record types
Transactions
View access for required transaction types
Reports
View access for custom reports and saved searches
Step 3: Configure Token-Based Authentication
Navigate to Setup → Users/Roles → Access Tokens
Create new access token for the integration user
Note the Token ID and Token Secret (one-time display)
Configure token permissions and restrictions
Step 4: Set Up Custom Records and Fields (Optional)
Create custom fields for change tracking if delta extraction is required
Set up saved searches for data extraction
Configure custom records for additional data points
Connection Configuration in JustPerform
Connection Type: |
NetSuite Analytics (JDBC) |
|---|---|
Required Parameters |
Yaml Host: [NetSuite Analytics server hostname] Port Number: 1708 (default NetSuite Analytics port) Authentication Type: Basic Auth Data Source: [NetSuite database identifier] Role: [NetSuite role ID for integration user] Account: [NetSuite account ID (e.g., ACME_SB1 for sandbox)] Username: [NetSuite integration user login] Password: [Integration user password] |
Optional Parameters |
Yaml Connect Using JustPerform Agent: Enable for on-premises connectivity Agent Host: [JustPerform Gateway Agent hostname] Agent Port: [Gateway Agent port number] Agent Username: [Agent authentication username] Agent Password: [Agent authentication password] |
Delta Configuration
Prerequisites for Delta
NetSuite provides standard audit fields:
Audit Field |
Description |
|---|---|
date_created |
Record creation timestamp |
date_last_modified |
Last modification timestamp |
last_modified_by |
User who last modified the record |
Setting Up Delta in JustPerform
To create Import Rule with Delta Mode
Select extraction mode: Delta
Choose timestamp field: date_last_modified
Configure initial load strategy
Set delta extraction window (e.g., last 24 hours)
SAP BPC (Business Planning and Consolidation)
Source System Prerequisites
Before creating a connection in JustPerform, configure the following in SAP BPC:
Create a Gateway service to consume data from API and update into BPC Cube
Activate the Service
Connection Configuration in JustPerform
Connection Type: |
SAP BPC API |
|---|---|
Required Parameters |
yaml URL: https://[Application_server]/sap/opu/odata/sap/[Service] Authentication Type: Basic Auth User ID: [username] Password: [password] |
SAP SAC (Analytics Cloud)
Connection Configuration in JustPerform
Connection Type: |
SAP Analytics Cloud |
|---|---|
Required Parameters |
yaml OData URL: [service_url] Authentication Type: OAuth Credentials Type: Client Credential OAuth URL: [oauth_endpoint] Client ID: [client_id] Client Secret: [client_secret] Scope: [scope] |