To execute a database SQL action (INSERT, UPDATE, DELETE), which of the below approaches give faster results and why?
1- Use a db connector
2- Use a program command shape
You may be interested in: When should a process command be used vs db connector for db update, delete, insert or stored proc executions? .
Also, to clarify something in Shivam Dell's comment, whether or not the process can be deployed to the Dell Boomi Atom Cloud is not dependent on using the Database connector vs. Program Command shape. Both reference a database connection component so the real considerations are 1) is your database accessible via the public internet and 2) does your type of database require a driver that is not pre-loaded on the Dell Boomi Atom Cloud (e.g. ms sql server, oracle, postgresql, azure).
If you consider program command for the purpose of database update, insert and delete then you will have all the possible options here via SQL statements, stored procedures, and system commands. But this shape has the restriction that it cannot be used in processes that are deployed to a Dell Boomi Atom Cloud.
While in case of a DB connector it does not contain the SQL statements of those in the database profile. So if your process involves a scenario where you do not need to deploy it to a dell boomi atom cloud then you may go ahead with the program command which is comparatively more flexible and has more db options, but in any other case a DB Connector is preferred. Both these shapes are equally fast as far as the performance is considered.
If you require conversion from one format to another format then you require Map shape and which requires database profile. So you can database connector to process bulk data.
If you use program command shape then you are able to write customer query but it is not feasible solution for bulk transactions.
Retrieving data ...