hi, does anyone know how we can replace a connector from one data model - schema to a new schema for SAP HANA on premise connection

Hi Fergus,

From your question, I didn't exactely understand which 'connection' you meant, sorry for that. So hopefully below (long) description will help you in identifying what you need to do ;-)

in Celonis, we have a Team that is connected to one or multiple connector servers via UpLink.

In a Team, under the Event Collection area there are one or many Data Pools.

In a Data Pool you define first your Data Connection to one or multiple backends which can be accessed though the specifed UpLink.

--> if you need to access a data source that is accessed through another connector server, you can change the uplink of the related Data Connection. I don't see why this would be needed, unless there is a change in IT infrastructure, but it is possible ;-)

Then per connection, you will define one or multiple Scopes which will contain one or multiple Data Jobs. The Scope will hold the name of the Data Connection you selected and each Data Job of a same 'connected' Scope will read the same source of data. If you need to combine data from multiple backends, you need to define a Scope without connection which is called 'Global Jobs' by default.

--> You can change the data source by selecting 'Change Data Connection' in the settings of the relevant Data Job (the 3dots on the right of it). Note that a Data Job created in a Global Jobs scope can't be re-assigned to a 'connected' Scope afterwards.

If you have a successful connection, you can Extract tables and subsequently execute Transformations. Note that a Global Data Job can't extract tables as it has no connection to a backend.

A Process Schema is the result of on one side table extraction and on the other side transformations to create Celonis tables or views. You will have as many schemas as you have Scopes. But in the Global Scope you can 'call' any table from any schema. In a 'connected' Scope, you can only access what is related to the connected backend and transformed 'locally'.

Ultimately you create one or multiple Data Models that will be uploaded to Process Analytics. Note that a Data Model can contain tables or views from any Process Schema, as long as there is a link between 2 tables of different schemas. This would be the case if you have data from SRM and SAP Procurement: they are complementary in the sense that what is done in SRM (a shopping cart for example) is later transferred to SAP for further processing (a Purchase Requisition for example).

--> Data Models can't be reassigned as they are bound to the Process Schemas of the Data Pool.

Lastly, in Process Analytics you create Workspaces under which the Analysis (Instruments) are stored. Note that a Workspace can only connect to ONE Data Model which is defined upon creation. So all analysis in a same workspace will contain the same data from the same DataModel, but potentially present them differently.

--> you can reassign a workspace by selecting 'Data Model' in the settings of the relevant Data Job (the 3dots on the right of it). This will present the current Data Model and you have a blue button on top right of the screen to 'Switch Data Model'. Note that when you do this, your analysis may not work properly anymore if table, view or field names have changed...

regards

Marc

Hi Marc

many thanks for your prompt and detailed response I’m still trying to piece together using the Celonis terminology, maybe I can further elaborate and show screenshots;

1. Our Celonis is an on premise solution connected via SAP HANA

2. today we are running 3 processes(3 analysis/data models); release, incident and change

3. the release process is been fed from a group of tables made that exist in the HANA, a schema called "Celonis_SCHEMA" this connection is working correctly

4. however the other 2 processes incident and change is from an older schema in HANA called "SNOW_SCHEMA" and the analysis do not have the latest feed the views are built but there is no connector feed (this is what we want to fix)

5. in the HANA the "CELONIS_SCHEMA" has all the updated tables and feed including for incident and change

6. we need to update our Incident and Change analysis to reflect the "CELONIS_SCHMEA" (newer)

7. Question, how do we make this configuration to change the source of an analysis feed from one HANA schema to another, (anything will help, knowledge article, screenshots) we would like to keep the same views but the connector needs to update even if we see how to change one example we can figure out the rest

Thanks again

Hi Fergus,

Sorry I didn't understand you were talking about a Celonis on Premise. From your title, I thought it was SAP HANA... and of course, my description and terminology refers to an Celonis EMS Cloud setup, not a on premise one...

I have unfortunately no knowledge of the on premise setup, but I guess the logic behind is similar to the Cloud. From your screenshot, I guess that you have managed to connect, extract and transform data to build the new datamodel. And as such the data is there.

But your analysis is still reading from the old datamodel. So it is on the analysis side that you need to find how to update this link. There must be a menu that you can select the appropriate option from...

You should check on the training portal. There is a 'On Premise' track that must explain how it all goes. And if you don't find it, raise a Support ticket.

A last hint, may be time to migrate to the Cloud solution? It offers way more possibilities and powerful tools!

regards

Marc

thanks for your help Marc