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

How did we do?