Database Connector

The database connector establishes communication between your app and a relational database.

The database connector facilitates setting up the following databases for use in a Mule app:

• Derby
• MySQL
• Oracle

You can set up other JDBC databases using a generic JDBC configuration. You can also reference a JDBC DataSource object, or XADataSource object which is required for XA transactions. You typically create the object in Studio using Spring.

Note: This connector module only works with Mule 4 and Studio 7.

What’s New in the Database Connector

If you are a Mule 3.x user, the Mule 4 database connector, which connects your app to relational databases, has a familiar UI. The new version includes these improvements:

• Easier to use operations, for example, bulk insert, update, and delete are now separate operations. A bulk operation behavior no longer depends on the received payload.
• Simplified dynamic queries. Perform dynamic queries basically the same way as static queries.
• Insert and update operations using DataWeave transformations. You can construct the datasets that insert or update the database without message side effects. You no longer use message enrichers.
• Simplified streaming. The new Mule streaming framework is automatically configured for your operations. You can execute a select statement and process the results asynchronously without worrying about leaking connections.