You can use Adaptive Insights as a data source to import metadata and data from your current Adaptive Insights instance, or another instance. When you set up a Planning data source, you need to create an Adaptive Insights credential. The Adaptive Insights credential lets you reuse authentication details with more Adaptive Insights data sources or loaders.
Watch the video: 3m 16s
Before You Begin
- Create an Adaptive Insights Data Source Credential
- Verify that the Adaptive Insights credential you select for this data source has the permissions and dimensional access for the metadata and data you need.
- Permissions required: Integration > Data Designer and Integration Operator
How You Get There
Go to nav menu > Integration > Design Integrations.
- Create an Adaptive Insights credential.
- Create a Planning data source.
- Select the Adaptive Insights sources, such as sheets, dimensions, levels, accounts, attributes, time periods, and versions to import.
- Import the Adaptive Insights structure from the sheets or accounts.
- Import the Adaptive Insights data from staging tables.
- Automate Adaptive Insights imports using an integration task.
Create an Adaptive Insights Credential
Follow the steps to Create an Adaptive Insights Data Source Credential.
If your instance is Workday-enabled and you synchronized users from Workday to Adaptive Insights, you must select a Workday Credential for your Planning data source.
Create a Planning Data Source
- Expand Data Sources in the Component Library and select Create New Data Source.
- Select Planning Data Source.
- Enter a unique name for the data source and select Apply.
- Select an existing Adaptive Insights credential. If one doesn't exist, create it using the steps described earlier.
You can select a Workday Credential if the Adaptive Insights users synchronized from Workday.
- Save the data source settings.
- Select Test Connection to verify your credential settings work.
Select Adaptive Insights Sources to Import
The Adaptive Insights data source only imports from the sources you select.
- Select the Planning Data Source you just created in the Component Library if it isn't already selected.
- Select Manage Sources in the Actions pane.
- Select the Sources folder in the Manage Sources dialog.
- Select Add beneath the Sources folder, or right-click on the Sources folder and select Add to select a:
- Folder to create a container for organizing your sources
- Account source
- Attribute source
- Cube Sheet and its levels, version parameter, and period range
- Level source
- Modeled Sheet and its level and version parameter, and optional period parameter
- Custom source from your selection of dimensions, account, levels, version, and period range from anywhere in your instance. See the Create Parameters for Filters in Custom Sources section for more information.
- Time source
- Version source
- Give the source a name indicating how you will use it and select Apply. For example, if this source contains an expense sheet for 2019, you could name it "expense sheet 2019"
- Repeat these steps to add all of the Adaptive Insights sheets and model elements you want to import. Each source becomes a separate table in the staging area.
- Select Save in the Actions Pane.
Create Parameters For Filters in Custom Sources
When you create a Custom Source you select parameters for the Account, Level, Version, and Period Range in the Adaptive Insights instance your credentials connect to. You need to create parameters before you can select them. Remember, these parameters relate to what you can select on the external Adaptive Insights instance.
The word External you see when you create these parameters reminds you that you are creating them for an external Adaptive Insights instance.
- Select Edit Parameters in the Settings tab for the Custom Source.
- Right-click the Local folder and select Add in the Edit Parameters dialog.
- Select External Version to choose the version you want to use.
- Select External Level Single to choose a single level.
- Select External Level Multiple if you want to choose more than one level.
- Select External Account to choose the accounts you want to use.
- Select Period Range to configure a fixed or dynamic period range.
- Give your parameters names that let you understand their use.
- Select Apply.
With local parameters created, you can now select them for the Account, Level, Version and Period Range filters in the Custom Source.
Import Structure From Adaptive Insights Sources
After you select the Adaptive Insights sheets and model elements to import, import their structure before importing their data.
- Select Import Structure and view the import progress.
- Close the Import Structure dialog.
- View the Data Components for the tables and columns you imported. All of the sources you chose from Manage Sources also automatically appear in the staging area so you can preview the data they contain.
- Save the data source.
Customize Table Settings
You can customize how data from each Adaptive Insights table imports.
- Select the triangle next to the table name in the Staging Area.
- Select Table Settings.
- Change the settings. What you can choose varies depending on the table columns.
- Data Import Mode:
- All records replaced each time a data import is run
- All received rows are new and so should be added
- All records that fall within a period range transmitted (available only if a source sheet contains a Timespan)
Page Cube Sheet Data by Time Strata
If you set a period parameter you can page cube sheet import data by the time strata that appear in that cube sheet. For example, you can select from Year, Month, or Quarter if those time strata exist for the sheet. Paging breaks apart the import request by time strata, making large cube sheet imports more efficient. The import progress indicates the status of each page load.
Import Data From Adaptive Insights
Once the Adaptive Insights sheet and model element structures import, you can import their data.
- Drag any additional Adaptive Insights tables you might want from the Data Components area into the Staging Area
- Select Import Data in the Actions Pane. The data gets processed by your import filters and parameters.
- Provide any needed values for parameter prompts that appear at run-time.
- View the import progress for any import errors or messages.
- Review the data in the Staging Area. Imported data remains there until you clear it by selecting Clear staging tables in the Actions pane.
After you import ot the staging tables, you can load from staging into Adaptive Insights with a loader.
Reimporting Dimension Values After Deleting One in the Dimension Admin
If you reimport dimension values after deleting one in the Dimension Admin, a row for the deleted dimension value appears in the staging area. The row contains a hidden isDeleted column set to True in the staging table preview.
To get rid of this row, clear your staging table and reload it.
Automate Imports Using an Integration Task
With a data source set up, you can create an Integration Task that runs this loader on a schedule automatically.
Best Practice: Have separate Integration tasks for each loader.
If a task contains multiple loaders, parameters from each loader display in a prompt when the task runs. If there is a common or shared parameter in the loaders within a task, the task prompts for the parameter only once. You can choose to override parameter prompts.
For scheduled runs of the task, default values of the parameters are used.