cx
connex
product overview
connex standardizes data across jira, github, salesforce, sap and more into an analytics‑grade model with historical snapshots and near real‑time sync. this demo highlights capabilities not listed on the public landing.
connectors
2 live + many more
snapshotting
custom
update
near real time
loom demo video placeholder — paste your loom embed below
highlights
metrics registry
authoritative definitions (velocity, cycle time, throughput) with inputs, filters, and grains.
ai query layer
natural language to sql safely mapped to the metrics registry and standardized schema.
join templates
prebuilt relationships (jira ↔ github prs ↔ confluence docs) for instant cross‑tool analysis.
governance & rls
row/column‑level security, audit trails, and connector‑scoped permissions.
outbound to bi
push clean tables to power bi, tableau, looker or your warehouse (snowflake, bigquery).
health & alerts
data freshness slas, sync failures, and anomaly alerts to slack/teams.
live feature demo
metrics spec (excerpt)
metrics:
- name: team_velocity
description: sum of story points completed by a team per sprint.
inputs: [issues, sprints, issue_status_history]
grain: sprint
calc: sum(story_points) where status_at_sprint_end = "Done"
dims: [team_id, sprint_id, sprint_end_date]
natural language → sql (sample)
SELECT s.sprint_name, s.sprint_end_date, SUM(i.story_points) AS velocity_points
FROM issues i
JOIN issue_sprint_links isl ON isl.issue_id = i.issue_id
JOIN sprints s ON s.sprint_id = isl.sprint_id
WHERE i.team_id = :team_id
AND s.sprint_end_date BETWEEN :q_start AND :q_end
AND status_at(s.sprint_end_date) = 'Done'
GROUP BY 1,2 ORDER BY 2;
connector roadmap
- live: github, jira
- next (phase 1–2): confluence, azure devops, salesforce, sap, servicenow
- signals (optional): slack, microsoft teams, google drive, sharepoint
- exec systems: workday, netsuite
- warehouses & bi (outbound): snowflake, bigquery, redshift, power bi, tableau