Bulk data Insert into Oracle SQL Table

Like (0) Share

Report

Posted on 21 Jun 2022 14:11:40 by sathish804

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.

All responses (1)

Answers (0)

takolota1 4,863 Super User 2025 Season 1 on 21 Jun 2022 at 16:13:37

Like (1)

Report

Re: Bulk data Insert into Oracle SQL Table

@sathish804

Have you tried dataflows?
https://youtu.be/8IvHxRnwJ7Q

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.