ストアドプロシージャ
ストアドプロシージャはファンクションライクなインターフェースで、SAP SuccessFactors の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらず本製品 の機能を拡張します。
ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにSAP SuccessFactors から関連するレスポンスデータを返します。
CData Excel Add-In for SAP SuccessFactors ストアドプロシージャ
| Name | Description |
| CreateAssociation | Creates an association between two entities based on a navigation property. |
| CreateSchema | Creates a schema file for the specified table or view. |
| GetOAuthAccessToken | Gets an authentication token from SAP SuccessFactors. |
| GetOAuthAuthorizationURL | Gets the authorization URL for the specified Identity Provider. 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 the Authentication Provider. |
| ListAssociations | Lists associations for a given table and navigation property. |
| ListNavigationProperties | Lists navigation properties for a given table and the tables they are associated with. Navigation properties are used by the Association stored procedures. |
| RefreshOAuthAccessToken | Refreshes the OAuth access token used for authentication with the specified Identity Provider. |
| RemoveAssociation | Removes an association between two entities based on a navigation property. |