Skip to content
Presswerk Docs

Data Sources

A data source is a connection configuration to an external system. It defines how Presswerk connects to a database, API, or file.

Creating a Data Source

Section titled “Creating a Data Source”
  1. Navigate to Data Sources in the sidebar
  2. Click New Data Source
  3. Enter a name and optionally a description
  4. Select the type and fill in the configuration

Types

Section titled “Types”

JDBC (SQL Databases)

Section titled “JDBC (SQL Databases)”

For relational databases. Supported systems:

DatabaseDriver
PostgreSQLorg.postgresql.Driver
MySQLcom.mysql.cj.jdbc.Driver
MariaDBorg.mariadb.jdbc.Driver
Oracleoracle.jdbc.OracleDriver
SQL Servercom.microsoft.sqlserver.jdbc.SQLServerDriver
DB2com.ibm.db2.jcc.DB2Driver
H2org.h2.Driver

Configuration:

  • JDBC URL — Connection URL (e.g. jdbc:postgresql://localhost:5432/mydb)
  • Username / Password — Credentials
  • Driver Class — Auto-detected from URL

REST

Section titled “REST”

For REST APIs. Configuration includes the base URL and authentication.

Configuration:

  • Base URL — API base URL (e.g. https://api.example.com)
  • Auth Type — none, basic, apiKey, or oauth2
  • Headers — Additional HTTP headers
  • Timeout — Request timeout in milliseconds

Auth types in detail:

TypeFields
basicUsername, Password
apiKeyHeader name, API key value
oauth2Token URL, Client ID, Client Secret, Scopes

GraphQL

Section titled “GraphQL”

For GraphQL endpoints.

Configuration:

  • Endpoint — GraphQL URL (e.g. https://api.example.com/graphql)
  • Headers — Additional HTTP headers (e.g. for auth)
  • Timeout — Request timeout

JSON

Section titled “JSON”

For static JSON files (local or remote).

Configuration:

  • File path — Path to the JSON file

Connection Test

Section titled “Connection Test”

Every data source can be tested before saving. Click Test Connection:

  • JDBC: Executes SELECT 1
  • REST: Sends a HEAD request to the base URL
  • GraphQL: Runs a { __typename } introspection query

A successful test confirms the connection works with the given parameters.

Environment Overrides

Section titled “Environment Overrides”

Every data source has a Base Config — the default connection configuration. For different deployment stages (e.g. TEST, PROD), you can configure different connection parameters.

To set up an override:

  1. Open the data source
  2. Switch to the Environments tab
  3. Select an environment and enter the differing parameters
  4. Only the explicitly set fields override the base config

Example:

Data Source: "Sales DB"
├── Base Config: localhost:5432/sales_dev
├── Override TEST: test-server:5432/sales_test
└── Override PROD: prod-server:5432/sales_prod

When the environment switcher is set to “TEST”, Presswerk uses the TEST override. If no override exists for an environment, the base config is used.

Overrides can also be tested — with the Test Connection button in the environments tab.

Encryption

Section titled “Encryption”

Sensitive configuration data (passwords, API keys, secrets) is encrypted with AES-256-GCM in the database. In API responses, these fields are masked.

Folders

Section titled “Folders”

Data sources can be organized in folders. Folders enable: