Configuring your Data Connections is straightforward and done in a few minutes. You can add multiple data connections, in case integrations or insights are created on specific resources. Although the setup is straightforward, it is good to be aware of some nuances when setting up Data Connections.
Setting up a data connection
Follow the steps below to create a new data connection and select the necessary resources.
Open the admin portal (https://admin.mapiq.com) and navigate to Settings >> Integrations. Scroll down until you find Data Connections.
Click on + Add to open the wizard to create a new data connection, or share.
Name the data connection with a recognizable name for ease of use and clarification what it's used for.
Click on + icon next to Shared content to indicate what data sets, or tables, you want to make available in this share.
In case you have multiple buildings, select the buildings you want to include.
Now select the data to include. Refer to our Understanding the data tables to get a better understanding of all the resources to select. Finalize by clicking on Save.
Under Manage access the Endpoint URL now becomes available.
Finally you'll need to create an Access key that is used to authenticate on the Endpoint URL, click on +Add key
Important! For security reasons the access key is only available once. Ensure you copy the key and store it somewhere safe.
Important! The access key is valid for 180 days. 14 days prior to expiration a warning is given in the admin portal. You can create a second key used to roll-over, to ensure your connection doesn't break.
Once you have created your data connection, you can use the Endpoint URL and your stored Access keys in your in-house data solution (e.g. Power BI, Tableau) and start using the data.
Managing tables, refreshing & revoking access
You can change existing data connections by changing the building filter or (de)selecting specific data tables depending on your needs.
Refreshing tokens
The access token needs to be refreshed after 180 days, you will receive a new token which you need to enter in your external tool.
Revoking access
If you need to revoke the access to a specific dataset, you can also remove the applicable access key(s). From then on, the data tables will no longer refresh.
Go to the data connection you want to revoke access for.
Go to Access keys and locate the key you want to revoke.
Click on the trash bin icon next to the key to revoke access.
Deleting data connections
Data connections can also be fully deleted when there is no need for it by clicking the delete button. Data will no longer be refreshed. Some tools will request you to enter the access token again, which you can also no longer do after deleting the data connection.
Go to the data connection you want to delete.
At the bottom of the Data connection window, click on Delete data connection.
Information on data tables
For specific information about data tables, also go over our Understanding the data tables article. It is good to be aware that all tables are refreshed at 00:00 UTC on a daily basis, once a day. Additionally, the tables are structured so that they are directly compatible in well known analytics tools, like Power BI.
💬 Need More Help?
If you’d like extra assistance, reach out via the Messenger (question mark in the corner) and chat with our support team, or email us at [email protected].
We’re always ready to help! 😉