DB Connector

This connector definition makes it possible to use a database in Webdesk in a linked connector. This allows data to be read from a database via Webdesk or written to a relational database.

Example of the configuration of a DB connector

Database properties

• User
  User name to be used for logging in
• Password
  Password to be used for logging in
• URL
  Enter the URL of the database, e.g.: jdbc:sqlserver://servername:port;databaseName=db_name;):
• Example for MySql:
  jdbc:mysql://192.168.3.12:3306/TestDB
• Example for MSSql:
  jdbc:sqlserver://localhost:1433;databaseName=webdesk

Parts of the SQL query

• Select statement
  The select part of the SQL statement is optional. If it is empty, 'select *' is used.
• From statement
  The from part of the SQL statement (e.g.: from table_name_from_the_schema). This parameter must be specified.
• Where statement
  The where part of the SQL statement is optional. If it is empty, no restriction is applied.
• dbConnector_escapeCharacter
  This can be used to specify an escape character for special characters so that they can be used in SQL queries (usually /)

Restrictions

• Main table (update/delete)
  The main table that is ultimately written to. This information is only used if the connector is the target.
• Writing to the main table is allowed
  The parameter defines whether it is permitted to write to the main table.

Test connection

This button makes it possible to check whether the connection works with the configured parameters.