Create Integration Tasks
- Enable and set up Adaptive Planning Integration.
- Security:Data Designerpermission.
You can create tasks or predefined sets of actions to:
- Extract information from data sources and load it into Adaptive Planning.
- Build import processes and filters using loaders and other tasks.
- Combine various operations into a single contiguous operation.
- Share the tasks with others who can use them.
- Select from the main menu.
- ExpandTasksin theComponent Library.
- SelectCreate New Task.
- SelectIntegration Taskand
- Enter a meaningful name describing what the task does.
- SelectCreate.
- (Optional) SelectRefresh Data Source After Each Loaderto automatically refresh the staging table after each loader execution in the task.We refresh the staging table whether the task is ordered or unordered.
- Select aLog Level:
- Error: Only logs serious errors.
- Info: Logs all basic information, such as when the data source was updated.
- Verbose: Provides detailed information about all phases and actions. This level is primarily for debugging or auditing because it might produce more log information than is practical for typical use.
- SelectSave.
- Drag an hourly, daily, weekly, or monthly schedule item fromData Componentsto theSchedule Settingstable.
- Complete theSchedulefields:
Option Bezeichnung NameEnter the name for the schedule.RunSelect the frequency from the drop-down. Frequencies other than the default change the other fields accordingly.Schedule informationDepending on the schedule frequency, we display different schedule options:- Hourly: Lets you select the minute of the hour using a slider bar.
- Weekly: Lets you select the day or days you want to run the task and the time.
- Monthly: Lets you select the day of the month and the time of day.
Time ZoneSelect the time zone of the time to run the task.Local TimeDisplay-only for reference.ActiveUses this schedule information to run the task. If this check box is cleared, the schedule saves in theData Components, but the task doesn't schedule. Add multiple schedules to a task for multiple scheduling scenarios. Only 1 schedule can be active at a time.Run as meView only. - SelectSave.
- Drag loaders and tasks fromData Componentsto theTasks and Loaderstable:
- Add loaders to extract data, perform data manipulation, and load the information into Adaptive Planning.
- Add other tasks to create smaller subtasks as building blocks that combine into larger tasks. When you use subtasks in larger tasks, you can run the same operations in a different order depending on the time of day or month.
When Integration runs a task, it takes a collection of loaders and tasks and builds a single list of loaders. After Integration builds the list, it refreshes all needed data sources. The loaders then execute in these groups, in this order:- Planning metadata loaders. Example: Planning Dimension Loaders.
- Planning Data Loaders.
- Scripted Loaders.
- Custom Cloud Loaders.
- SelectSave.