Warning message displayed when executing Bulk Insert activity

Hi folks.
When connecting to Postgresql and performing bulk insert activity, the following warning message appears every time.

The configured provider does not support Bulk Insert operations. Providers that support Bulk Insert operations are: Microsoft.Data.SqlClient and Oracle.ManagedDataAccess.Client.OracleConnection.

Is this simply a notification that these two Oracle data providers do not support bulk inserts, and does this mean that you don’t need to worry about it when using them with PostgreSQL?
I checked the website for the following activity in particular because there was no particular note about it.
Activities - Bulk Insert (uipath.com)

1.Activities in a project



2.Dependency

The UiPath Studio used is the Community Edition.

Hey @loginerror, many open threads on this with no solution or information. Would you please redirect this to an expert from your side?

@htanaka1

1 Like

Indeed, you don’t need to be worried about it, but you should be aware of it.

As per the documentation that you linked:

For DBs that do not support it, it falls back to the Insert Data Table (at which point there is no difference and you might as well use the simple Insert activity).

2 Likes

Thanks @loginerror , @ashokkarale , i got it.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.