Contact Us 1-800-596-4880

Configure Use Bulk Copy for Database Connector SQL Server Connection

You can configure the bulk copy for batch insert in Anypoint Connector for Database (Database Connector) for the Microsoft SQL Server Connection. This feature allows you to enable the driver to do bulk copy operations when executing batch insert operations. Configure this feature as a connection property in the Database Connector Configuration screen.
  1. In Studio, navigate to the Global Elements tab.

  2. Click Create.

  3. In the search bar, type database.

  4. Select Database config.

  5. Click OK.

  6. In the Global Elements Properties screen, set Connection to Microsoft SQL Server Connection.

  7. Click the Advanced tab.

  8. Set Connection properties to Edit inline.

  9. Click the plus sign to add a new property.

  10. In the Connection property screen, set Key to useBulkCopyforBatchInsert.

  11. Set Value to true.

useBulkCopyforBatchInsert property created under the Connection property section
View on GitHub