This article describes the default field mappings and scheduled strategies that are set up when the OneAnalytics integration is installed.
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 allows you to sync data from OnePlan to SQL Server for OneAnalytics.
TakeOnePlanSnapshot: This strategy takes a snapshot of OnePlan OData tables to SQL Server for OneAnalytics.
For more information on OnePlan OData tables, please see OData Table Dictionary.