Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
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,863 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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

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

Leaderboard > Power Automate - Building Flows

#1
David_MA Profile Picture

David_MA 292 Super User 2025 Season 1

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 263 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 218

Overall leaderboard
Loading started