You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 10 Next »

Remote storage is available since BellaDati 2.9

Remote storage enables to store Data set in a remote database instead of the database used by BellaDati. 

Compatibility

Remote storage is currently available for these types of databases:

DatabaseSince version
PostgreSQL2.9
MSSQL Server2.9.3.5

 

setting up remote storage

Please note that Remote storage functionality needs to be enabled in the license and in the domain.

Remote storage can be set up only by domain administrator.

Remote storage can be set up by opening Advanced settings in the Settings menu on Data Set detail page and clicking on Edit link in the Remote storage section.

You can use already existing database connection or create a new connection to a database.

Only PostgreSQL database of version 9.0 or newer is supported for Remote storage.

Switching from Local to Remote storage and vice-versa will remove all data in the data set. Attributes, indicators and all other settings will remain unchanged.

switching to local STORAGE

To switch Data set using Remote storage to use Local storage (the database used by BellaDati) open Advanced settings in the Settings menu on Data Set detail page and clicking on Edit link in the Remote storage section.

Under New storage setting check Set to local storage and hit Continue.

Joined data sets

When using remote storage, data set can be joined only with data sets located in the same remote storage.

Using Microsoft SQL Server as Remote Storage

This feature is available since BellaDati 2.9.3.5

It is possible to use Microsoft SQL Server as remote storage. Currently, versions Server 2016 and Server 2017 are supported. When defining the database connection, users can switch from PostgreSQL to Microsoft SQL Server. Further steps are the same as when working with PostgreSQL. Currently, there are following known issues:

  • unsupported aggregations: median, all regression functions
  • unsupported functions: histogram
  • not supported features:
    • joining
    • partitioning
    • GIS
    • translation and appearance
  • No labels