Skip to main content

Celonis Product Documentation

Connecting to Oracle EBS

You can connect your Oracle EBS tenant to the Celonis Platform, allowing you to integrate data from your ERP, CRM, and SCM processes. This connection can either be direct or using an uplinked on-premise extractor, with you choice dictated by how much access you want to allow the Celonis Platform to have to your database.

For a video overview of this process:

Prerequisites for connecting to Oracle EBS

Before connecting your Oracle EBS tenant to the Celonis Platform you need to configure an Oracle EBS user who has permissions to extract the tables and colums you want to integrate.

For more information about configuring Oracle EBS users, see: Oracle EBS Docs

Step 1: Defining the connection type with Oracle EBS

Before creating a connection between your Oracle EBS tenant and the Celonis Platform you must decide which connection type you use.

Direct connections to Oracle EBS

Use this when you want to allow the Celonis Platform to directly access your Oracle EBS tenant.

Uplinked connections to Oracle EBS via an on-premise extractor

Use this when you don't want to or can't allow the Celonis Platform to directly access your Oracle EBS tenant. The connection between Oracle EBS and Celonis is then established using an on-premise extractor that's installed within your network and ideally on a dedicated server.

The role of the extractor is to poll and fetch job requests from the Celonis Platform, before then submitting the execution information the the database via an SQL query. Once the data is retrieved from the database, the extractor feathces it and sends it back to the Celonis Platform. As such, the connection between the database and the Celonis Platform is always made by the extractor, with it continously quering the Celonis Platform for any extractions to execute.

For more information about the on-premise extractor (including system requirements), see: On-premise extractors.

The next step is to modify your network settings to allow the database extractor to communicate with Oracle EBS and the Celonis Platform.

The settings here are based on the connection type you defined in step 1:

Network settings for direct connections

The following network settings apply for direct connections:

Source system

Target system

Port

Protocol

Description

Celonis Platform

Oracle EBS

Depending on the database, typical ports are 5432 for Postgres and 30015 for HANA for example

TCP

JDBC connection from the Celonis Platform to the database. The port is the one you normally use to connect to the database. The IPs of the Celonis Platform depending on the cloud cluster (which can be seen in the URL).

Network settings for uplinked connections

The following network settings apply for uplinked connections (via the on-premise extractor):

Source system

Target system

Port

Protocol

Description

On-premise extractor server

Oracle EBS

Depending on the database, typical ports are 5432 for Postgres and 30015 for HANA for example.

TCP

JDBC connection from on-premise extractor server to the database. The port is the one you normally use to connect to the database.

On-premise extractor server

Celonis Platform

443

TCP

HTTPS connection from on-premise extractor server to Celonis cloud endpoint. The IPs of the Celonis Platform depending on the cloud cluster (which can be seen in the URL).

Celonis Platform IP addresses depending on the cluster

The respective clusters use multiple IPs each, so you need to enable all three of them in your firewall configuration to connect the on-premise extractor server and the cloud endpoint.

For a complete list of inbound and outbound Celonis Platform IP addresses to be allowlisted if needed, see: Allowlisting domain names and IP addresses

Note

This step is only needed if your database is not reachable from the Celonis Platform.

This step is only needed if your database is not reachable from the Celonis Platform.

For more information, see: Setting up

If you would like to use a proxy (optional), see: Proxy settings for on-prem clients.

You can now create the connection between Oracle EBS and the Celonis Platform from your data pool diagram:

  1. Click Data Connections.

    data_connections_within_data_pool_diagram.png
  2. Click Add Data Connection and select Connect to Data Source.

    add_data_connection.png
  3. For direct connections, select Cloud - Oracle EBS.

    For uplinked connections, select: On-Premise - Oracle EBS and then select your uplink (configured as part of step 1).

  4. Configure the following connection details, with the options here depending on your choice of uplinked or direct connection:

    • Name: An internal reference for the data connection.

    • Uplink Connections: The name of the Uplink Extractor Server installed on your end.

    • Database Type: Select Oracle EBS.

    • Configuration type: Select Standard.

    • Host: The database server name or IP address of the database server.

    • Port: The port to connect to the database server.

    • Service Name: If applicable to a specific database type (e.g. Oracle), enter the Service Name (Alias) associated with the database server.

    • Additional Properties: Additional properties like validateCertificate=false.

    • Username and password: The database credentials used by the user.

    • Maximum number of parallel extractions: This is usually governed by the database type you are using. The default value chosen is 4.

    • Timeout for database connections: Timeout for all database connections created in this connection (specific to this connection only). This value will overwrite the local timeout (in application.yaml) in case of uplinked connection.

  5. Click Test Connection and correct any highlighted issues.

  6. Click Save.

    The connection between your Oracle EBS tenant and the Celonis Platform is establised. You can manage this connection at any time by clicking Options:

    managing_data_connections.png