CData MuleSoft Connector for Excel Services
The CData MuleSoft Connector for Excel Services connects Excel Services to Mule applications with familiar SQL queries. The connector abstracts the underlying data source into tables, views, and stored procedures that can be used to both retrieve and update data.
- Real-time access to Excel Services data in Mule applications.
- Easily create Mule applications to backup, transform, report, and analyze Excel Services data.
Getting Started explains how to establish a connection to Excel Services and add the connector to your message flows.
Using the Connector (Mule 3.8+)Using the Connector (Mule 3.8+) shows how to invoke the connector's operations to execute SQL.
See SQL Compliance for a syntax reference and code examples outlining the supported SQL.
An important feature of the connector is the ability to easily cache data locally. This allows the connector to be used in an offline mode when access to the data source is not possible. See Caching Data for more details on this feature.
Data Model lists the tables, views, and stored procedures available for the connector.