OverviewThe CData Tableau Connector for UPS maintains locally stored entities as relational tables. Many of these tables are used to populate needed input details for the use of the provider's stored procedures. After execution, some stored procedures populate a history table with the generated results. These results can then be queried for later reference. Both Tables and Stored Procedures are defined in schema files, which are simple, text-based configuration files.
- Tables and are statically defined to model senders, shipments, and packages used by the stored procedures for UPS. Any API limitations and requirements for inserting these entities, are documented under Tables.
- Stored procedures allow you to execute operations to UPS, including creating labels and scheduling pickups. These take data from the tables as input.
- The entities are stored in a database defined by your CacheLocation or alternatively the CacheConnection and CacheProvider connection properties.