Data Warehousing

HirePOS Data Warehousing lets you export selected business data as CSV files for use with external reporting, business intelligence and data warehouse solutions.

Exports can be refreshed manually or automatically each night.

Before you begin: External data access must be provisioned by HirePOS. For technical connection requirements, see Data Warehousing Integration Setup.

Navigate to Setup > Preferences > API / Integrations > Data Warehousing.

From here, you can enable data feeds, request manual exports and configure automatic nightly updates.

The following data feeds are available:

• Sales by Date

• Hire Item Utilisation

• Sales by Month Item Summary

Each feed produces CSV files covering complete calendar months.

Turn on Enable Data Warehousing to activate the feature.

Use the Enabled switch beside each data feed to select which exports you want available.

For each enabled feed, you can:

• Select Refresh Now to generate an export using the latest available data.

• Turn on Nightly to refresh exports automatically.

Select Refresh All Data Feeds to refresh all enabled feeds.

Select Refresh Now beside an enabled data feed to queue an export.

Refreshing regenerates the same calendar month's data using the latest available information and replaces the existing CSV.

The page displays the latest export information, including completion time, row count and processing status.

Enable Nightly for any feed you want refreshed automatically.

Nightly processing begins after 12:05am Queensland time, refreshing:

• The current calendar month

• The previous calendar month

Each eligible monthly export is processed once per day.

This ensures recently added or updated transactions are reflected in the exported data.

Each CSV represents one complete calendar month, from the beginning of the first day through to the end of the final day.

Refreshing an existing month replaces its previous CSV file rather than creating a duplicate. File names remain consistent, allowing external integrations to retrieve updated data from the same location.

To stop exporting a feed, turn off its Enabled switch.

To allow manual exports without nightly updates, leave Enabled on and turn off Nightly.

You can also turn off Enable Data Warehousing to disable the feature's controls.

If an export fails, its status changes to Failed. Other queued exports may continue processing.

If Data Warehousing is unavailable or exports repeatedly fail, contact HirePOS Support.

For external authentication, access permissions and connection troubleshooting, see the Data Warehousing Integration Setup guide.