Edit Excel export configuration

In Collibra Platform, you can export Collibra data to CSV or Excel files.

Depending on your environment, follow this procedure either on the Services Configuration tab of the Collibra settings or in Collibra Console:

Important You can't edit the service configuration from the Settings page in the latest UI. If you use the latest UI, you can edit the service configuration only in Collibra Console. For more information, go to Collibra service configuration settings.

Prerequisites

Steps

  1. Open the Services Configuration page.
    1. On the main toolbar, click Products icon → Cogwheel icon Settings.
      The Collibra settings page opens.
    2. Click Services Configuration.
    3. Click Edit configuration.
    Open the DGC service settings for editing:
    1. Open Collibra Console.
      Collibra Console opens with the Infrastructure page.
    2. In the tab pane, expand an environment to show its services.
    3. In the tab pane, click the Collibra Platform service of that environment.
    4. Click Configuration.
    5. Click Edit configuration.
  2. In the Excel export configuration section, make the necessary changes.
    SettingDescription
    The default CSV separator characterThe default separator character of the CSV fields for complex relations.
    The default CSV quote characterThe default quote character of the CSV fields for complex relations.

    Number of rows per chunk of data

    When exporting views, the database is called repeatedly, each time fetching a chunk of data to build the export file. This option defines how many rows each chunk of data can contain.

    Lower values reduce the burden on memory. Higher values require more memory, but may slightly increase the speed of the export.

    The default value is 5,000.

  3. Click Save all.