---
schema_version: "1"
id: 489d53c151ba1b8fc073251a14f46baf537a253209af9e0366a9d54f171b515f
title: Database Connector Examples
collection: mulesoft
version: current
locale: en-us
portal_url: https://docs.salesforce.com/mulesoft/current/en-us/db-connector/latest/database-connector-examples.md
canonical_url: https://docs.mulesoft.com/db-connector/latest/database-connector-examples
source_site: docs.mulesoft.com
content_type: documentation
content_hash: 6e6f39e810b807aeb0fc1c1c28b5ba6a29f8e9439ef54b2d87e5af0279192c05
description: MuleSoft Documentation Site
release: "1.16"
latest: true
---
---
product: Database Connector
version: 1.16
is-latest-version: true
---

# Database Connector Examples

> For the full documentation index, see: https://docs.mulesoft.com/llms.txt

Anypoint Connector for Database (Database Connector) examples help you configure database
connections, query a database, execute stored procedures, execute DDL statements, execute scripts,
execute database transactions, use bulk operations, and configure custom data types:

- [Configure a Database Connection](https://docs.mulesoft.com/db-connector/latest/database-connector-connection)  
  Connect to both popular and generic database. Additionally, configure the connector to connect to
  a global data source, set a JDBC driver, configure connection pooling, and connection to an Oracle
  database with TNS.

- [Configure an Oracle TLS Database Connection](https://docs.mulesoft.com/db-connector/latest/database-connector-connection-secure-oracle)  
  Connect to Oracle through a secure TPC (TCPS) tunnel using multiple secure Oracle connection
  levels and Mule’s TLS configuration.

- [Configure Driver Visibility using Mule Maven Plugin](https://docs.mulesoft.com/db-connector/latest/database-connector-driver-configuration)  
  Use the Mule Maven Plugin to configure properly the driver classes visibility.

- [Query a Database](https://docs.mulesoft.com/db-connector/latest/database-connector-select)  
  Configure the **Select** operation to query data from a database.

- [Query a Single Record from a Database](https://docs.mulesoft.com/db-connector/latest/database-connector-query-single)  
  Configure the **Query single** operation in a Mule application that retrieves books information
  from a table in a MySQL database.

- [Insert, Update, and Delete Data](https://docs.mulesoft.com/db-connector/latest/database-insert-update-delete)  
  Configure the **Insert**, **Update** and **Delete** operations to manage data.

- [Bulk Insert, Bulk Update, and Bulk Delete Data from a Database](https://docs.mulesoft.com/db-connector/latest/database-execute-bulk)  
  Configure the **Bulk insert**, **Bulk update**, and **Bulk delete** operations to manage date in
  bulk.

- [Execute Stored Procedures](https://docs.mulesoft.com/db-connector/latest/database-stored-procedure)  
  Configure the **Stored Procedure** operation to combine `input`, `output`, and `input-output`
  parameters. Additionally, configure dates on stored procedures.

- [Call an Oracle Stored Procedure That Uses UDTs](https://docs.mulesoft.com/db-connector/latest/database-connector-udt-stored-procedure)  
  Configure the **Stored procedure** operation to call an Oracle database stored procedure that uses
  UDTs for its input and output parameters. Additionally, use `prepareStruct` and `prepareArray`
  DataWeave functions to map application data to your custom types.

- [Execute DDL Statements](https://docs.mulesoft.com/db-connector/latest/database-connector-execute-ddl)  
  Configure the **Execute DDL** operation to execute DDL statements that create or modify data
  within tables or other data structures.

- [Execute Scripts](https://docs.mulesoft.com/db-connector/latest/database-execute-script)  
  Configure the **Execute Script** operation to execute a script as a single statement.

- [Configure Database Data Types](https://docs.mulesoft.com/db-connector/latest/database-configure-data-types)  
  Configure custom data types to use when connected to a particular connection provider.

- [Configure Database Transactions](https://docs.mulesoft.com/db-connector/latest/database-connector-transactions)  
  Execute database operations in the context of a transaction.

- [Insert large file content into a table](https://docs.mulesoft.com/db-connector/latest/database-insert-large-clob)  
  Configure a Mule app flow to read and insert a large file into a table.

- [Using XA Transactions in Database Connector](https://docs.mulesoft.com/db-connector/latest/database-connector-xa-transactions)  
  Configure the **Use XA Transactions** field in the Database Connector global configuration so the
  datasource supports Extended Architecture Transactions (XA Transactions).

- [Configure Use Bulk Copy for Database Connector SQL Server Connection](https://docs.mulesoft.com/db-connector/latest/database-configure-usebulkcopy)  
  Configure
  the Use Bulk Copy to do bulk copy operations when executing batch insert operations.

- [Configure Azure Active Directory Authentication for MS SQL Server](https://docs.mulesoft.com/db-connector/latest/database-connector-integratedsecurity)  
  Configure
  Azure Active Directory Authentication for MS SQL Server using the Database Connector via the
  `IntegratedSecurity` parameter.

- [Configuring Input and Output Parameters for Stored Procedures](https://docs.mulesoft.com/db-connector/latest/database-connector-input-output-parameters)  
  Configure
  input or output parameters for the **Stored procedure** operation of Anypoint Connector for
  Database (Database Connector) to specify the parameters that a stored procedure uses.

## See Also

[Salesforce Help](https://help.salesforce.com)