Integration Services

The Data Integration Services feature allows you to manage the Integration Process with Boomi from within the Planful application. Execute an Integration Process on-demand from Planful without needing to intricately understand Boomi, and, without the help of an IT professional.

Use the Integration Service to execute a custom Integration Process to load metadata, summary data, transactions data and operational data to Planful. This feature provides complete visibility into the type of data source and the data that is being loaded to the application and has full auditing capabilities as well as detailed status of each integration process.

First, you will need to configure the Integration Service on the Configuration Tasks - Cloud Services page and then you’ll configure the process for execution on the Integration Service page under Data Integration (DLR). Admins are required to provide navigation access to users who will need to access the Integration Service page. The steps below walk you through the setup and execution. There are three tasks you will need to perform, which are:

• Complete the Integration Services Configuration Task
• Optional - Customize Integration Service Processes
• Provide Navigation Access to the Integration Services Application Page

Once the Integration Service is configured, you can add integration services. To learn more about adding integration services, click here.

Completing the Integration Services Configuration Task

Setup the parameters for the integration as well as authentication information.

In Practice

1. Navigate to Maintenance > Admin > Configuration Tasks.

2. Open the Data Integration Configuration - Cloud Services task.

3. On the Cloud Services page, click the Integration Service task.

4. Enter the Account ID provided by Boomi.

5. Planful supports HTTP (RESTful) APIs that publish data in JSON format. Enter the request in the Rest API URL field.

6. Enter the username and password to authenticate the Rest API URL call.

7. Click Submit. The welcome screen appears.

8. Click Add. The Configure Process screen appears.

9. The Rest API URL is populated based on the URL you already entered during step 5. For Process Type , select the type of data you are loading. See examples in the screen below. For this example, Data - GL Data is selected.

10. Enter an Atom ID provided by Boomi. The Atom contains all the components required to execute your processes from end to end, including connectors, transformation rules, decision handling, and processing logic. This ID is provided by Boomi.

11. Enter an ID or your choice to identify the process.

12. Enter a name of your choice to identify the process.

13. Select the source vender, Boomi, (where your data is stored) for the Data Source field.

14. Enter a description of the process and click the Add button (optional) to launch the Custom Parameters page where you can set additional parameters. You might want to set additional parameters when you want to load data from different subsidiaries, for example, and need to identify each (Subsidiary A or B). Enter a name for the custom parameter and provide a label. Note that these two fields can be the same.

15. For Input Type, select to present the user with a textbox or a dropdown list box. If you select Dropdown, you will be prompted to enter selectable options. Select the Required checkbox as shown below. By selecting Required, users executing the process will be required to provide an input value for the parameter.

16. DO NOT select the Required checkbox as shown below. When you do not select Required, users have the option of completing the parameter when executing the process.

17. Click Add more to add additional custom parameters or click Done. Once complete, the number of parameters added (required or not) will display on the Configure Process page - Custom Parameters field.

Working with Custom Parameters for Integration Service Processes

Once admin users have set up custom parameters (optional or required or both), users should follow the steps below to execute an Integration Services process.

In Practice

1. Navigate to Maintenance > DLR > Integration Services.

2. The Integration Service page is displayed. Select a process by name. Notice that the names in the Process Name list-box are populated from the processes defined on the Integration Process page.

3. Select the Process Name, Loc (location), and Val (value). Note that the Loc field is required, but the Val field is optional. Required parameters are mandatory and the Integration Process will not execute without the parameter completed. Optional parameters are not required and it is up to the user as to whether the optional parameters are completed. If you execute the process without entering a value for the Loc field, the system will prevent it. 

4. Click Execute Process.

5. You can view all processes by clicking the History tab, selecting a process name and the dates for which it was executed.

Providing Navigation Access to the Integration Services Application Page

Provide a user with access to the Integration Services application page where the user can set up processes for execution (to load data).

In Practice

1. Access the Navigation Access page by navigating to Maintenance > Admin > User Management.

2. Click the Navigation Role tab and select the Navigation Access button to launch the Navigation Access page for a selected navigation role.

3. Select the Integration Services checkbox and click Save.