SQL

Seeq connects to relational databases through its SQL Connector, bringing signals, conditions, and scalars into Seeq directly from SQL queries. Dialect-specific database types exist for many common database engines, and for anything not explicitly supported, the Generic SQL Datasource connector works with any database that exposes a JDBC interface, using a customer-supplied JDBC driver, connection URL, and driver class. Because SQL dialects vary, Seeq can't guarantee compatibility with every database through the generic path, but in practice this covers a broad range of tools.

What to consider before connecting a SQL datasource

Regardless of which SQL database you're connecting to, a few things are worth planning for upfront:

Drivers and connectivity

Some connectors bundle their own JDBC driver; others (including Generic SQL) require you to supply a driver .jar, JDBC URL, and driver class. Confirm network access (host, port, firewall rules) between the Seeq server and the database before configuring the datasource.

Authentication

Supported auth methods vary by database including, username/password, Windows Integrated Authentication, IAM roles (Redshift), Kerberos (SAP HANA), or service principals (Azure SQL). Passwords can be supplied via a secrets file rather than in plain configuration.

Query definitions

Item creation (signals, conditions, scalars) is driven by query definitions rather than a broad crawl/index of the database. Query definitions map columns to item types and can use variables and time-partition substitution (e.g., ${start:...}, ${end:...}) for large or partitioned tables.

Time zone and timestamp handling

If a timestamp column doesn't carry its own time zone, Seeq defaults to UTC unless a TimeZone override is configured.

Performance

Make sure columns used in WHERE clauses are indexed, and use native timestamp column types rather than strings or concatenated expressions.

Security

TLS/SSL options (encryption, certificate trust and validation) are available on most connectors and should be reviewed against your organization's security requirements.

Supported SQL datasources

Seeq has named connectors and/or KB documentation for:

• Microsoft SQL Server

• Oracle

• PostgreSQL

• MySQL

• Snowflake

• Amazon Redshift

• SAP HANA

• Azure Synapse

• Amazon RDS (MySQL, PostgreSQL, Oracle, SQL Server, and Aurora variants)

• Athena

• Databricks

• Denodo

• Vertica

• TimescaleDB

Don't see your database listed? The Generic SQL Datasource connector can connect to any JDBC-accessible SQL database.