This connector allows you to analyze your ZenGRC data using Tableau. The connector uses the ZenGRC API and pulls fields based on that. For additional information on those fields, please see our documentation at https://docs.api.zengrc.com/
After accessing the connector, complete the steps in the next sections to set up the connection.
To set up the initial connection, you must first generate an API key, which can be done within ZenGRC.
To create a new API key and secret, complete the following steps:
Follow the instructions at ZenGRC Cloud API under Generate the Key ID and Key Secret. Then continue with the next section.
After generating the key and key secret, complete the following steps:
The following table shows the objects available in Tableau, along with any bridge tables and other considerations:
|Available Objects||Custom Attributes||Bridge Tables||Special Considerations|
|Assessments||Supported||Assessments to Audits||No|
|Audits||Supported||Assessments to Audits,|
Issues to Audits,
|Program ID in Audits table = ID in Programs table,|
Audit ID in the Requests table = ID in the Audits table
|Issues||Supported||Issues to Audits,|
Requests to Issues
|Programs||Supported||Requests to Programs,||Program ID in Audits table = ID in Programs table|
|Requests||Supported||Requests to Issues||Audit ID in the Requests table = ID in the Audits table|
|Risks||Supported||No||Risk scores not yet supported|
A bridge table in Tableau allows you to join two tables to more easily pull information most relevant to your organization. The following screenshot displays a bridge table in Tableau. It is an example of how the "Assessments to Audits" bridge table connects the Audits and Assessments tables: