Skip to Content
Data Plus ServerOnPremise InstallationDatabase Connection

Database Connection

PostgreSQL

You can use the Postgres Setup to quickly create the database. This will require admin credentials to create a new database and user within your Postgres instance.

Connecting to an existing database

Otherwise you have to create the database and user yourself in your desired database and simply enter the connection information. (Connecting to an instance of a mssql server might require a special port e.g. 50295)

Once the connection is established, the following Data+ system tables will be created:

  • _dp_tables - Meta information of all tables
  • _dp_logs - Major Server events (e.g. admin logins)
  • _dp_licensed_users - List of all users that have a license
  • _dp_history - Contains all changes to tables that have the history flag enabled

Known limitations

  • MicrosoftSQL databases use the collation Latin1_General_100_CI_AS by default. Unique columns are not case sensitive with this setting, which might cause some unexpected behaviour. This cannot be changed once Data+ is connected to the database. We recommend to set this to Latin1_General_100_CS_AS during the database creation.
Last updated on
OnPremise InstallationQlik Connection