Working with your reporting data
Note This functionality is only applicable for Collibra Data Intelligence Cloud 5.7.0 and newer versions.
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. The copy includes the real data values, in addition to the delta.
Each data record includes a snapshot date, which is 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) time zone.
- 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 time for the eu-west-2 region, 02:00 local time means 02:00 in London.
| Cloud provider | Region name | Location |
Data dump (UTC) |
Processing begins (UTC) |
Reporting data is ready (UTC) |
|---|---|---|---|---|---|
| AWS | ap-southeast-2 | Sydney |
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 |
| AWS | 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 |
| AWS | 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 |
| AWS | 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 |
| AWS | 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 |
| AWS | 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 cannot access the data directly on Collibra Data Intelligence Cloud. A REST API is created to enable you to download your reporting data to a local server or your computer. If you mention the snapshot date that you want in the REST API, 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 have downloaded your reporting data, you must establish a connection between your data and your organization's business intelligence tool. This guide describes the procedures to do so via Amazon Web Services and Google Cloud Platform.
Tip If you need assistance, contact your internal IT infrastructure team, who can advise you as to where to store the downloaded files and how to establish the connection with your organization's business intelligence tool.