The add-in models the Travel/Itinerary API and the Expense API as a relational database, enabling access to Tables and Views like Reports, Entries, and Attendees. Stored Procedures are function-like interfaces to the data source. They can be used to search, update, and modify information in the data source -- for example, CancelTrip.

Customizing Schemas

The database objects are defined in schema files, which are simple, text-based configuration files that make schemas easy to customize and extend.

By default the schemas are located in the db subfolder of the installation directory. Set the Location to use a different folder. Call the CreateSchema stored procedure to save a schema file.

Using Query Processing

The add-in offloads as much of the SELECT statement processing as possible to the SAP Concur APIs and then processes the rest of the query within the add-in. The following sections document API limitations and requirements.