ml-connector
Oracle E-Business SuitePipedrive

Oracle E-Business Suite and Pipedrive integration

Oracle E-Business Suite runs your finance, procurement, and supply chain. Pipedrive runs your CRM and sales pipeline. Connecting the two keeps your customer and vendor master data synchronized across both systems. New customers and vendors created in EBS appear as organizations and persons in Pipedrive so your sales team always has the latest reference data. ml-connector handles the on-premises EBS infrastructure, manages both credential sets encrypted, and ensures no record is lost or duplicated.

How Oracle E-Business Suite works

Oracle E-Business Suite (R12.2) exposes customers, vendors, vendor sites, purchase orders, invoices, and GL accounts through REST and SOAP web services deployed via the Integrated SOA Gateway (ISG). Each customer hosts the ISG at their own hostname and port, and authentication uses HTTP Basic Auth (username and password) or a session token obtained via login endpoint. The platform requires application context headers such as ctx_responsibility and ctx_orgid to route requests to the correct module. Oracle E-Business Suite has no modern webhooks, so master data is read by scheduled polling of change-tracked open interface views filtered by LAST_UPDATE_DATE with limit and offset pagination.

How Pipedrive works

Pipedrive exposes organizations (companies), persons (contacts), deals, activities, and related CRM objects through a REST API available at api.pipedrive.com. Authentication uses either API Token (scoped to the user account) or OAuth2 bearer token with refresh capability. Custom fields are exposed as opaque hashes and must be retrieved separately from field definition endpoints. Pipedrive uses a daily API token budget based on plan (30,000 base tokens multiplied by plan multiplier and seat count), with burst rate limits of 20 to 120 requests per 2-second window depending on authentication type. Webhook support is available for push notifications but requires a valid TLS certificate.

What moves between them

Customer and vendor master records flow from Oracle E-Business Suite into Pipedrive. Customers and vendor companies in EBS become organizations in Pipedrive, while vendor contacts and key customer contacts become persons. Updates to customer names, tax IDs, addresses, and credit limits in EBS flow into matching Pipedrive organization fields on a scheduled polling cadence. Vendor sites in EBS map to custom fields in Pipedrive organizations so purchasing teams have the complete vendor site information available alongside deal and activity records. The flow is one-way read from EBS to Pipedrive, since EBS is the system of record and Pipedrive is a CRM consumer with no equivalent master data write capability.

How ml-connector handles it

ml-connector accepts the customer's EBS hostname and port, stores HTTP Basic Auth credentials encrypted, and handles the required application context headers (ctx_responsibility, ctx_respapplication, ctx_securitygroup, ctx_nlslanguage, ctx_orgid) on every request. It polls the EBS ISG REST endpoints on a schedule you define, retrieving customers and vendors filtered by LAST_UPDATE_DATE to catch only recent changes. For Pipedrive it stores an OAuth2 token and refreshes it when rate limits or token expiry require re-authentication. Customer and vendor records are normalized to Pipedrive organization and person format, mapped to matching custom fields, and written via the Pipedrive v2 API. If a Pipedrive write fails due to rate limits or a temporary outage, ml-connector retries with exponential backoff and tracks the record state in the audit log so no customer is ever lost. EBS session tokens expire after 30 to 60 minutes, so ml-connector obtains a fresh token on each polling cycle. API token usage is tracked and logged so you can monitor Pipedrive daily budget consumption and adjust sync frequency if needed.

A real-world example

A mid-market manufacturing and distribution company runs Oracle E-Business Suite for order-to-cash and procurement, and uses Pipedrive as its CRM for sales opportunities and customer relationship tracking. Before the integration, the sales team manually copied customer records from EBS into Pipedrive when onboarding a new account, and maintenance teams had to chase sync errors when a customer name or payment term changed. With EBS and Pipedrive connected, every customer created in EBS flows automatically into Pipedrive overnight, and updates to customer records reach the CRM within hours. The sales team always sees the current customer status, credit limit, and shipping address without leaving Pipedrive, and the finance team avoids duplicate customer creation and reconciliation errors.

What you can do

  • Sync customers and vendor companies from Oracle E-Business Suite to Pipedrive organizations on a schedule you control.
  • Map vendor and customer contacts from EBS to Pipedrive persons so your sales team has complete contact records.
  • Bridge Oracle E-Business Suite HTTP Basic Auth and session tokens with Pipedrive OAuth2, managing credential refresh automatically.
  • Handle EBS's on-premises ISG infrastructure by accepting your customer-specific hostname and port for each instance.
  • Track every customer and vendor record in the audit log and replay failed syncs until they land in Pipedrive.

Questions

Can data flow back from Pipedrive into Oracle E-Business Suite?
No. Oracle E-Business Suite is the system of record for customer and vendor master data. ml-connector syncs one way from EBS to Pipedrive so your CRM always has current reference data without risking conflicting changes. Any customer or vendor updates should be made in EBS and will automatically reach Pipedrive on the next sync cycle.
How does ml-connector handle Oracle E-Business Suite's on-premises ISG and session token expiry?
ml-connector stores the customer-specific EBS hostname and port you provide, along with HTTP Basic Auth credentials encrypted. Before each polling cycle it obtains a fresh session token from the EBS login endpoint, and handles the required application context headers (ctx_responsibility, ctx_respapplication, etc.) on every request. If a session token expires between requests, ml-connector re-authenticates automatically on the next call.
What happens if a sync fails due to Pipedrive rate limits or network problems?
ml-connector stores the customer or vendor record in the audit log, backs off exponentially, and retries until the write succeeds. The retry queue is persistent so no customer is ever lost if Pipedrive is briefly unavailable or if you hit your daily API token budget. You can review the audit log to see exactly which records were affected and when they were successfully synced.

Related integrations

Connect Oracle E-Business Suite and Pipedrive

Free to use. Add your credentials, ping your real systems, and see if we fit.

Get started