Skip to main content

Notifications

Community site session details

Community site session details

Session Id : KPpAOPXXQbLfPP2zDVpTNT
Power Automate - Building Flows
Unanswered

Bulk data Insert into Oracle SQL Table

Like (0) ShareShare
ReportReport
Posted on 21 Jun 2022 14:11:40 by 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.

 

sathish804_0-1655820641011.png

 

Can anyone please advise how can we optimize and increase the speed to data entry into table.

 

Thanks and Regards,

Sathish.

 

  • takolota1 Profile Picture
    4,859 Super User 2025 Season 1 on 21 Jun 2022 at 16:13:37
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
stampcoin Profile Picture

stampcoin 61

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 47 Super User 2025 Season 1

#3
rzaneti Profile Picture

rzaneti 29 Super User 2025 Season 1

Overall leaderboard
Loading started
Loading complete