Page tree
Skip to end of metadata
Go to start of metadata

Advanced Settings are available since BellaDati 2.9

Advanced settings can be used to change various parameters of each data set and perform maintenance tasks.

 Please note that these actions might result in losing all of your data.

Advanced settings are divided into following categories:

  • Remote storage settings
  • Maintenance
  • Data table and connection details 

  • Storage parameters

Remote Storage Settings

Remote storage enables to store Data set in a remote database instead of the database used by BellaDati. For more information, please see article Remote Storage.

Remote data table mapping

Remote data table mapping allows to map a BellaDati data set to the existing table in your SQL database. In this case, data are stored only in the source database. For more information, please see article Remote Data Table Mapping.

Maintenance

By default, BellaDati performs maintenance globally and automatically. When necessary, it is possible to set up maintenance for each data set independently. Users can specify the time and the frequency of the maintenance. Please note that maintenance execution will abort running imports.

Since BellaDati 2.9.3, it is also possible to run the maintenance manually by clicking on Run maintenance now.

Data table and connection details

In this table, users can see information about the database table and database itself. They can also change the table space or disable indexing by clicking on the Edit button. 

Disabled indexing can cause serious performance issues.

Users can also re-create data table in the database. This can be useful when the data table gets corrupted. Please note that this action will delete all data from the data set.

Storage Parameters

In this table, it is possible to change advanced storage parameters. This functionality is for advanced users only. In most cases, it is best to use the default values.

Data Set Parameters

This feature is available since BellaDati 2.9.15.3

Parameters can be used to add custom metadata to data sets.

To add a new parameter, click on the plus icon. Each parameter is defined by its name and value.

Dynamic data tables

This feature is available since BellaDati 2.9.3.5

When this option is enabled, users can dynamically change which database table should be used when loading the data to the report. This feature is available when PostgreSQL (since BellaDati 2.9.8.1) or Microsoft SQL Server is used as remote storage. User can specify the table name by using bd_force_data_table parameter in URL while loading report:

 

  • table name without schema and database
  • once set, settings are valid for the entire session until logout or setting bd_force_data_table to empty string
  • tables must have same structure (forced tablename must contain at least the same columns as original table)
  • forced table must contain same primary key column as original table and import_id, ds_id columns

To learn more, please take a look at our tutorial for Dynamic data tables.


  • No labels