You can use the DataSuite to create connections to existing databases. The following databases are supported:
- MSSQL: Microsoft SQL Server from 2012
- MySQL: MySQL from Oracle as of version 5
- MariaDB: From version 10.2
- Postgres: As of version 9.6
In the ‘Databases’ menu, you will find an overview of your database connections. You can add new connections at the top right. The number of possible connections is not limited.
Please note:
The DataSuite establishes a connection to an existing database. No new database, tables, views, etc. can be created in the DataSuite
Please note:
Secure the database with a separate user for the DataSuite. DataSuite can be used to enter data into the database and execute scripts. To back up your database, create your own database user with the minimum necessary authorisations for DataSuite.
- DataSuite requires read/write access to all tables and views that you use in the triggers of DataSuite.
- DataSuite requires read access to the system tables in order to determine the available tables and columns (depending on the respective database).
- MSSQL
- sys.sysdatabases
- sys,sysobjects
- sys.columns
- sys.views
- INFORMATION_SCHEMA.COLUMNS
- INFORMATION_SCHEMA.KEY_COLUMN_USAGE
- Postgres
- pg_database
- pg_tables
- information_schema.columns
- INFORMATION_SCHEMA.views
- information_schema.tables
- information_schema.table_constraints
- information_schema.constraint_column_usage
- MySQL / MariaDB
- DATABASES
- TABLES
- COLUMNS
Configure database connection #
All connection parameters are explained below. However, depending on the type of database connection, not all parameters are always available.
