create work item or case id or case creation in bulk from db 1 million records
requirement : need to create cases with records data available in database , it db records are 1 million with this data to be created cases and not to create duplicate with same data
what is best approach to implement this requirement as it is 1 million records to be fetched from data bases of external to application.
thanks in advance.
Accepted Solution
Updated: 9 Jan 2025 11:05 EST
Evonsys
IN
Evonsys
IN
@RaviG0023 use real time data flow. To fetch use data set. Then use case as destination in data flow to create case.
HCL
IN
@Anoop Krishna
thank you for your reply and inputs.
data set only enough to use this approach to create cases of these huge number of cases
or else
with queue processing ,is it best approach to create cases of 1 million of records of db data ?!
consider performance implications also
Accepted Solution
Updated: 9 Jan 2025 11:05 EST
Evonsys
IN
@RaviG0023 yes enough. Queue processor also uses data flow in the backend. Data flow uses partitions to process records, so will be very fast.
If service team can setup kafka for you and you can consume data via data set then will be very fast. But from DB also it will be very fast.
@RaviG0023 yes enough. Queue processor also uses data flow in the backend. Data flow uses partitions to process records, so will be very fast.
If service team can setup kafka for you and you can consume data via data set then will be very fast. But from DB also it will be very fast.