Exporting Data and Metadata to SQL and CSV

We provide the ability to download data and metadata to your computer, as well as to export data to various endpoints. 

Data of Backups can be exported to the following formats:

• CSV
• SQL 
• SQL Endpoint 
• Amazon S3
• Azure Blob
• Snowflake

Metadata of Backups can only be downloaded to your computer.

Downloading Data

Download Data Backup Information to CSV File

1. In the Data Backup Dashboard screen, click on the Backup History tab, on the left pane.

2. In the Backup History screen, click Export to CSV.

3. A CSV file is downloaded to your computer.

4. The CSV file only contains certain types of information for all the backups, such as: time the backups started, duration of each backup, number of items, total size, number of API calls, etc. 

Download Data Backup to Zip File

1. In the Data Backup Dashboard screen, click on the Backup History tab, on the left pane.

2. In the Backup History screen, select the specific Backup that you wish to download.

3. At the top of the screen, click the Download button. 

4. The Download as CSV window opens. Choose whether to download All objects, or Specific objects. If you choose specific, select the objects from the list. If you want to Include attachments, then check the checkbox.

5. Click Run. The Backup Export completed screen appears. To download the exported snapshot file, click the download link. 

6. A Zip file is downloaded to your computer. The Zip file contains a set of CSV files - one for each object in the backup.

Downloading Metadata

Metadata from backups can only be downloaded to your local computer, and cannot be exported to endpoints, like backup data.

One backup's metadata can be downloaded as a Zip file. 

Information about your recent metadata backups (such as when the backup occurred, number of files, number of consumed APIs, etc.), can be downloaded as a CSV file.

Download Metadata Backup Information to CSV File

1. In the Dashboard screen, click on the Backup History tab, on the left pane.

2. In the Backup History screen, click Export to CSV.

3. A CSV file is downloaded to your computer.

4. The CSV file only contains certain types of information for all the backups, such as: time the backups started, duration of each backup, number of items, size, number of API calls, etc.

Download Metadata Backup to Zip File

1. In the Dashboard screen, click on the date of the specific backup that you wish to download.

2. The Backup Summary screen for the requested date appears. Click on the Export button.

3. A Zip file is downloaded to your computer.

4. When you unzip the file, the folder contains subfolders, where each metadata object is listed separately, as well as the package.xml file. Use any of these files to deploy metadata using your preferred Integrated Development Environment.

Export Backup Data to Amazon S3, Azure Blob, and Snowflake 

Click here to read more on data export to Amazon S3.

Click here to read more on data export to Azure Blob.

Click here to read more on data export to Snowflake.

Click here to read more on objects excluded from Export to SQL, Amazon S3, Azure Blob and Snowflake Data Warehouse.

Export Backup Data to SQL

We support this feature with MySQL, Oracle, PostgreSQL, and MS-SQL databases. You can select the format, and whether to export All or specific objects. To see the list of objects excluded from the export process see here.

When using the export to SQL feature, you can export your data backup into an SQL database, via a generated SQL script for download. This script can then be inserted into your database, upon which all of your data and relationships will be inserted.

Export to SQL Endpoint

If you have a My-SQL database, you can set up an endpoint, and then directly push your data to the database. This feature is currently available for MySQL and doesn't support Client Cert Auth connections which require an additional file beyond the SSL CA.
If you need to allow list the incoming traffic into your MySQL, you can find more information here.

​