Skip to main content
Question

Whether Celonis(either OP or Cloud) support Oracle database?

  • July 8, 2020
  • 18 replies
  • 56 views
K
Level 2
Dear Experts Does anyone know if Celonis OP system or the IBC Hybrid deployment supports Oracle database? Is there any customer references? Thanks!

18 replies

kay.kaspe
Level 3
  • kay.kaspe
  • July 8, 2020
Hi Kai, Oracle is supported in OnPremise (see screenshot below) image1570795 46.7 KB I am not sure about the hybrid scenario according to the documentation (https://YourCompanyName.celonis.cloud/help/display/CIBC/Transformations) only MS SQL or SAP HANA. Best Regards, Kay
K
Level 2
Hi Kay, Appreciate your reply! I should make the questions more clear - for on premise version, can Celonis system itself run on Oracle? : ) Thanks!
kay.kaspe
Level 3
  • kay.kaspe
  • July 8, 2020
Im not sure I understand your question, Kai. You mean a setup of the Configuration Store (central storage of the application metadata, system settings, users, groups, analysis, data model)? The Configuration Store only supports PostgreSQL and MSSQL.
V
Level 7
  • vivek.m
  • Level 7
  • July 16, 2020
Hi Kay, As you aware, Celonis will be 100% IBC in future and also there is migration path for existing customers move from OP to IBC. So to Answer your question - Celonis IBC works/ Connects to Oracle DB (Both Cloud & OP ) Hope I was able to address your Query ?
K
Level 2
Hi Vivekm Good to hear thatAre you aware of any customers running Celonis( either OP or IBC) on Oracle? Thanks!
M
Level 3
I think there is some confusion here as to which databases IBC runs on and which DBs it connects to as a data source. It definitely connects to Oracle DB but I suspect it doesnt run on oracle DB. Then again, as it is a SaaS, it should not matter to the client which DB the vendor chooses to run it on, should it?
K
Level 2
Here the case is, customer would like to keep the data in local(as much as possible), even for IBC Celonis supports a deployment option - Leave the Data in Place to use a local database for data storage
kay.kaspe
Level 3
  • kay.kaspe
  • July 17, 2020
For the Leave-Your-Data-In-Place-Scenario please check my link above https://YourCelonisInstance.celonis.cloud/help/display/CIBC/Transformations or https://YourCelonisInstance.celonis.cloud/help/display/CIBC/Leave+Your+Data+in+Place+Deployment The Leave-Your-Data-In-Place-Scenario only supports MS SQL Server or SAP HANA as data store. image11251454 152 KB As @123mdv wrote before, you could connect an oracle db in full cloud scenario but not for the leave-your-data-in-place-scenario. You could use the oracle db only as a source system (see picture).
V
Level 7
  • vivek.m
  • Level 7
  • July 20, 2020
Agree with 123mdv and Kasperkowitz. Customer can opt to have dedicated LDP Server either on OP/Cloud ( AWS & Others) but OS & Virtual DB is limited HANA/ MySQL for now. LDP System Architecture19921042 245 KB
jasper.feije
Level 4
Forum|alt.badge.img+14
Hi Kai, Yes, you can connect Celonis IBC (and on premise as well) with an Oracle database. We (www.processminery.com) are avspecialized Oracle Partner and have connected several Oracle (EBS R12) databases and Oracle ERP Cloud instances. Also Celonis provide out of the box Oracle EBS R12 connectors and Apps in the Celonis App Store. Best, Jasper
S
Level 2

Hi Everyone, How to Extract the data from the Oracle Fusion Cloud ? Can any one provide the Sample P2P data file for Fusion?

 

Please help. We would like to know the REST API or Database table Names to pull the data rom Fusion Database.

 

Thanks,

Shashi.

jasper.feije
Level 4
Forum|alt.badge.img+14

Hi Shashi,

 

For the P2P proces.

 

First you need the Oracle Cloud and Oracle BI Publisher Extractors so you can setup the data connections.

If you do not see thes tiles (under new data connections) please log a service ticket and ask if Celonis can activate them in your team.

 

We use the Oracle Cloud connector to extract these tables:

 

Because Oracle does not provide all the API's which we needed we also extract tables via the Oracle BI Publisher Extractor:

(PER_USERS, PO_ACTION_HISTORY, PO_DISTRIBUTIONS_ARCHIVE_ALL, PO_HEADERS_ARCHIVE_ALL, PO_LINES_ARCHIVE_ALL, PO_LINE_LOCATIONS_ARCHIVE_ALL, RCV_SHIPMENT_HEADERS, RCV_TRANSACTIONS)

 

To extract these tables you have to create a datamodel and a report in your Oracle Fusion ERP Cloud environment.

 

After you extract the raw data you can transform them into an event log.

 

Best,

Jasper

Process Minery B.V.

(the Netherlands)

 

 

S
Level 2
Hi Jasper, Can you please provide me any sample data templates for the Oracle Fusion P2P Extract? What columns(data) do we need to pull? Is there any REST API available? Can you provide any SQL Queries to pull the data from? Thanks, Shashi.
S
Level 2

Hi Jasper,

 

I have pulled the data based on all the Tables that you have provided me but still the data for the Requisition, Invoices and payables are still missing.

Can you provide me the all the oracle fusion Tables for the P2P Cycle.

 

Please help...!

 

Thanks,

Shashi.

 

 

jasper.feije
Level 4
Forum|alt.badge.img+14

Hi Shashi,

 

We extract these tables using the standard Oracle Cloud ERP API's:

PURCHASEREQUISITIONS

INVOICES

PAYABLESPAYMENTS

PURCHASEORDERS

INVOICEHOLDS

SUPPLIERS

 

Best,

Jasper

 

 

S
Level 2

Hi Jasper,

 

Thank you for your help. I will try to pull the data using this REST API.

 

Thanks again for all your help.

 

 

Thanks,

Shashi.

S
Level 2

HI Jasper,

 

Thank you for your help. Do you think is there any other Tables or API we need to consider apart from what you provided?

 

how to pull the Event logs for Requisition and Payable Modules? If possible can you please share me the RESTAPI URL?

 

Please Help. Thank you for all your help in advance.

 

 

Thanks,

Shashi.

jasper.feije
Level 4
Forum|alt.badge.img+14

Hi Shashi,

 

For the P2P process I do not think you need more tables, of course this depends on your situation and what you need to analyze in Celonis.

 

For more information about the Oracle ERP Cloud Rest API's please visit:

https://docs.oracle.com/en/cloud/saas/financials/21b/farfa/index.html

and

https://docs.oracle.com/en/cloud/saas/procurement/21b/api.html

 

Best,

Jasper

Community Code of ConductAccessibility statement