---
schema_version: "1"
id: 69b48bd69c6c78aeec8ef82eec204c44d44a67c932a60800806f3159a8e73a86
title: Database Connector 1.16
collection: mulesoft
version: current
locale: en-us
portal_url: https://docs.salesforce.com/mulesoft/current/en-us/db-connector/latest/index.md
canonical_url: https://docs.mulesoft.com/db-connector/latest/
source_site: docs.mulesoft.com
content_type: documentation
content_hash: 770877938bf92b6e6f0b199c407e169f582fde77aa122238d61fe364e777e9b0
description: MuleSoft Documentation Site
release: "1.16"
latest: true
---
---
product: Database Connector
version: 1.16
is-latest-version: true
---

# Database Connector 1.16

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

Anypoint Connector for Database (Database Connector) establishes communication between your Mule app
and a relational database. Database Connector can connect to almost any Java Database Connectivity
(JDBC) relational database and run SQL operations. An application can support multi-tenant scenarios
using the same configuration element, changing the connection attributes based on, for example,
information coming from each request.

Database Connector has connection providers that automatically set the driver class name and create
JDBC URLs with given parameters for the following databases:

- Derby

- Microsoft SQL Server

- MySQL

- Oracle

You can set up other JDBC databases using a generic JDBC configuration. Database Connector is JDBC
compliant. Ensure that for the connection configuration, you use a driver that is compliant with
JDBC to avoid compatibility issues. Additionally, you can reference a JDBC `DataSource` object or an
`XADataSource` object, which is required for XA transactions, by creating the object in Anypoint
Studio using Spring.

## Before You Begin

To use this connector, you must be familiar with:

- Anypoint Connectors

- Mule runtime engine (Mule)

- Elements and global elements in a Mule flow

- Creating a Mule app using Anypoint Studio or Anypoint Code Builder

Before creating an app, you must have access to the database target resource, Anypoint Platform, and
have downloaded the proper database driver for your database.

## Common Use Cases for the Connector

Database Connector enables you to:

- Perform predefined queries, dynamically constructed queries, and template queries that are
  self-sufficient and customizable.

- Specify DataWeave expressions in connector fields and configure attributes dynamically, depending
  on the database configuration you use.

- Use a source listener operation to read from a database in the data source section of a flow.

- Execute other operations to read and write to a database anywhere in the process section.

- Perform multiple SQL requests in a single bulk update.

- Make Data Definition Language (DDL) requests that alter the data structure rather than the data
  itself.

- Execute stored procedures and SQL scripts.

For examples, see [Examples](https://docs.mulesoft.com/db-connector/latest/database-connector-examples).

## Audience

- New users, read:

  - [Using Anypoint Studio to Configure the Connector](https://docs.mulesoft.com/db-connector/latest/database-connector-studio) to create your
    Mule app

  - [Examples](https://docs.mulesoft.com/db-connector/latest/database-connector-examples), which provide one or more use cases for the connector

- Advanced users, read:

  - [XML and Maven Support](https://docs.mulesoft.com/db-connector/latest/database-connector-xml-maven)

  - [Examples](https://docs.mulesoft.com/db-connector/latest/database-connector-examples), which provide one or more use cases for the connector

## Using Exchange Templates and Examples

[Anypoint Exchange](https://www.mulesoft.com/exchange/) provides templates that you can use as
starting points for your apps and examples that illustrate a complete solution.

- [Database Connector Examples](https://www.mulesoft.com/exchange/?search=database&type=example)

- [Database Connector Templates](https://www.mulesoft.com/exchange/?search=database&type=template)

## Next Step

After you complete the prerequisites and try the templates and examples, you are ready to create
your own app and configure the connector using [Anypoint Studio](https://docs.mulesoft.com/db-connector/latest/database-connector-studio).

## See Also

- [Introduction to Anypoint Connectors](https://docs.mulesoft.com/connectors/introduction/introduction-to-anypoint-connectors)

- [Use Exchange to Discover Connectors, Templates, and Examples](https://docs.mulesoft.com/connectors/introduction/intro-use-exchange)

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