Database Connector

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 operationsFor example, bulk insert, update, and delete are now separate operations. A bulk operation behavior no longer depends on the received payload.
  • Simplified dynamic queriesYou perform dynamic queries basically the same way as static queries.
  • Insert and update operations using DataWeave transformationsYou can construct the datasets that insert or update the database without message side effects. You no longer use message enrichers.
  • Simplified streamingThe 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.



Created By
Published On
Aug 12, 2017