Anypoint Exchange

Home to the complete listing of connectors, templates, examples and APIs.
Discover and use proven assets built by the MuleSoft ecosystem, or add assets to a private
tenant of Anypoint Exchange for collaboration and sharing of internal best practices.

Learn more
Sign up
Database Connector - Mule 4

Database Connector - Mule 4

β˜…
β˜…
β˜…
β˜…
β˜…
(2 reviews)

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

Reviews

Download
Log into Anypoint Platform to download this asset
Dependency Snippets

Overview

Type
Connector
Created by
MO
MuleSoft Organization
Published onFeb 21, 2018

Versions

VersionRuntime version
1.3.34.1.0
1.3.24.1.0
1.3.14.1.0
1.3.04.1.0
Show more