Dear Experts
Does anyone know if Celonis OP system or the IBC Hybrid deployment supports Oracle database? Is there any customer references?
Thanks!
Page 1 / 1
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
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
Hi Kay,
Appreciate your reply! I should make the questions more clear - for on premise version, can Celonis system itself run on Oracle? : )
Thanks!
Appreciate your reply! I should make the questions more clear - for on premise version, can Celonis system itself run on Oracle? : )
Thanks!
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.
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.
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 ?
So to Answer your question - Celonis IBC works/ Connects to Oracle DB (Both Cloud & OP )
Hope I was able to address your Query ?
Hi Vivekm
Good to hear thatAre you aware of any customers running Celonis( either OP or IBC) on Oracle?
Thanks!
Good to hear thatAre you aware of any customers running Celonis( either OP or IBC) on Oracle?
Thanks!
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?
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?
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
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).
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).
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
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
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
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
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.
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)
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.
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.
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.
Hi Shashi,
We extract these tables using the standard Oracle Cloud ERP API's:
PURCHASEREQUISITIONS
INVOICES
PAYABLESPAYMENTS
PURCHASEORDERS
INVOICEHOLDS
SUPPLIERS
Best,
Jasper
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.
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.
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
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.