Accruent Data Connect Introduction

Your organization can purchase Lucernex DataMart data delivered for reporting: to your own database (classic) or to Snowflake through Lucernex Data as a Service (DaaS).

Accruent Data Connect is the managed service that delivers Lucernex DataMart exports to Snowflake in a format designed for reporting and analytics. It replaces ad hoc exports and custom point integrations with a consistent pipeline that your BI and analytics tools can query.

Connect BI tools such as Power BI or Tableau to Snowflake.
Use curated datasets that refresh on a schedule instead of manual exports.
Keep analytics queries off production systems by running them in Snowflake.
Create a foundation for enterprise analytics and AI initiatives, based on your governance and tooling.

View data in Snowflake

Contact your Accruent representative for licensing information and Snowflake access credentials. Accruent provides the URL, username, and password you need to sign in.

Accruent-managed Snowflake (Reader account): If you do not use Snowflake today, Accruent can provide a Snowflake Reader account so you can access the shared Lucernex datasets.
Your Snowflake account (native data sharing): If you already use Snowflake, Accruent can share the Lucernex datasets directly into your Snowflake account by using Snowflake data sharing.

In the left navigation, select Catalog.
Expand the primary data share that matches your company name.

Connect Snowflake to BI tools

Your data team can connect Snowflake to BI and analytics tools. To do this, you need your Snowflake role and warehouse information.

Sign in to Snowflake.
In the left navigation, select your username.
Select Preferences.
In the Defaults section, locate the role and warehouse values.

How it works

Classic DataMart: DataMart writes to a customer-managed reporting database (for example, SQL Server).
Lucernex DaaS: DataMart outputs are delivered to Snowflake through Accruent Data Connect, and you connect your BI tools to Snowflake.

DataMart extracts and transforms data from Lucernex IWMS.
In DaaS mode, DataMart produces file-based exports (data plus schema artifacts).
Accruent Data Connect delivers the exports and loads them into Snowflake.
Your BI and analytics tools query Snowflake to build reports and dashboards.

DataMart

DataMart is Lucernex’s extract and transform engine for reporting and analytics. It retrieves data from Lucernex IWMS and structures it into analytics-ready entities (tables).

DataMart supports two delivery modes: classic delivery to a customer-managed database, or DaaS delivery to Snowflake through Accruent Data Connect.

Classic deployment: writes to a customer-managed database (for example, SQL Server).
File output mode: writes data and schema artifacts as files (for example, JSON). This enables cloud delivery.

Data as a Service (DaaS)

Lucernex DaaS is the cloud delivery option for Lucernex DataMart. DataMart extracts and transforms Lucernex IWMS data, and Accruent Data Connect delivers the output to Snowflake for reporting and analytics.

Accruent Data Connect

Accruent Data Connect is the managed delivery and ingestion service that delivers Lucernex DataMart exports to Snowflake and loads them into tables for reporting and analytics.

DataMart = extraction and transformation
Data Connect = managed delivery and ingestion
Snowflake = analytics data warehouse

Snowflake

Snowflake is a cloud data warehouse designed for analytics. You query Lucernex data in Snowflake by using BI tools such as Power BI or Tableau.

Cloud delivery using Accruent Data Connect and Snowflake

File-based DataMart output: DataMart can emit data and schema artifacts as files (for example, JSON).
Managed delivery to Snowflake: Accruent Data Connect delivers completed exports and loads them into Snowflake tables.
Refresh modes: supports both complete refresh and incremental (delta) updates.

If you use Lucernex DaaS, you consume DataMart outputs in Snowflake.

If you use classic DataMart, you keep your current database destination. No change is required.

Lucernex DaaS (Accruent Data Connect + Snowflake) is beneficial for:

A managed Snowflake destination for analytics
Less operational overhead (no customer-hosted reporting database)
A scalable platform for enterprise analytics and modern BI

Database and schema behavior differences (Classic vs DaaS/Snowflake)

Exact behavior can vary by environment and configuration. Validate against your Snowflake schemas during onboarding.

Feature	Data Connect + Snowflake (DaaS)	Classic DataMart (customer-managed DB)
Primary keys	May not be enforced as database constraints	Commonly created in the database
Foreign keys	May not be enforced as database constraints	Commonly created in the database
Delete handling	Soft delete indicators	Often hard deletes
Timestamp format	`2012-03-02T11:01:13.000+00:00` (ISO 8601)	`2012-03-02 11:01:13.000000` (SQL-style)
Extra ETL tracking columns	Common (for example: `HASH_VALUE`, `ISDELETEDFROMSOURCE`)	Not always present
Booleans	`TRUE` / `FALSE`	Often `0` / `1`
Empty tables	May not load empty tables	Often creates schema even for empty tables

Migration and reporting considerations

Update report logic to handle soft deletes.
Expect additional ETL tracking columns and adjust views accordingly.
Review timestamp parsing to support ISO 8601 timezones.
Validate case sensitivity and naming conventions in your BI semantic layer.

Your next steps

No action is required unless you are onboarding to Lucernex DaaS.
If you are migrating reports to Snowflake, validate your priority dashboards during a parallel run.

Support and enablement

To enable Lucernex DaaS or plan a reporting migration, contact Accruent Support and your Customer Success Manager.

FAQ

Does Accruent Data Connect replace DataMart?

No. DataMart extracts and transforms data. Accruent Data Connect delivers the DataMart output and loads it into Snowflake.

Can I run classic DataMart and Lucernex DaaS in parallel?

Yes. Many teams validate Snowflake results alongside existing reports before they switch their BI connections.