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_OneAnalytics and TakeOnePlanSnapshot strategies, we highly recommend that two separate integrations be made. Both strategies use the OData Table Name field, so if there are different tables that are to be snapshotted, this can cause unnecessary tables to be created for the client.

Default Field Mappings

There are no default field mappings for this integration. Some system fields will be brought over into SQL automatically. If you specify a list of fields using the mapping for the Plan type of entities, then only those (beyond the system fields) will be downloaded.

Default Scheduled Strategies

OnePlan_to_SQL_OneAnalytics

This strategy enables a comprehensive synchronization of data from OnePlan to SQL Server. During each execution, it initiates a process where all existing data in SQL is dropped, and the tables are entirely rebuilt based on the complete set of OData fields from OnePlan.

Optional Strategies

TakeOnePlanSnapshot

This strategy captures a daily snapshot of OnePlan OData tables, transferring them to SQL Server.

While many tables are available for snapshot, only tables listed in the OnePlan OData Table Names (comma separated) configuration setting will be snapshotted.

It’s noteworthy that configuration options are available for the fields to be captured. This configuration can be done within the Columns to Snapshot and the Choice Column for Time Tracking fields. This strategy will generate a table within SQL with this naming structure: OnePlan_Snapshot_{TableName}.

OnePlan Stable OData Table Names

Here are the Out of the Box (OOTB) OData table names that are available in OnePlan:

Activities	ModelerScenario	ResPlan
Assignments	ModelerScenarioPlan	ResPlanLog
Association	PlanDependency	StatusReports
Capacity	PlanInsights	Tasks
Costs	Plans	Teams
Enterprise Teams	PlanProcessSteps	TimeOff
Enterprise Team Members	ProcessSteps	TimesheetAudit
ModelerModel	Resources	Timesheets

Custom/Variable Table Names

As OnePlan evolves to meet the needs of each customer, new tables will be created for the OData feed.

Plan_”TableName” can change depending on the configuration of your Plan Types. For each new Plan Type you configure, a new “Plan_TableName” table will be created.

Here are some common plan names in OnePlan and how their OData table name will look if using one of our pre-existing templates.

Plan_Epic	Plan_Objective	Plan_Project
Plan_Idea	Plan_Portfolio	Plan_Project_Epic
Plan_KeyResult	Plan_Program

For more information on OnePlan OData tables, please see OData Table Dictionary.