Working with your reporting data
Note This functionality is only applicable for Collibra Data Intelligence Cloud 5.7.0 and newer.
Storing your reporting data
Each night, Collibra stores a copy of your reporting data—all assets, attributes, relations and responsibilities, for all domains and communities, including your operating model customizations—in Collibra Data Intelligence Cloud. This includes the real data values, not just the delta.
Each data record includes a snapshot date, the date on which the data was copied. These timestamped data records are copied each day and stored for a rolling 31-day period. A copy of the data is also taken on the last day of each month, and these copies are also stored in Collibra Data Intelligence Cloud.
Processing and availability of the previous day's reporting data
Reporting data is processed in the Coordinated Universal Time (UTC) timezone.
- The time at which the reporting data is ready, as identified in the last column of the following table, can vary depending on the amount of data.
- In the following table, "local time" refers to the time in the relevant region. For example, when considering the times for the eu-west-2 region, 02:00 local time means 02:00 in London.
| Region | Location |
Data dump (UTC) |
Processing begins (UTC) |
Reporting data is ready (UTC) |
|---|---|---|---|---|
| ap-southeast-2 | Brisbane |
14:00 UTC 00:00 (midnight) local time |
Between 16:00 and 19:00 UTC (02:00 and 05:00 local time) |
20:00 UTC 06:00 local time |
| ca-central-1 | Canada |
04:00 UTC 00:00 local time |
Between 06:00 and 09:00 UTC (02:00 and 05:00 local time) |
10:00 UTC 06:00 local time |
| eu-west-1 | Ireland |
00:00 UTC 00:00 local time |
Between 02:00 and 05:00 UTC (02:00 and 05:00 local time) |
06:00 UTC 06:00 local time |
| eu-west-2 | London |
23:00 UTC 00:00 local time |
Between 01:00 and 04:00 UTC (02:00 and 05:00 local time) |
05:00 UTC 06:00 local time |
| us-east-1 | Northern Virginia |
04:00 UTC 00:00 local time |
Between 06:00 and 09:00 UTC (02:00 and 05:00 local time) |
10:00 UTC 06:00 local time |
| us-west-1 | Northern California |
07:00 UTC 00:00 local time |
Between 09:00 and 12:00 (noon) UTC (02:00 and 05:00 local time) |
13:00 UTC 06:00 local time |
Downloading your data
Due to security considerations, you can't access the data directly on Collibra Data Intelligence Cloud. Therefore, we've created a REST API that enables you to download your reporting data to a local server or your computer. You mention the snapshot date you want in the REST API, and a ZIP file of your reporting data, for the specified date, is downloaded to your hard disk.
Connecting your data and your business intelligence tool
After you've download your reporting data, you need to establish a connection between your data and your organization's business intelligence tool. In this guide, we describe the procedures via Amazon Web Services and Google Cloud Platform.
If you need assistance, contact your internal IT infrastructure team. They can advise you as to where to store the downloaded files and how to establish the connection with your organization's business intelligence tool.