You’re offline. This is a read only version of the page.
Announcements
18
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.
Share
Report
All responses (
Answers (
