Configuring 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 > Administration > Configuration Tasks.
2. Click Cloud Services under Data Integration Configuration.
3. On the Cloud Services page, click Integration Service.
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 and a name of your choice to identify the process.
12. Select the source vendor, Boomi, (where your data is stored) for the Data Source field.
13. 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 and need to identify each (Subsidiary A or B). 
    1. Enter a name for the custom parameter and provide a label. Note that these two fields can be the same.
    2. 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. 
    3. By selecting the Required checkbox, users executing the process will be required to provide an input value for the parameter. If the Required checkbox is not selected, users have the option of completing the parameter when executing the process.
    4. Click Add more to add additional custom parameters.
    5. Click Done.
       Once complete, the number of parameters added (required or not) will display on the Configure Process page - Custom Parameters field.
14. Click Done.

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 > Data Integration > 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, and 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. Navigate to Maintenance > Administration > User & Role Management.
2. Click the Navigation Role tab.
3. Select the Navigation Role that you want to provide navigation access and click Navigation Access.
4. Select the Integration Services checkbox and click Save.

Editing, Deleting and Copying Integration Service Processes

You can copy, edit or delete the configured processes (in addition to adding new processes). You can also select to add another configured process. If you copy a process, you can then edit it as needed.

In Practice: How to Copy an Integration Service Process

1. Navigate to Maintenance > Administration > Configuration Tasks.
2. On the Configuration Task page (under Data Integration Configuration), click Cloud Services.
3. On the Cloud Services page, select Integration Service.
4. Select the three vertical dots for a process and select Duplicate.
5. The Duplicate Process screen appears. The name of the process is the same name of the selected process you are copying, but it is preceded with “Copy of ”. You can keep this name or rename the process. 
6. Click Save.