Question
Limitation on no. of records in Case table of IBC
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 !
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.