Skip to main content
Question

Limitation on no. of records in Case table of IBC

  • January 20, 2021
  • 1 reply
  • 26 views
R
Level 2
Hello, Can someone tell me about what is the limitation on no. of records that can be processed in Celonis IBC via JDBC connection to a database ? Interested to know the maximum no. of records that can be handled by CASE table, and event log separately. @l.vogel Thanks !

1 reply

J
Level 0
  • justin.stegm
  • Level 0
  • November 8, 2021

Hi @raunak.jhanw13,

 

basically there is no limit on how many rows can be extracted. There are just some circumstances that you should consider when setting up your extractions as they can influence the performance (e. g. duration) of the extraction. Some of them are as follows:

  • # columns heavily impacts the size of the tables to be extracted
  • data types of columns can also impact extraction performance
  • # extractions jobs running in parallel (EMS to source system)
  • # jobs running on the source system

 

As you also mention activity tables: It is normally recommended to not exceed 800 million activities in one activity table as otherwise performance can be impacted.

 

Hopefully that answer your questions! If you have any additional questions please feel free to reach out to us once again!

 

Best,

 

Justin

Community Code of ConductAccessibility statement