MuleSoft Connector for EnterpriseDB

Build 21.0.7930

Using the Connector (Mule 3.8+)

The CData MuleSoft Connector for EnterpriseDB is a native, operation-based connector that exposes SQL-based operations as well as interfaces for schema discovery.

Invoking Data Manipulation Operations

Querying Data and Updating Data show how to execute SQL to EnterpriseDB tables.

Executing Parameterized and Dynamic Queries

You can use MEL (MuleSoft expression language) to create both parameterized queries and dynamic queries. The connector executes parameterized queries by default. See Parameterized Queries for configuration and usage of the different query types.

Batching Requests

With the connector's Batch Processing feature, you can use the Bulk Execute operation to combine multiple updates into a single EnterpriseDB request.

Calling Stored Procedures

Stored Procedures operations enable you to access additional functionality in the EnterpriseDB APIs.

Discovering Metadata

The connector's List operations provide access to table and column information. See Schema Discovery for more information.

You can also use query the System Tables to retrieve any of the connector metadata, which includes data source information and query statistics in addition to schema information.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930