01 · EXTRACT
Filtered & validated
We configure our ETL tool to pull filtered and validated data sets from your source systems.
Services · Integration
Connected to everything you run.
ETL (SSIS, Scribe), APIs, data uploaders and legacy data migration. We're happy to perform these ourselves — or train and empower your staff to adjust the integration configurations.
The pipeline
Extract. Transform. Load.
02 · TRANSFORM
Shaped to fit
Data-transformation packages conform your data to the structure and parameters of our system.
03 · LOAD
Workflows fire automatically
Data lands in the system and required workflows kick off automatically to prepare it for processing.
services · integration architecture
Integration services
Simple to complex.
APIs
We leverage Microsoft’s Dynamics and Power Platform to utilize their array of APIs.
Mobile Integration
We leverage the Microsoft Dynamics mobile app to provide out-of-the-box integration to the DSM tracking system.
Legacy Data Migration
We migrate data from existing/legacy software. We provide historical data migration services for a very wide range of programs. Data types include, Customer Data, Project Data, Measure Data, Financial Data, Program Data, Meter Data, and more.
Bulk Project Uploader
Some programs are tallied outside the system and just need the data to be uploaded. Your partners track their projects in their own software systems and just want to run an upload and have all the system automate everything. We provide services to configure your Upload programs to map into our system.
E T L
Extract. We configure our ETL tool to pull filtered and validated data sets.
Transform. We configure data-transformation packages to conform to the structure and parameters of our system.
Load. We load the data into our system, followed by automatic initiation of required workflows to prepare the data for further processing.
Power BI Integration
We design and implement custom reports to show if you are on track to reach your forecasted KPIs and Goals. Where desired, we configure these custom reports to be available and filterable on the Customer Portal and Partner Portal.
integrations · upload & automation
Ready when you are
Map your integrations.
Bring your list of systems — SAP, CIS, Oracle, legacy trackers — and we'll walk through how each one connects.