Database Connector - Get Started - Mule 4
Support Category: Select
Database Connector Version 1.5.4
The Database connector establishes communication between your Mule app and a relational database.
After adding the connector to Studio, the connector and its operations appear in the Mule Palette.
Anypoint connectors are Mule runtime engine extensions that enable you to connect to APIs and resources on external systems, such as Salesforce, Database, ServiceNow, and Twitter.
Before creating an app, you must have access to the Database target resource and Anypoint Platform. You must also understand how to create a Mule app using Design Center or Anypoint Studio.
The Database Connector provides specialized support for the following database:
Microsoft SQL Server
You can set up other JDBC databases using a generic JDBC configuration. You can also reference a JDBC
DataSource object or a
XADataSource object, which is required for XA transactions. You typically create the object in Studio using Spring.
The Database connector provides a listener to read from a database in the Source section of a flow. You can execute other operations which also allow you to read and write to a database anywhere in the Process section. For example, instead of writing single records to a database, bulk operations allow you to modify a collection of records by simply supplying the SQL to modify each record. Other operations allow you to carry out Data Definition Language (DDL) operations, to execute stored procedures, or to execute entire SQL scripts at once.
Anypoint Exchange provides templates you can use as a starting point for your app, as well as examples that illustrate a complete solution.