OneAnalytics Integration

OneAnalytics downloads OnePlan data into a Microsoft SQL Server database (on-premises or cloud-based) and takes snapshots of data for trend reporting.

  • OneAnalytics to OnePlan Integration

    OneAnalytics enables advanced reporting and analysis by storing OnePlan data in a Microsoft SQL Server database. It allows users to create historical snapshots, build custom dashboards, and perform trend analysis using to...

  • OneAnalytics (SQL Server) Integration - Integration Setup

    This article explains how to set up the OneAnalytics for OnePlan integration. This integration can be used to download data from OnePlan to MS SQL Server. Want to send data from SQL Server to OnePlan instead? There's a s...

  • OneAnalytics Integration - Default Field Mappings and Scheduled Strategies

    This article describes the default field mappings and scheduled strategies that are set up when the OneAnalytics integration is installed. Warning Please be advised that if you want to use both the OnePlan_to_SQL_OneAna...

  • OneAnalytics Integration - Snapshots

    This article explains how snapshots function in the OneAnalytics integration. Snapshot Frequency Snapshots can be taken up to once a day. Snapshot Data Options OData Table Names Snapshots can be done for tables...

  • OnePlan OneAnalytics - Recommendations and Best Practices

    Recommended Suggestions If Using Backups and Snapshots Please be advised that if anyone wishes to use both the OnePlan_to_SQL_OneAnalytics and TakeOnePlanSnapshot strategies, we highly recommend that two separate integrat...