Using Search Data with Third-Party Reporting Tools
Use the Cherwell REST API to connect to third-party tools to retrieve data from CSM.
Use the Data Connector to pull data from a saved search. CSM can connect to Microsoft® Power BI® Desktop (version 2.64.5285.741 (18.11) (x64)) and Tableau Desktop (version 2018.3). You can use these products to visualize the data in different ways (reports, dashboards, charts, or graphs).
Configuring the REST API
To configure the REST API:
- In
CSM Administrator,
create a new API Client ID to automatically generate a Client Key. The Client
Key will be used to generate an access token for the REST API. You can also use
an existing Client ID.
You will need to copy the Client Key to be used as the Client ID when launching a third-party tool.
- In
CSM Administrator,
set the base URL for the REST API.
You will not be able to generate URLs for saved searches from the Search Manager until this step has been completed.
- Distribute the Client Key and base URL to CSM users who will be using a third-party tool.
Using Power BI and the Data Connector
You must have Microsoft Power BI installed. For complete details on installation, see https://docs.microsoft.com/en-us/power-bi/.
To use Power BI and the Data Connector:
- In the
CSM Desktop Client,
install the Power BI Data Connector. In the
CSM Browser Client,
download the Power BI Data Connector.
- From the CSM Desktop Client menu bar, select . This will copy the .mez file (the file type for the Power BI Data Connector) into the correct folder so it can be used without any further configuration.
- From the
CSM Browser Client
menu bar, select
. This will only download the
file to the user's machine. You must copy and add this file to the local path
([Documents]\Power BI Desktop\Custom Connectors) before it is recognized by
Power BI.
You will need to restart Power BI after this step.
For additional details on connector extensibility, see https://docs.microsoft.com/en-us/power-bi/desktop-connector-extensibility.
- Open Power BI.
- On the main menu bar, select .
- Select Security and under Data Extensions, select the Allow any extension to load without validation or warning option. Select OK.
- From the main toolbar, select the Get Data drop-down list, and then select More.
- Select the Other category, and then select Cherwell Data Connector. Select Connect.
- Enter the URL and Client ID (this is the Client Key from
Configuring the REST API above), and then select
OK.
If the base API URL was not set, the URL will need to be created manually.
- If prompted to sign in, select Sign in. Enter your CSM username and password. Alternatively, if SAML is enabled, enter your SAML credentials. Select Login.
- Select Connect.
Using Tableau and Web Data Connector
You must have Tableau installed. For complete details on installation, see https://www.tableau.com/support/help.
To use Tableau and Web Data Connector:
- Open Tableau.
- On the main toolbar select .
- Specify the path to the Cherwell Tableau Web Data Connector, which is available on your Cherwell REST API server (https://[servername]/CherwellAPI/DataConnector/Tableau) and then press Enter.
- Enter your CSM username and password, and then enter the Client ID (API key: this is the Client Key from Configuring the REST API section above) and the target search URL.
- Select
Authenticate.
If the base API URL was not set, the URL will need to be created manually.