A Custom Cloud Loader lets you export Adaptive Planning plan data directly to third-party cloud systems.
Watch the video: 3m 16s
- Enter data source settings.
- Define paremeters.
- Define business rules.
- Run or schedule the loader.
- Verify that you have the Integration Developer role permission.
- Verify that Adaptive Planning plan data you want to export already exists in a staging table.
- Know what parameters you need to pass to your external system, and what defaults the external system expects.
- Understand how to write to the external system's endpoint.
From the nav menu, go to Integration > Design Integrations
Enter Data Source Settings
The Data Source Settings let you choose the source table you want to use from your instance's staging data, determine what credentials to use, and the level of log detail to record during a loader run.
Create a new Custom Cloud Loader
- Access the Data Designer by going to Integration > Design Integrations.
- In the Loaders folder in the Component Library select Create New Loader.
- Select Custom Cloud Loader as the loader type and enter a name. If you don't see Custom Cloud Loader as an option, it is not enabled for this instance or you don't have the Integration Developer role permission needed to access it.
- Select Create.
Select the Source Table, Credential, and Log Level
- Enter the Custom Cloud Loader's information:
- Source Table: Select a staging table containing Adaptive Planning planning data you want to export.
- Require Credential: Select if the external system requires OAuth and you require a user with Integration Operator role permission to select the appropriate OAuth credential.
- Credential: Select a preexisting OAuth credential.
- Log Level: Select how much detail to log when the loader runs:
- Error: Only logs errors.
- Info: Logs all basic information, such as when the data source was updated.
- Verbose: Provides very detailed information about all phases and actions. Used primarily for debugging or auditing, as it may produce more log information than practical for typical use.
- Click Save in the actions menu.
- Select Designer Settings.
- Drag Parameterized or Static setting items from the Settings Component pane into Designer Settings.
- Parameterized setting values entered here become loader defaults if you don't provide another one at loader run time.
- Static settings you enter here get used every time the loader runs and don't require input at run time.
- Boolean: A value represented as one or zero.
- Dimension: A dimension from the dimension admin within Adaptive Planning.
- Integer: A non-negative whole number.
- Password: A password. This value cannot be viewed once it is saved.
- Period Range: A time period range from within Adaptive Planning.
- Text: An alphanumeric value.
- Double click a parameter item to enter a name and change its value.
- Save the loader.
- Select Script.
- Select the preexisting template and change it or select New Script to make your own.
- Verify the script includes the required:
testConnectionfunction to create an https request to post to your external system
exportDatafunction to export data from Adaptive Planning.
- Reference any parameters you created in the Designer Settings by their name.
- Save the script.
You can format and beautify a script in the editor using the keyboard shortcut Ctrl+B. Find and replace launches with Ctrl+H.
You can separate a long script into multiple files for easier maintenance. Example: You could contain all of your
testConnection logic in one script called
testconnectionscript. A second script, called
exportdatascript, could contain all of the
exportData logic. When the same function is declared in multiple scripts, the one from the most recently added script is used.
Use OAuth in Custom Cloud Loader Scripts
When you select Require Credential for a Custom Cloud Loader, your script must contain
See Authenticate with OAuth for how to create an OAuth Credential.
Those who run a Custom Cloud Loader referencing a Credential should:
- Select Request Authorization before running the loader.
- Provide any additional authorization details, such as scope, needed for the external system endpoint.
- Select Test Connection to verify the OAuth credentials passed successfully to the endpoint.
- Note the authorization date and user ID in the Authorization Status. Authorization expiration dates vary from one external system to another. Select Reset Authorization in the Actions pane to reauthorize when needed.
Define Business Rules
You can use Business Rules to create SQL expressions that limit the staging data that exports to the external system. Only records that meet your filter criteria will load.
The Business Rules tab contains a text area for entering SQL.
- Select the Business Rules tab.
- Select Edit.
- Enter an SQL expression. You can click an item in Available Columns to bring that column into the SQL expression instead of typing it.
- Select Apply to check your syntax. Errors turn the border around the expression red. Hover the expression to see syntax error information.
- Correct any errors in your syntax and select Apply. Only staging rows that match the SQL expression will load.
Include the Custom Cloud Loader in an Integration Task
Custom cloud loaders must be run as integration tasks. Any Integration task can contain one or more loaders. A task can also contain other integration tasks and loaders.
Best Practice: Have separate Integration tasks for each loader.
If a task contains multiple loaders, then parameters from each loader are presented when the task is run. If there is a common/shared parameter used in the loader(s) within a task, then the task only prompts for the parameter once. You can choose to override parameter prompts.
For scheduled runs of the task, the default values of the parameters stored when the loaders were created are used.