Working with your reporting data
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 both real and delta data values.
Each data record includes the date on which the data was copied. These timestamped data records are copied each day and stored for a rolling period of 31 days. A copy of the data is also taken on the last day of each month, and these monthly snapshots are stored in Collibra Data Intelligence Cloud indefinitely.
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 (daylight saving time, if applicable) in the relevant region. For example, when considering the time for London, "02:00 local time" means 02:00 in London.
| Cloud provider | Location |
Data dump (UTC) |
Processing begins (UTC) |
Reporting data is ready (UTC) |
|---|---|---|---|---|
| AWS | Singapore |
14:00 (22:00 local time)
|
16:00 (00:00 (midnight) local time) |
20:00 (04:00 local time) |
| AWS | Sydney |
14:00 (00:00 (midnight) local time) |
16:00 (02:00 local time) |
20:00 (06:00 local time) |
| AWS | Frankfurt |
00:00 (midnight) (02:00 local time) |
02:00 (04:00 local time) |
06:00 (08:00 local time) |
| AWS | Ireland |
00:00 (midnight) (00:00 local time) |
02:00 (02:00 local time) |
06:00 (06:00 local time) |
| AWS | London |
00:00 (midnight) (01:00 local time) |
02:00 (03:00 local time) |
06:00 (07:00 local time) |
| AWS | Central Canada |
05:00 (01:00 local time) |
06:00 (02:00 local time) |
10:00 (06:00 local time) |
| AWS | Northern Virginia |
05:00 (01:00 local time) |
06:00 (02:00 local time) |
10:00 (06:00 local time) |
| AWS | Northern California |
08:00 (01:00 local time) |
09:00 (02:00 local time) |
13:00 (06:00 local time) |
| GCP | Tokyo |
05:00 (14:00 local time) |
05:00 (14:00 local time) |
10:00 (19:00 local time) |
| GCP | Singapore |
07:00 (15:00 local time) |
07:00 (15:00 local time) |
12:00 (noon) (20:00 local time) |
| GCP | Sydney |
14:00 (00:00 (midnight) local time) |
14:00 (00:00 (midnight) local time) |
19:00 (05:00 local time) |
| GCP | Belgium |
00:00 (midnight) (02:00 local time) |
00:00 (midnight) (02:00 local time) |
05:00 (07:00 local time) |
| GCP | London |
00:00 (midnight) (01:00 local time) |
00:00 (midnight) (01:00 local time) |
05:00 (06:00 local time) |
| GCP | Quebec |
05:00 (01:00 local time) |
05:00 (01:00 local time) |
10:00 (06:00 local time) |
| GCP | South Carolina |
05:00 (01:00 local time) |
05:00 (01:00 local time) |
10:00 (06:00 local time) |
| GCP | Virginia |
05:00 (01:00 local time) |
05:00 (01:00 local time) |
10:00 (06:00 local time) |
| GCP | Iowa |
06:00 (01:00 local time) |
06:00 (01:00 local time) |
11:00 (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 specify 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 with 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.