What is the EDW?
The External Data Warehouse (EDW) is a SQL Server database hosted on Azure Cloud that gives you direct, self-service access to your Betterview platform data. The EDW is designed to reduce dependency on Customer Success Managers for routine data requests, and to complement existing API functionality by exposing property data in a flexible format that can be queried easily. For a list of frequently asked questions, see this article.
What you can do with the EDW
The EDW supports a range of reporting and integration use cases:
- Ad hoc reporting - Run custom SQL queries against your property data on demand.
- BI tool connectivity - Connect directly to tools like Tableau, Power BI, and other analytics platforms.
- Enterprise data warehouse integration - Add Betterview data to your existing internal data warehouse.
- Self-service analytics - Build and maintain your own dashboards without engaging Nearmap support.
- API supplementation - Surface data with minimal custom programming alongside existing API integrations.
Data Structure
Data in the EDW follows a hierarchical relational model:
PROPERTY → BUILDINGS → DETECTIONS
Each layer represents a relational table in the database. The full table structure and field definitions are documented in the Betterview Data Warehouse Data Dictionary (attached as a downloadable file below).
Connecting to the EDW
You can connect to the EDW with the following details:
Field | Value |
|---|
Server Name | Provided by Nearmap |
Database Name | Provided by Nearmap - must be explicit in the connection string |
User Name | Unique to you, provided by Nearmap |
Password | Unique to you, provided by Nearmap |
Access to the EDW is restricted by IP allowlist. You must provide up to five IP ranges (preferably VPN or office networks) to be whitelisted before connecting.
If you run into any issues while connecting to the EDW, refer to the troubleshooting article for more information.
Data Refresh
The EDW is refreshed nightly, based on all transactions completed within 24 hours of midnight UTC. Refreshed data is reliably available from:
Any batch orders submitted after 3:00 PM local time will be included in the following night's EDW load.
Example visualizations
Given below are a couple of example visualizations to give you an idea of the dashboards you can build with the data in EDW and your BI/analytics platform.
