Page Comparison

Canvas enables you to export the configured reports in JSON and SQL formats. You can use this feature to promote reports configuration from one environment to another, e.g. development to testing servers. Once you export the reports configuration in JSON format from source environment (e.g. development), you can then inject using the Import feature in Canvas Sigma Studio on the target environment (e.g. testing). If you have exported in SQL format from the source environment, you must execute the exported SQLs on the DB in the target environment.

Perform the following to export the report configuration:

• Anchor
  exportjson exportjson

  Steps to export report metadata in JSON format
• Steps to export report metadata in SQL format

Steps to export report metadata in JSON format:

1. Click Information Report menu from the left navigation in Canvas Sigma Studio.
   
   A list of configured reports appears on the right-side of the page.
   
   
2. Right-click an existing report and click Generate JSON.
   
   
3. Click OK to the success message.

...

1. Click Information Report menu from the left navigation in Canvas Sigma Studio.
   
   A list of configured reports appears on the right-side of the page.
   
   
2. Right-click an existing report in Canvas Sigma Studio and click Generate SQL.
   
   
3. Click OK to the success message.

...