Information
The Information schema contains objects that return metadata and administrative information about your Anaplan instance.
Views
The following Views are shipped with the connector:
| Name | Description |
| ExportMetadata | Retrieves detailed metadata for a specific export definition, including column names, data types, and row count estimates. |
| Exports | Retrieves information about export definitions within a model. |
| ExportTaskDetails | Retrieves detailed status for a specific export task, including progress, result, and failure information. |
| ExportTasks | Retrieves tasks for export definitions. |
| ModelFileChunks | Retrieves the chunks for a file. Use to download large files in parts. |
| ModelFiles | Retrieves import and export files for a model. Export files have fewer metadata properties than import files. |
| Models | Returns information about models in the user’s default tenant, showing all models for Workspace Administrators and only accessible models for other users. |
| Workspaces | Retrieves all workspaces a user has access to within the user's default tenant. |
Stored Procedures
The following Stored Procedures are shipped with the connector:
| Name | Description |
| CancelExport | Cancels an ongoing export task. |
| DeleteFile | Deletes the content of a file from Anaplan. This only removes private content. Default content and the import data source model object remain. |
| DownloadFile | Downloads a file. |
| DownloadFileChunk | Downloads a specific chunk of a file. |
| GetOAuthAccessToken | Fetches the OAuth Access Token, which is used to authenticate and authorize API calls made. |
| GetOAuthAuthorizationUrl | Retrieves the OAuth Authorization URL, allowing the client to direct the user's browser to the authorization server and initiate the OAuth process. |
| RefreshOAuthAccessToken | Refreshes an expired OAuth Access Token to maintain continuous authenticated access to resources without requiring reauthorization from the user. |
| StartExport | Initiates an Export Task based on an existing Export Definition. Returns a Task ID to monitor. |