Database Connector - Mule 4 icon

Database Connector - Mule 4

β˜…β˜…β˜…β˜…β˜…
(4 reviews)
A Mule extension that provides functionality for connecting to Databases through the JDBC standard

home

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.

Reviews

Log into Anypoint Platform to download this asset
Dependency Snippets
Opens dependency snippets modal
TypeConnector
OrganizationMuleSoft
Created byMuleSoft Organization
Published onSep 24, 2019
Asset overview

Versions

StatusVersionRuntime version
Go to version 1.5.54.1.1
Go to version 1.5.44.1.1
Go to version 1.5.34.1.1
Go to version 1.5.24.1.1

Categories

Functions
DatabaseNo values left to add
Level
SelectNo values left to add

Tags