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. The copy includes both real and delta data values.
Additionally, the Usage Analytics view events data for your Collibra is stored each night. This includes data from every page visited during a user's session, such as assets and communities.
Each data record includes the date on which the data was copied. These time-stamped 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 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) |
| AWS | United Arab Emirates (UAE) |
20:00 UTC (00:00 local time) |
Between 21:00 and 00:00 UTC (Between 01:00 and 04:00 local time) |
01:00 UTC (05: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 can't access the data directly in Collibra. 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.
You can use one of the following URLs to download the data.
<your-Collibra-environment-URL>/rest/2.0/reporting/insights/directDownload?snapshotDate=<snapshot_date>&format=zipNote- The directDownload endpoint downloads the zip file containing reporting data directly from cloud storage, bypassing the Collibra network.
- To use the endpoint, ensure that your application allows redirects.
- The endpoint uses a temporary pre-signed URL that is valid for 60 seconds by default.
- The endpoint is compatible with both AWS and GCP.
<your-Collibra-environment-URL>/rest/2.0/reporting/insights/download?snapshotDate=<snapshot_date>&format=zipNote The download endpoint will be deprecated soon.
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.