Other industries

Oracle Integration Cloud recipes

Key achievements

Enterprise integration Digital transformationAutomationIntegration recipesAPI-led connectivity
featuring_image

“I’ve worked with many offshore teams, but none of them were as responsible as you.”

Praveen Morusupalli, Engineering Director - OIC

Client

company_logo

Oracle is one of the world's largest enterprise software and cloud companies, offering databases, cloud infrastructure and business applications for ERP, CRM, HCM and project delivery. Hotovo was an Oracle integration partner for 8 years, building Oracle Integration Cloud (OIC) integrations that link Oracle and non-Oracle systems.

Oracle case study project Integration recipes for efficiency
Oracle case study project Integration recipes for efficiency
Oracle case study project Integration recipes for efficiency
Oracle case study project Integration recipes for efficiency
Oracle case study project Integration recipes for efficiency

Case study

The need

Oracle needed ready-to-use integrations that enterprise customers could activate fast, often for go-live dates only weeks away.

Most enterprises run a mix of SaaS applications, and one business process often spans several of them. Typical examples are a CRM linked to an ERP, an e-commerce store feeding back-office operations, or separate tools for engineering, scheduling, project controls and documents. Each system has its own API style, data model and authentication, so building every integration from scratch is slow and expensive.

When Hotovo joined, Oracle already had its own integration platform, but it still had rough edges. Oracle was looking for a partner to:

  1. improve the platform through hands-on use and feedback
  2. build reusable integrations that cover end-to-end business processes
  3. provide rigorous testing of the created solutions
  4. work closely with Oracle's international product and development teams

Our solution

Hotovo built a portfolio of Oracle Integration Cloud recipes, accelerators and dedicated adapters. Customers activate them with minimal configuration instead of building integrations from scratch. The work grew in two phases: business application integrations first, then complex project and asset delivery.

Phase 1: platform feedback and Oracle Marketplace integrations

We started by using Oracle's integration platform every day and reporting bugs, improvements and usability ideas. Next, we built sample integrations for Oracle Marketplace. Then we moved on to ready-to-use solutions for end-to-end business processes:

  1. CRM to ERP: one process connecting Salesforce and Oracle NetSuite, with visibility into prospects, purchases, invoices, payments and other financial activity.
  2. E-commerce to ERP: a pre-built order-to-cash integration. It syncs customers, products, orders, fulfillments, invoices and payments, so online stores can hand back-office work to the ERP and focus on their customers.
  3. Customer service visibility: back-office data such as sales orders, support cases, time tracking and financials, shown directly in the support tool so agents resolve requests faster.

Our scope in this phase included:

  1. Implementation of new OIC integrations between Oracle and non-Oracle systems
  2. custom code that extends individual integrations
  3. converting legacy integrations to new standards
  4. setting up environments for integration with OIC
  5. creation of test data on both ends of each created integration
  6. testing new and updated integrations
  7. technical documentation and user manuals
  8. publishing recipes to Oracle Marketplace

We covered point-to-point, ETL, iSaaS and enterprise application integration, using migration and bi-directional synchronization patterns.

Phase 2: integration recipes for project delivery

An OIC recipe is a pre-built integration with ready-made business flows, field mappings, error handling and configurable parameters. For project and asset delivery, our recipes:

  1. Turn product deliverables into project activities. Approved deliverables and design items move from Oracle Fusion PLM into Oracle Primavera Cloud as structured work packages, with no manual re-entry.
  2. Connect agile delivery with project controls. Epics, phases and milestones from agile tools sync with activities in project management tools, and progress flows back into project and portfolio views.
  3. Make document transfers controlled and auditable. Documents move between Oracle Aconex and other project environments without re-uploads or outdated versions.

Project delivery accelerators

An accelerator is a larger, end-to-end bundle of integrations. Ours keep schedules, resources, costs and master data in sync between planning tools and project controls platforms: Oracle P6 EPPM, Oracle Primavera Cloud and Oracle Primavera Unifier. A second accelerator helps enterprises on legacy scheduling platforms move to harmonized activity sheets and progress tracking.

With the Oracle Primavera Unifier product team, we also added a one-click sync button inside Unifier. After a one-time setup, users sync project and schedule data without opening OIC.

Oracle Aconex adapter for OIC

An OIC adapter is a pre-built connector that hides a system's authentication, payload formats and endpoints. Integrators pick a module and an operation, and the adapter generates the technical setup.

We built and published a dedicated OIC adapter for Oracle Aconex, Oracle's construction collaboration platform. Aconex uses different JSON and XML APIs across its modules and has no central schema. Our adapter:

  1. guides users through choosing a module and an operation, then builds the request and handles the response
  2. normalizes the inconsistent APIs through one shared foundation layer
  3. handles documents, metadata and file uploads automatically, picking the right upload method for small and large files

Customers can now connect Aconex to their processes in a few clicks, without deep API knowledge or custom code.

