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.
There are no default field mappings for this integration. All fields will be brought over into SQL automatically.
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.
TakeOnePlanSnapshot
This strategy captures a daily snapshot of OnePlan OData tables, transferring them to SQL Server. It’s noteworthy that customization options are available for the fields to be captured. This customization 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 OData Table Names
Here are the Out of the Box (OOTB) OData table names that are available in OnePlan:
|
Activities |
Plan_KeyResult |
ResPlan |
|
Assignments |
Plan_Objective |
ResPlanLog |
|
Association |
Plan_Portfolio |
Resources |
|
Capacity |
Plan_Program |
StatusReports |
|
Costs |
Plan_Project |
Tasks |
|
ModelerModel |
PlanDependency |
Teams |
|
ModelerScenarioPlan |
PlanInsights |
TimeOff |
|
Plan_Epic |
Plans |
TimesheetAudit |
|
Plan_Idea |
RateTable |
Timesheet |
Custom 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.
For more information on OnePlan OData tables, please see OData Table Dictionary.