Extract
Extraction is the process by which Unified Scriptable Extractor (USE) retrieves data from external locations. The following types of data source are supported:| Type | Description |
|---|---|
| APIs | CloudCheckr FinanceManager retrieves usage data from the cloud API or APIs for the reports you want to generate. This is usually a REST API accessed via HTTPS. |
| Files | A file on the local file system or on a shared volume. This is usually a CSV, JSON, or XML file. |
| CloudCheckr FinanceManager | In some cases, it is useful to retrieve information from CloudCheckr FinanceManager, so you can incorporate accounts and usage data, which were created historically, into the daily processing. |
| Database | You can execute arbitrary SQL queries against an SQL server either via a direct connection string or via an ODBC DSN. |
| Web | You can invoke arbitrary HTTP queries to retrieve information from any web page accessible from the CloudCheckr FinanceManager server. |
USE Script
A USE script is required for USE to operate. Click the links to learn more:- script basics: an introductory overview of the scripting language
- language: a reference guide for the USE scripting language
- parslets: how to parse XML and JSON data
- templates: template scripts that can be used as starting points for common data sources
