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.
Bits in Glass
IN
@RaviG0023 use real time data flow. To fetch use data set. Then use case as destination in data flow to create case.
capgemini
IN
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
Bits in Glass
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.