
You can export catalog records in the following ways:

- Export to a downloadable CSV, JSON or JSON lines file  
This method allows you to export catalog records to a file you can download and use as you wish. There are two options here:
    - by [simple export](#simple-export)  
    Ideal for one-off, quick file extraction when you need the data just once.
    - in the Automation Hub  
    Allows for cyclical, automated uploads of catalog record files. Best if you need the process to run regularly without manual intervention.

- [Export to external services](#export-through-the-automation-hub)
    - You can export catalog records directly to external services that Synerise supports natively (for example, Amazon S3, Google Cloud Storage) using the Send File action nodes or to any endpoint using ["Outgoing Integration" node](/docs/automation/actions/webhook-node).  

    **Benefits**: 
    - You get a draft [workflow](/docs/automation/creating-automation) which you adjust to your needs.
    - This method lets you modify the file with catalog records by using the [Data Transformation node](/docs/automation/operation/data-transformation-node) in the workflow. 

## General prerequisites
---
You must have the [permissions to export data](/docs/settings/identity-access-management/permissions/data-management-permissions#export-records-from-catalogs).

## Simple export
---

This method lets you perform a single export to a downloadable file.

1. Go to <img src="/api/docs/image/54176ad07f146575310749eba44b7c2f42c1b327/icons/data-modeling-hub-icon.svg" alt="Data Modeling Hub icon" class="icon"> **Data Modeling > Catalogs**.
2. Select a catalog.
3. On the top bar, click **Export**.  
    **Result**: A pop-up shows. 
4. Select **Export single file**.  
5. Click **Next**.  
6. In the **Name** field, enter the name of the export.
    This will allow you to easily identify your export in the list of scheduled data export jobs.
7. Click **Next**.  
8. Confirm by clicking **Run export**.  

### Where to find the file? 

9. To download the exported file, go to <img src="/api/docs/image/54176ad07f146575310749eba44b7c2f42c1b327/icons/data-modeling-hub-icon.svg" alt="Data Modeling Hub icon" class="icon"> **Data Modeling > Exports**. 
10. On the left panel, select **Catalogs**.  
11. Find the file on the list.
12. Click <img src="/api/docs/image/54176ad07f146575310749eba44b7c2f42c1b327/icons/threedoticon.png" alt="Three dot icon" class="icon" >
13. Select **Download CSV, **Download JSON** or **Download JSON lines**.


## Export through the Automation Hub
---

This export method lets you:
- export a downloadable file
- export a file to external services  
    - Synerise offers easy integration with some services by the Send File node, for example, ["Send File" node](/docs/automation/integration/google-cloud-storage/send-file-to-gcp) to Google Cloud Platform.
    - If you can't find the service to which you want to export the file, use ["Outgoing Integration" node](/docs/automation/actions/webhook-node).

### Prerequisites for this method
---
- Verify if you need to modify the file with records before the export. If so, prepare a [data transformation rule](/docs/automation/data-transformation-and-imports/creating-data-transformation) which you will later select in the [settings of the workflow](#configure-and-launch-workflow).  
- [Create a connection](/docs/settings/tool/connections#creating-connections) with the service to which you want to export the file with catalog records.  
    If you can't find the service to which you want to export the file, you can use ["Outgoing Integration" node](/docs/automation/actions/webhook-node) in the workflow and you can create the connection directly in the node configuration.


### Configure and launch workflow
---
1. Go to <img src="/api/docs/image/54176ad07f146575310749eba44b7c2f42c1b327/icons/data-modeling-hub-icon.svg" alt="Data Modeling Hub icon" class="icon"> **Data Modeling > Catalogs**.
2. Select a catalog.
3. On the top bar, click **Export**.  
    **Result**: A pop-up shows.  
4. Select **Export in Automation**.  
    **Result**: The **Where do you want to export file?** dropdown shows.
5. From the **Where do you want to export file?** dropdown select:  
    - if you want to export a downloadable file, select **Save file**.  
    - if you want to export to external services, from the dropdown list, select one of the services.
    - if no option fits your business case, select any option: you will modify the draft workflow to your needs in further steps.  
    **Result**: You are redirected to a draft workflow.  
    
   <div class="admonition admonition-tip"><div class="admonition-icon"><svg xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 24 24" stroke="currentColor" stroke-width="2.5"><path stroke-linecap="round" stroke-linejoin="round" d="M9.663 17h4.673M12 3v1m6.364 1.636l-.707.707M21 12h-1M4 12H3m3.343-5.657l-.707-.707m2.828 9.9a5 5 0 117.072 0l-.548.547A3.374 3.374 0 0014 18.469V19a2 2 0 11-4 0v-.531c0-.895-.356-1.754-.988-2.386l-.548-.547z" /></svg></div><div class="admonition-body"><div class="admonition-content">

   If you were not redirected to the workflow, disable your browser’s pop-up blocker.

   </div></div></div>
  

6. If you want to schedule the frequency and date and time when the workflow will trigger, edit the configuration of the ["Scheduled Run" node](/docs/automation/triggers/scheduled-run).  
7. In the **Get Catalog Data** node, leave the settings at default (the catalog is already selected).  
    
   <div class="admonition admonition-note"><div class="admonition-icon"><svg xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 24 24" stroke="currentColor" stroke-width="2.5"><path stroke-linecap="round" stroke-linejoin="round" d="M13 16h-1v-4h-1m1-4h.01M21 12a9 9 0 11-18 0 9 9 0 0118 0z" /></svg></div><div class="admonition-body"><div class="admonition-content">

   You can read the node documentation in ["Get Catalog Data" node](/docs/automation/actions/synerise-integrations/export-data-from-catalog).

   </div></div></div>

8. In the **Data Transformation** node, select the transformation rule according to which the file with the records will be modified before export. If you don't need the node, you can remove it.  
9. Configure the node with the export:
    - If you selected **Save File**, go to the node settings and enter the name of the file to which catalog records will be exported.
    - If you selected an external service, go to the node settings:  
        1. Select a connection.
        2. Fill out the configuration form.  
        To get instructions to filling out the configuration form, [find the service on the list](/docs/automation/integration) and proceed to the node instructions. 
        
   <div class="admonition admonition-tip"><div class="admonition-icon"><svg xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 24 24" stroke="currentColor" stroke-width="2.5"><path stroke-linecap="round" stroke-linejoin="round" d="M9.663 17h4.673M12 3v1m6.364 1.636l-.707.707M21 12h-1M4 12H3m3.343-5.657l-.707-.707m2.828 9.9a5 5 0 117.072 0l-.548.547A3.374 3.374 0 0014 18.469V19a2 2 0 11-4 0v-.531c0-.895-.356-1.754-.988-2.386l-.548-.547z" /></svg></div><div class="admonition-body"><div class="admonition-content">

   If the list doesn't include the service to which you want to export, you can replace the node with the ["Outgoing Integration" node](/docs/automation/actions/webhook-node) - you can set up the connection and the endpoint to which you will make a request in the node directly.

   </div></div></div>

10. In the upper-right corner, click **Save & Run**.  
    **Result**: The workflow will be active and the actions in the workflow will be triggered as defined in the **Scheduled Run** node. The logs of operations in the workflow are available:  
    - for the data transformation: enter the configuration of the workflow (<img src="/api/docs/image/54176ad07f146575310749eba44b7c2f42c1b327/icons/automation-hub-icon.svg" alt="Automation Hub icon" class="icon" > **Automation Hub > Workflows**), select the **Transformation logs** tab.  
    - for the export, go to **Data Modeling > Exports**, on the left pane, select **Automation**.