Exporting a model from Staging

  1. Select Dashboards > Data Integrations > Relational Modeling.
  2. From the Target Connection list, select Staging.
  3. Click Export.
  4. Select the application to export from.
  5. Select which content of the model to include in the export and click Next.
  6. For each table to export, select whether to include its schema, its data, or both. To select all tables for export, click the three dot icon and select Select all. Click Next.
  7. Select the views to export and click Export.
  8. If the export fails because the content contains an invalid character, follow these steps:
    1. Click Scan.
      The results of the scan and a script to remove the invalid characters are downloaded as a .zip file.
    2. Select the Scripts node in the Relational Database Structure pane. Add a new script for the application.
    3. Paste the script that is included in the .zip file into the script editor. Validate and run the script.
      Note: The corrective script can only remove invalid characters. However, you can manually adjust the script to replace invalid characters with valid characters. The script cannot remove invalid characters in database views.
    4. Repeat steps 1 to 9.
  9. Click Finish.
    The model is exported to your download directory as an .rmexport file.