Integration of analytical tools with Pirani

Pirani now connects with leading analytical tools for a more strategic risk management. At Pirani, we know that data analysis is key to making better decisions

That's why we have integrated our platform with analytical tools such as Power BI, Tableau, Cogno, and Looker

Now, you can visualize and analyze risk information in a more agile and personalized way.

What does this mean for you?

• Better decisions, thanks to custom-designed reports and dashboards.

• Connected data is achieved by integrating Pirani's information with financial systems, accounting systems, and more.

• Less manual work because you no longer need to export data repeatedly.

• Total flexibility with cross-platform compatibility.

• Risk management should be aligned with the business to make strategies more effective.

This functionality will be available for Enterprise plans in ORM, ISMS, Compliance, AML, and Audit management systems. Thus, you can enhance risk management with deeper insights and more informed decisions.

How to integrate with Pirani?

To integrate with the Pirani software, click on the top left, on the dots next to the Pirani logo. A box will appear where you must click on the “Manage organization” section.

You will find several options to manage your organization on the right side. Now click on the option “system settings.”

 

⚡ This section will provide all the technical information needed to integrate Power BI and other analytical tools.

Once in the Private Applications section, you will find all the necessary information to perform your integration.

Click on the “Create private application” button.

 and complete the following steps:

Step 1: Basic Data

• Application name: Power BI Connection
• Description: Specify the purpose of the integration, e.g. “Extraction of events for dashboards in Power BI”.
  
  Then click the “Next” button to continue with the configuration.

In Step 2, you will be asked if you want to do a generic or analytical integration. Select analytics and click “Next” to continue.

Next, you must choose the analytical tool you want to connect: Power BI, Qlik or a generic one. Then select the corresponding option and click on the “Create” button.

Once you click on the “Create” button, the manual will be displayed with all the necessary instructions to correctly perform the integration step by step.

Access token:

A unique key authenticates and authorizes the connection between Pirani and analytical tools such as Power BI. Thanks to this digital key, the integration is secure, ensuring only authorized users can access and use the data.

API URL

To use the API URL in the integration with tools such as Power BI, it is necessary to replace <Module name> with the specific module to be connected.

For example, in Pirani, several modules, such as controls, risks, and processes, represent different sources of information. 

To obtain data from a particular module, simply replace <Module name> in the URL with the corresponding name of the entity.

Example:

If we want to extract information from the risk module, the URL would look like this:

➡️ https://api.pirani.co/prod/services/appclients/data-extraction/v1/resource/RISKS

In this way, each integration can be customized according to the data that needs to be connected and analyzed.

📌 To facilitate this process, we will provide a table with the names of each entity so that you can quickly identify how to build the URL according to the module you want to integrate.

Use the header:

The header (HEADERS) in an API request defines additional information that the system needs to process the request. In this case, a key header is required:

1. X-PIRANI-APIKEY: ${APIKEY}

• The authentication token validates that the user has permission to access the API.
• ${APIKEY} must be replaced with the access key generated in Pirani, ensuring a secure connection.

This header is essential for the API to recognize the request and allow data extraction in a secure and structured way.

Once we have the necessary information to integrate Pirani services into your applications, the next step is to access Power BI or other analytical tools you use to integrate Pirani data.

Within Power BI, click “Get data” and select “Web”. Next, a window will appear, and you must choose the “Advanced Usage” option.

Then, in the "URL Parts" field, enter the following API URL:

https://api.pirani.co/prod/services/appclients/data-extraction/v1/resource/RISKS

Remember that each module requires a separate integration, as mentioned above.

In the HTTP request header parameters, enter “X-PIRANI-APIKEY” and then the Access Token. Once this step is completed, click "OK".