Skip to main content

Database Connections

Database Connections

FactoryThread connects to relational and time-series databases. Each table or view becomes an entity you can read in a Flow, and most databases also support write-back (append, update, clear, or delete).

ConnectorSystem
SQL ServerMicrosoft SQL Server / Azure SQL
PostgreSQLPostgreSQL
Amazon RedshiftAmazon Redshift data warehouse
Microsoft AccessMicrosoft Access
IBM DB2IBM DB2
InfluxDBInfluxDB time-series database

SQL Server​

  • Choose SQL Connection and enter Server, Database, Port (default 1433), Username, and Password — or switch to Connection String and paste a full string.
  • Set a connection Timeout (milliseconds, default 30000).
  • Click Test Connection to verify.

FactoryThread lists base tables as entities, discovers their schema (including foreign keys), and supports paginated reads and full write-back (append, update, clear, delete). Opcenter APS connections also use this form — see MES / MOM.

PostgreSQL​

Same form as SQL Server (SQL Connection parameters or a connection string), with the default Port 5432. Connection strings accept postgres:// / postgresql:// URLs and an sslmode setting. Supports Test Connection, entity browse, schema discovery, paginated reads, and write-back.

Amazon Redshift​

Redshift uses AWS-style credentials rather than host/port:

  • Access Key, Secret Key, Region, Workgroup, and Database, plus a connection Timeout.

Microsoft Access​

  • Enter a Connection String and a connection Timeout.

IBM DB2​

  • Enter a Connection String and a connection Timeout.
  • The connection string must include a default collection — for example DefaultCollection=MYLIB — which FactoryThread uses as the schema. A connection string without one is rejected.

FactoryThread reaches DB2 through a dedicated DB2 operations service that must be deployed and reachable from your FactoryThread instance. Once connected, it supports entity browse, schema discovery, paginated reads, and write-back (append, update, clear, delete).

InfluxDB​

InfluxDB is a time-series database. (You can also read and write time-series data inside a Flow with the Time Series node.)

  • Version — choose v3 (SQL) or v2 (Flux); this selects the query dialect FactoryThread uses.
  • Host — the InfluxDB URL (e.g. https://us-east-1-1.aws.cloud2.influxdata.com, or http://localhost:8086 for a self-hosted v2 server).
  • API Token.
  • Organization — required for v2.
  • Bucket (v2) or Database (v3) — the target data store.
  • A connection Timeout.

FactoryThread browses measurements as entities and infers their schema. Write-back is append-only — InfluxDB does not support updating, deleting, or clearing rows, so those write modes are rejected.

Next steps​