Database

The Database plugin contains functions that can be used on databases:

  • BeginTransaction: To start a transaction in a database that facilitate performing multiple database operations on the same transaction.

  • DBBulkCopy: To efficiently copy large amounts of rows to a table in a SQL Server or Oracle database.

  • ExecuteSQL: To execute a SQL query and return relevant data. The query can contain any SQL and calls that are supported by the database driver.

  • ExecuteStoredProcedure: To run a stored procedure on a database.

  • MongoDBMapReduce: To perform a map-reduce style data aggregation on a Mongo database.

  • MongoDBRead: To perform read operations on a Mongo database.

  • MongoDBWrite: To perform write operations on a Mongo database.


Also see

Samples

The Database plugin is used in various samples, including:

Parse CSV File

Parse XML File

Write CSV File

Publish Web Service

Send Email

Store Images In Database

Extract Bank Transactions to Database