Does this tool connect to my OCI account?

No. This tool runs entirely in your browser and generates configuration JSON that you can copy and paste into your infrastructure-as-code templates, CLI commands, or cloud console. It never connects to any cloud account or sends data externally.

Are the generated configurations production-ready?

The tool produces syntactically valid configurations based on current OCI service specifications. Always review generated configs against your organization security policies and test in a non-production environment before deploying.

OCI Integration Flow Builder

ServerlessOCI

Build Integration Service flow configurations with connections, mapping steps, and schedules.

Last verified: May 2026

OCI Integration Service Configuration

Build Integration Service flow configurations with connections, mapping steps, schedules, and error handling.

Required Fields

compartmentIddisplayNameintegrationInstance.instanceIdflow.flowTypeflow.connectionsflow.steps

{
  "compartmentId": "ocid1.compartment.oc1..aaaaaaaexample",
  "displayName": "erp-to-hcm-sync-flow",
  "description": "Integration flow to synchronize employee data from ERP Cloud to HCM Cloud",
  "integrationInstance": {
    "instanceId": "ocid1.integrationinstance.oc1.iad.aaaaaaaexample",
    "instanceType": "ENTERPRISE",
    "isByol": false,
    "messagePacks": 5,
    "networkEndpointType": "PRIVATE",
    "subnetId": "ocid1.subnet.oc1.iad.aaaaaaaexample"
  },
  "flow": {
    "flowType": "SCHEDULED_ORCHESTRATION",
    "schedule": {
      "frequency": "HOURLY",
      "interval": 1,
      "timezone": "UTC"
    },
    "triggerConfig": {
      "type": "SCHEDULE",
      "cronExpression": "0 0 * * * ?"
    },
    "connections": [
      {
        "name": "erp-cloud-source",
        "adapterType": "ORACLE_ERP_CLOUD",
        "connectionUrl": "https://erp.example.com",
        "securityPolicy": "USERNAME_PASSWORD",
        "credentialSecretId": "ocid1.vaultsecret.oc1.iad.aaaaaaaexample-erp"
      },
      {
        "name": "hcm-cloud-target",
        "adapterType": "ORACLE_HCM_CLOUD",
        "connectionUrl": "https://hcm.example.com",
        "securityPolicy": "USERNAME_PASSWORD",
        "credentialSecretId": "ocid1.vaultsecret.oc1.iad.aaaaaaaexample-hcm"
      }
    ],
    "steps": [
      {
        "name": "fetch-employees",
        "type": "INVOKE",
        "connection": "erp-cloud-source",
        "operation": "GET /hcmRestApi/resources/emps",
        "queryParameters": {
          "q": "LastUpdateDate > ${lastRunTime}",
          "limit": 500
        }
      },
      {
        "name": "transform-data",
        "type": "MAP",
        "mapper": {
          "sourceSchema": "ERP_Employee",
          "targetSchema": "HCM_Worker",
          "mappings": [
            { "source": "PersonId", "target": "WorkerId" },
            { "source": "DisplayName", "target": "PersonName" },
            { "source": "EmailAddress", "target": "WorkEmail" }
          ]
        }
      },
      {
        "name": "upsert-workers",
        "type": "INVOKE",
        "connection": "hcm-cloud-target",
        "operation": "POST /hcmRestApi/resources/workers",
        "batchSize": 50
      }
    ],
    "errorHandling": {
      "retryCount": 3,
      "retryInterval": 60,
      "errorNotification": {
        "topicId": "ocid1.onstopic.oc1.iad.aaaaaaaexample"
      }
    }
  },
  "freeformTags": {
    "integration": "erp-hcm-sync",
    "team": "integration"
  }
}

Generated Output

Output will appear here...

See It in Action

Your team needs to sync customer data between Salesforce and Oracle ERP nightly. Without Integration Service, this would require: Salesforce API client + Oracle API client + custom mapping code + scheduling + error handling = 2-3 weeks of development. The builder generates an Integration flow: Salesforce connection, Oracle ERP connection, visual mapping designer for the customer schema, cron schedule. End-to-end integration in 1 day. Cost: ~$200/month for the volume vs $0/month for custom code, but the time-to-value justifies it for most teams.

What This Tool Does

Build Integration Service flow configurations with connections, mapping steps, and schedules. This tool helps OCI engineers generate valid configurations quickly without consulting documentation, reducing errors and accelerating infrastructure deployment. All processing runs in your browser with no data sent to external servers.

Technical Details

The builder constructs OCI Integration Service flow configurations: integration resource (compartment, instance, integration type: SCHEDULED / APP_DRIVEN / FILE_BASED), connections (per-system credentials and endpoints), data mapping definitions (source schema → target schema with transformation rules), schedule (cron-based for SCHEDULED type), and error handling. Output is generated as oci integration commands and Terraform oci_integration_integration_instance resources.

Common Use Cases

1Generating oci integration flow configurations for new infrastructure deployments.
2Validating existing configurations against best practices before applying changes.
3Learning OCI service configuration patterns through interactive examples.
4Accelerating infrastructure-as-code development by producing correct JSON/YAML starting points.

Common Questions

Does this tool connect to my OCI account?: No. This tool runs entirely in your browser and generates configuration JSON that you can copy and paste into your infrastructure-as-code templates, CLI commands, or cloud console. It never connects to any cloud account or sends data externally.
Are the generated configurations production-ready?: The tool produces syntactically valid configurations based on current OCI service specifications. Always review generated configs against your organization security policies and test in a non-production environment before deploying.

Expert Tips

TIP

Integration Service has 50+ pre-built adapters for popular SaaS systems (Salesforce, NetSuite, ServiceNow, Workday, etc.). For SaaS-to-SaaS integrations, this is dramatically easier than writing custom code against each vendor's API. The trade-off: more expensive than custom code at high volume.

TIP

Use Integration Service for SCHEDULED batch ETL between SaaS systems (nightly Salesforce → Oracle ERP sync). For real-time event-driven integrations (e.g., 'when an order arrives in Shopify, immediately update Oracle'), you may need custom code or webhook architectures.

TIP

Watch the per-message billing on Integration Service — high-volume integrations can rack up significant costs. For >100K messages/day workloads, custom code on OCI Functions + Object Storage may be 5-10x cheaper than Integration Service.

Related Learning Guides

OCI Streaming & Events22 min read
OCI Functions: Serverless Guide22 min read

Was this tool helpful?

Disclaimer: This tool runs entirely in your browser. No data is sent to our servers. Always verify outputs before using them in production. AWS, Azure, and GCP are trademarks of their respective owners.