Font size

Exporting Data to Database

anyLogistix allows you to export scenario data from your project to the required database.

To export scenario data to a database

  1. You may open the Export dialog by doing either of the following:
    • Choose File > Export > Export Scenario to Database... from the main menu or
    • Right-click the required scenario and select Export Scenario to Database...

  2. Select the scenario, that you want to export from the Select scenario to export drop-down.

    If you right-click the scenario to export it, the Select scenario will automatically offer the required scenario to export.

  3. DB type — specify one of the supported DB types: sqlite, sqlserver, postgresql, mysql.
  4. DB address — specify the location of the database.
  5. DB name — specify the name of the database.
  6. DB login — specify the login that can be used to access the database.
  7. DB password — specify the password that can be used to access the database.

    The type of role and access rules for a user are defined by the admin of the database. In other words, by using the provided credentials you are accessing the database with the user profile that has certain rights defined by the admin for you.

  8. Test connection — test if the connection to the database is successful.
  9. Database scenario name — specify the name the exporting scenario should have in the database
  10. Disable the Export experiments toggle button if you do not wish to export the experiments of the scenario.
  11. Disable the Export initial states toggle button if you do not wish to export the initial states of the scenario.
  12. Disable the Export external tables as links toggle button if you do not wish to export the external tables of the scenario.

    If enabled, the database will acquire links leading to these external tables.

  13. Enable the Export empty and default data toggle button if you wish to export the empty tables of the scenario and the default parameters of the experiments to the database.

Result of the export

The destination database will contain the tables containing data of the exported scenario

The sqlite database allows exporting to the existing project database file, which contains other system data. In this case you should look for the tables named export_scenarioType_tableName (as shown on the screenshot above).

Unlike the scenario data, which is exported to the database, the data of the external tables is not exported. This external table’s connection properties are written into the database instead.

If the external table has been imported from an MS Excel file, the export will contain the path to the external.db file containing the actual external tables with all the data. This file is created during the import process.

This file contains all external databases that you add to any scenario of any project.

If the external table has been added as a connection to a table in some external database, the export will contain the connection properties to this external database.

If you need to share the external tables, you may export the required external table to a separate file

How can we improve this article?