Tuesday, October 17, 2017

The New Database Connector in Mule 4

DZone Database Zone
The New Database Connector in Mule 4
The New Database Connector in Mule 4

There's a brand new Mule 4 Anypoint Connector for Database (DB) that you can use to connect to any relational database engine. Unlike other connectors such as File or FTP, this connector has a pretty similar UX compared to the one in Mule 3.x, with some considerable improvements, including:

Improved operations: Operations are streamlined and now simpler to use. We've extracted bulk functionality to their own set of operations so that you no longer have operations that change behaviors depending on the received payload. Dynamic queries simplified: There's now a single experience for executing static and dynamic queries. Embeddable transformations: You can now embed DataWeave transformations inside the insert/update operations so that you can construct the datasets you want to send to the DB without having a side effect on the message or using enrichers. Streaming simplified: You no longer have to worry about configuring streaming on your operations. The connector will use Mule's new streaming framework to handle that automatically. You can now even execute a select statement and process the results asynchronously without worrying about leaking connections!

Let's take a quick tour and see what's new.

No comments:

Fun With SQL: Functions in Postgres

DZone Database Zone Fun With SQL: Functions in Postgres In our previous  Fun with SQL  post on the  Citus Data  blog, we covered w...