Hi All,
Good day!!
I have a use case where I need to populate around 1.6k records in a Oracle table from a csv file on share point.
I am using Oracle premium connector and Insert row step to do this but for 1.6k records with concurrency control its taking almost an hour to populate the data.
To optimize this I tried to create the Insert All statement and use the Execute Query step, but the step is failing because of the \r\n for new lines.
Can anyone please advise how can we optimize and increase the speed to data entry into table.
Thanks and Regards,
Sathish.
Have you tried dataflows?
Or a template CSV parser?
https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/CSV-to-Dataset/td-p/1508191
Once you have all the CSV data in a dataflow or in a JSON format, you should be able to better manipulate it to whatever you need for SQL.
stampcoin
61
Michael E. Gernaey
47
Super User 2025 Season 1
rzaneti
29
Super User 2025 Season 1