Contact Free trial Login

Database Connector 1.8 - Mule 4

Support Category: Select

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. 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.

Prerequisites

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 (Studio)

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.

Audience

Using Exchange Templates and Examples

Anypoint Exchange provides templates that you can use as starting points for your apps and examples that illustrate a complete solution.

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.