Skip to main content

SQL Endpoint

A SQL endpoint holds the necessary configuration to connect to an external system (relational database). It allows 1Gateway to establish database connections through JDBC.

This enables integrations where SQL queries need to be executed from workflow plugins to read or write data in a database. Typical use cases include CMDB synchronization, reporting integrations, or importing monitoring data.

Configuration Fields​

Each SQL endpoint requires the following configuration settings:

  • Connection String – The JDBC connection string used to connect to the database.
  • Username – The database user used for authentication.
  • Password – The password for the database user.

These parameters define how to connect to the database.

Endpoint Properties​

Endpoints support custom properties that can be referenced by any plugin. These properties can store metadata such as partner information or other integration-specific details.

Example: Storing partner information:

Endpoint config