Using the Connector (Mule 4.0+)
The CData MuleSoft Connector for UPS is a native, operation-based connector that exposes SQL-based operations as well as interfaces for schema discovery. The following operations are available in the UPS:
- List tables
- List columns
- Stored procedure
Each operation allows you to specify a separate connection configuration, SQL query, and input parameters. See Parameterized Queries for more information on parameterized queries.
Defining Custom Views
The connector allows you to define virtual tables whose contents are decided by a pre-configured query. See Defining Custom Views for an overview of creating and configuring custom views.