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.

@RaviG0023 use real time data flow. To fetch use data set. Then use case as destination in data flow to create case.

@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

@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.