Exporting and Importing Saved Queries¶

You can transfer your saved queries across Denodo installations. Just export them to a file and import that file into the target installation. Let us see how to do it.

To export your saved queries to a file, you have the following options:

• To export one query, click its icon and select the Export query option.

• To export several queries at once, select them and click the Export button in the toolbar.

To import a set of queries previously exported to a file, click the Import button in the toolbar and load the file.

An administrator of the Data Catalog have two more buttons in the toolbar: Export queries from all users and Import all users queries. With them, she can export and import all the queries that users saved when they were connected to the current Virtual DataPort server. This is useful:

• To transfer all saved queries across environments. For example, from a sandbox environment to production.

• To migrate all saved queries from Data Catalog 7.0.

To transfer all saved queries, an administrator needs to proceed as follows:

1. Connect to a server in the source environment.

2. Go to My queries and click the Export queries from all users button.

3. Connect to the corresponding server in the target environment.

4. Go to My queries, click the Import all users queries button and load the file you just exported.

5. Repeat this process for every server in the source environment.