Connected Agents
Registered Agents
Add Agent
Browse Sync Data
Trigger Manual Sync
Runs the sync job now for yesterday's data.
Backfill Historical Data
Re-sync past data day by day into storage. Runs in the background on the agent — may take several minutes for large date ranges.
Requires backfill_query in agent config.json using @sync_date parameter.
On-Demand Query
REST API Keys
Create API Key
JWT Tokens
Issue New Token
Change Password
Admin Users
Create User
Storage Settings
Per-Merchant Storage
Assign a dedicated S3 bucket or local path to a specific merchant. If not configured, the merchant uses the global storage above.
Add / Edit Merchant Storage
Storage Usage — Raw Sync Data
Storage Usage — Analytics Results
Pre-computed DuckDB summaries written back to object storage after analytics jobs run.
Stored under analytics/{merchant}/{db}/{job}/{date}_{summary}.json.
Analytics Servers
Analytics servers run DuckDB to pre-compute summaries from raw sync data stored in object storage. Object storage credentials are inherited automatically from the Storage settings above.
Add / Edit Server
Global Analytics Settings
Uses DuckDB inside this process to pre-compute summaries. No separate analytics VM required.
Requires duckdb, node-cron, axios to be installed
(npm install in the server/ folder, then restart).
A dedicated analytics server registered above will always take priority for its assigned merchants.
0 2 * * * = 2:00 AM daily ·
0 */6 * * * = every 6 hours ·
30 1 * * * = 1:30 AM daily
Auto-Compute Job Configuration
Define which merchant / database / jobs the scheduler auto-computes each night, and which summary types to generate for each job.
Add Job
Merchant → Server Routing
Assign a dedicated analytics server to specific merchants. Unassigned merchants use the default server.
Manual Compute
Trigger analytics computation for a specific merchant / database / job / date. Use Compute All Dates to backfill analytics for all available data.
⚙️ EHUB Config Generator
Paste your SELECT queries → auto-generates sync_jobs and queries config for config.json
📋 Query Templates — AutoCount Standard Jobs
▼Click any Copy button to copy the SQL — then paste into the PowerShell wizard (right-click in the terminal window)
Step 1 — Paste SQL Queries
Step 2 — Detected Tables & Settings
Step 4 — Generated Config
Replace the sync_jobs and queries sections in your config.json with the content below.
Agent Config Validator
Paste your config.json below to check for syntax errors and structural issues
before saving to the agent machine.