database-connector-examples.adoc

Database Connector Examples - Mule 4

Anypoint Connector for Database (Database Connector) examples help you configure database connections, query a database, execute stored procedures, execute DDL statements, execute scripts, execute database transactions, use bulk operations, and configure custom data types:

• Configure a Database Connection
  Connect to both popular and generic database. Additionally, configure the connector to connect to a global data source, set a JDBC driver, configure connection pooling, and connection to an Oracle database with TNS.

• Configure an Oracle TLS Database Connection
  Connect to Oracle through a secure TPC (TCPS) tunnel using multiple secure Oracle connection levels and Mule’s TLS configuration.

• Configure Driver Visibility using Mule Maven Plugin
  Use the Mule Maven Plugin to configure properly the driver classes visibility.

• Query a Database
  Configure the Select operation to query data from a database.

• Query a Single Record from a Database
  Configure the Query single operation in a Mule application that retrieves books information from a table in a MySQL database.

• Insert, Update, and Delete Data
  Configure the Insert, Update and Delete operations to manage data.

• Bulk Insert, Bulk Update, and Bulk Delete Data from a Database
  Configure the Bulk insert, Bulk update, and Bulk delete operations to manage date in bulk.

• Execute Stored Procedures
  Configure the Stored Procedure operation to combine input, output, and input-output parameters. Additionally, configure dates on stored procedures.

• Call an Oracle Stored Procedure That Uses UDTs
  Configure the Stored procedure operation to call an Oracle database stored procedure that uses UDTs for its input and output parameters. Additionally, use prepareStruct and prepareArray DataWeave functions to map application data to your custom types.

• Execute DDL Statements
  Configure the Execute DDL operation to execute DDL statements that create or modify data within tables or other data structures.

• Execute Scripts
  Configure the Execute Script operation to execute a script as a single statement.

• Configure Database Data Types
  Configure custom data types to use when connected to a particular connection provider.

• Configure Database Transactions
  Execute database operations in the context of a transaction.

• Insert large file content into a table
  Configure a Mule app flow to read and insert a large file into a table.

• Using XA Transactions in Database Connector
  Configure the Use XA Transactions field in the Database Connector global configuration so the datasource supports Extended Architecture Transactions (XA Transactions).

• Configure Use Bulk Copy for Database Connector SQL Server Connection
  Configure the Use Bulk Copy to do bulk copy operations when executing batch insert operations.

• Configure Azure Active Directory Authentication for MS SQL Server
  Configure Azure Active Directory Authentication for MS SQL Server using the Database Connector via the IntegratedSecurity parameter.

• Configuring Input and Output Parameters for Stored Procedures
  Configure input or output parameters for the Stored procedure operation of Anypoint Connector for Database (Database Connector) to specify the parameters that a stored procedure uses.

See Also

MuleSoft Help Center