How we solved the main challenges

  1. Tight go-live dates. We put reusable patterns first, ran joint design and validation sessions with Oracle, and delivered on time. One customer was starting a large construction project in the Amazon rainforest, where mobilization had to fit a narrow natural window. A delay could have pushed the start back by up to a year. We adapted our schedule sync accelerator to the customer's setup and worked directly with their development and QA teams, and the project started on schedule.
  2. Complex data mappings. We used JavaScript inside OIC for custom logic and advanced XSLT for transformations the graphical mapper can't handle, including XPath expressions, user-defined functions, grouping and aggregation. Everything stays aligned with OIC best practices.
  3. Fragmented external APIs. We packed each system's authentication, payloads and file handling into adapters and flows, so other teams integrate through simple, consistent interfaces.
  4. Rigorous testing. A solid integration has all edge cases covered. We created realistic test data on every platform that was integrated - from Salesforce, NetSuite to Oracle Primavera.

Key results

Hotovo's OIC recipes, accelerators and adapters cut integration build time for Oracle customers from weeks to hours or days.

  1. Reusable patterns: customers reuse proven integrations across regions and business units instead of starting from zero.
  2. Fewer manual steps and errors: automated flows replace manual handoffs in order-to-cash, CRM-to-ERP, design release, scheduling, cost control and document management.
  3. Consistent data across systems: schedules, costs, orders, invoices and documents stay in sync across Oracle and non-Oracle applications.
  4. On-time go-lives: including a construction project in the Amazon rainforest that started on schedule within a narrow natural window.
  5. Lower OIC running costs: OIC charges per message, so we kept payloads small, cut API calls with batching, filtering and reuse of intermediate results, and tuned file transfers. Syncs run faster as a result.
  6. Simpler for business and IT teams: sync buttons inside business apps, guided setup in OIC, and standard logging and error handling that operations teams can act on quickly.
  7. Available on Oracle Marketplace: our integration recipes and the Oracle Aconex adapter are published for Oracle customers worldwide.

The result is an integration layer that feels like part of the Oracle product, not a separate system to manage.

Tech stack

Hotovo built every integration on Oracle Integration Cloud and connected it with these Oracle and third-party systems.

Oracle case study Tech stack


Team size

Hotovo's current Oracle team is two developers, working with a seven-person Oracle team.

Hotovo (business-application phase):

  1. Project Manager
  2. Technical Lead
  3. Software Developer
  4. Manual Tester
  5. Technical Writer/QA

Hotovo (later project phase):

  1. 2 Software Developers

Oracle: Director of Software Development, Enterprise Architect, Principal Member of Technical Staff, 4 developers, working with Oracle's international product teams (including Oracle Primavera Unifier)

Explore other projects

AI assistant for ERM workflows

Protecht

AI assistant for ERM workflows

View case study
AiderDesk: AI orchestration platform

Software engineers

AiderDesk: AI orchestration platform

View case study
Multi-tenant hotel booking software

hivr.ai

Multi-tenant hotel booking software

View case study
From audit to platform takeover

HCS Safety

From audit to platform takeover

View case study
AI assistant for faster energy insights

Energy intelligence provider

AI assistant for faster energy insights

View case study
AI copilot for insurance underwriting

g-Xperts

AI copilot for insurance underwriting

View case study
API platform development

PolyAPI

API platform development

View case study
ERM migration powered by AI

Protecht

ERM migration powered by AI

View case study
Kubernetes OperatorHub rebuild

Red Hat

Kubernetes OperatorHub rebuild

View case study
Fintech payment modernization

ACE Solutions

Fintech payment modernization

View case study
Wastewater treatement systems

WTR Global

Wastewater treatement systems

View case study
Smart city civic engagement platform

Adaptie

Smart city civic engagement platform

View case study
Risk analytics for motor fleets

g-Xperts

Risk analytics for motor fleets

View case study
Braille to text OCR desktop tool

DotSight

Braille to text OCR desktop tool

View case study
MuleSoft connector development

MuleSoft

MuleSoft connector development

View case study
Jira reporting app built for acquisition

Old Street Solutions

Jira reporting app built for acquisition

View case study
BNPL platform development

credi2

BNPL platform development

View case study
Enterprise risk management platform

Protecht

Enterprise risk management platform

View case study
Audio software modernization

Audinate

Audio software modernization

View case study
Seed management with modern digital tools

SeedBin

Seed management with modern digital tools

View case study
Braille translation desktop app

Braillee

Braille translation desktop app

View case study
Competition management software for climbing

Verti

Competition management software for climbing

View case study
Mobile app redesign for marketing platform

Seismic

Mobile app redesign for marketing platform

View case study
Call analytics platform and Wallboard app

Akixi

Call analytics platform and Wallboard app

View case study
Mobility and insurance app development

Mobly

Mobility and insurance app development

View case study
Contact us

Let's talk