OPUSWatch
Let AI connect your sources for you
Skip the manual setup — run this in your project and the wizard auto-detects your databases and APIs and connects them to PostHog.
Connect OPUSWatch to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.
Import master data, work registrations, and productivity sessions from OPUSWatch by OPUS Solutions.
Configuration
| Option | Description |
|---|---|
API keyType: password Required: True | The API key for the OPUSWatch external API, issued by OPUS Solutions. |
Start dateType: text Required: False | Sync registrations and sessions created from this date, in YYYYMMDD format. Defaults to 20250101. |
Linking OPUSWatch to PostHog
- Go to the Data pipeline page in PostHog
- Click New source and select OPUSWatch
- Fill in the required configuration fields
- Click Next, select the tables you want to sync, and then press Import
Supported tables
| Table | Description | Sync method | Incremental field | Primary key |
|---|---|---|---|---|
client | The OPUSWatch client (company account) the API key belongs to. | Full refresh | — | — |
locations | Locations or areas within the greenhouse or nursery. | Full refresh | — | — |
rows | Physical rows or sections where plants are cultivated. | Full refresh | — | — |
users | People with access to the OPUSWatch system. | Full refresh | — | — |
workers | Workforce members registered in OPUSWatch. | Full refresh | — | — |
worker_groups | Groupings of workers. | Full refresh | — | — |
tasks | Tasks workers can register their work against. | Full refresh | — | — |
task_groups | Groupings of tasks. | Full refresh | — | — |
labels | Labels used to categorize workers, rows, and varieties. | Full refresh | — | — |
varieties | Plant varieties cultivated at the client's locations. | Full refresh | — | — |
registrations | Individual work registrations recorded by workers on their OPUSWatch. | Incremental, Full refresh | updatedTimestamp | — |
sessions | Work sessions with productivity metrics such as counts, performance, and labor cost. | Incremental, Full refresh | updatedTimestamp | — |