Exporting and Importing Data Models
  • 02 Nov 2022
  • 2 Minutes to read
  • Dark
    Light

Exporting and Importing Data Models

  • Dark
    Light

You can export and import your ElastiCube data and live data models into Sisense. Models can be exported as .smodel files. The .smodel file contains the design of your model’s schema and its connection settings to its sources.

Note:

All .smodel files created in earlier versions of Sisense are compatible with later versions. However, you can't import .smodel files from later versions of Sisense into earlier versions.

For Linux deployments, you can select to export a .sdata file. The .sdata file contains the design of your model’s schema, connection settings to its sources, and the data itself.

Exporting a Model in Linux

You might want to export a model to use it as a backup, as a base for another ElastiCube, or to load it onto a different Sisense server.

To export a model:

  1. Open the Data page.

  2. For the relevant ElastiCube, select > Export Model .

    8-6export-model-menuthumb0300.png

  3. Select whether to export the model schema ("Model: Draft Version") or the model schema and the data ("Model and data").
    If exporting the model schema, you can also select which, if any, related assets to export. These include: Data Security, Hierarchies, and Formulas.

    Note:

    For all three assets:

    • If the security rule/drill hierarchy/formula already exists, it will not be overwritten.
    • If it is new, it will be added.

    For Data Security:

    • Checking by the user (email and not its OID) - if a user does not exist on the machine that is imported into, it will not add the user and will not apply the security rule on that user.

    All Data Security rules and emails are encrypted.

    This is only available in model export (sModel).


  4. Click Export .

    You're prompted to download a file:

    • If you're exporting the model only (A), you'll be prompted to download a .smodel file
    • If you're exporting the model and data (B), you'll be prompted to download a .sdata file
Notes:
  • Rebuilding the model from a .smodel file could be time-consuming.

  • When exporting a .sdata file, keep in mind that it might be very big. You might need to be able to transfer a large volume of data and have the disk space to support it.

Importing a Model in Linux

To import a model:

  1. Open the Data page.

  2. Click Import Model .

    8-6importmodelthumb0300.png

  3. Drag a .smodel file (model only) or .sdata file (model and data) to the Import dialog box.

    OR

    Click Browse. Navigate to the relevant .smodel or .sdata file and select it.

  4. If a model with the same name already exists, either rename the model or overwrite the existing model with the one you're importing.

    8-6import-model-overwrite-namethumb0300.png

    The schema is displayed and the model is added to the Data page. Build the model so that you can work with it in your dashboard. If you imported a .sdata file, you can view the data immediately, without needing to perform a build.


Was this article helpful?