ストアドプロシージャ
ストアドプロシージャはファンクションライクなインターフェースで、SAP Concur の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらずconnector の機能を拡張します。
ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにSAP Concur から関連するレスポンスデータを返します。
CData Tableau Connector for SAP Concur ストアドプロシージャ
| Name | Description |
| CancelTrip | Cancel the specified trip. |
| CreateExceptionToReport | Posts an exception to the report and associates it with one of the following data levels: Report Header, Entry, Itemization, Allocation. |
| CreateSchema | Creates a schema file for the specified table or view. To connect to custom schemas, set Location to the path to the schema files. |
| CreateTripFromFile | Create a new trip from an XML file. |
| GetOAuthAccessToken | Gets the OAuth access token from Concur. |
| GetOAuthAuthorizationURL | Gets the Concur authorization URL. Access the URL returned in the output in a Web browser. This requests the access token that can be used as part of the connection string to Concur. |
| PostExpenseReportWorkFlowAction | Posts a workflow action for the supplied expense report. The workflow action moves the expense report through the workflow process. |
| RefreshOAuthAccessToken | Refreshes the OAuth access token used for authentication with Concur. |
| SubmitExpenseReport | Submits an expense report. |
| SubscribeToCompanyNotifications | Subscribe from the specified notification type, or all notifications. |
| UnsubscribeFromCompanyNotifications | Unsubscribe from the specified notification type, or all notifications. |
| UpdateTripFromFile | Use an XML file to update the specified trip. |
| UploadReceiptImage | Upload an image for a receipt. Note that the server does not support all image file formats and size restrictions might apply. |