Jourier's Data Hub sits between Legalsense and Looker. Legalsense data flows into the layer continuously (real-time CDC where supported, webhooks and polling otherwise), gets modeled to your business, and surfaces in Looker as a clean dataset your team can build utilization reporting, project-margin analytics, and capacity dashboards on top of.

For teams that want more than a packaged BI experience, the same Data Hub feeds a bespoke data application coded in React and TypeScript, owned by your team. Looker runs alongside the bespoke application or in front of it, depending on what each part of the business needs.

Capacity planning against Legalsense needs forward-looking allocation joined with backward-looking actuals. Jourier holds both in the modeling layer so the planning conversation references the same numbers as the actuals review the next quarter.

Looker's API and embedded analytics make Legalsense dashboards composable into the rest of the application surface. Jourier exposes the Legalsense explores through the Looker API so internal tools and customer-facing dashboards both read from the same modeled layer — without forking the metric definitions.

Result: Looker reports on Legalsense read from a layer engineered for utilization reporting, with definitions consistent across reports and across the rest of the operational stack.

Looker is a per-seat licence model that becomes punishing as your business grows. Legalsense reporting locked behind Looker means every business stakeholder needs a seat, and every change goes through Google's pace. Jourier's bespoke data application, coded in React and TypeScript and owned by your team, replaces Looker for Legalsense on your timeline. The same Data Hub feeding Looker today feeds the new application tomorrow.

Can I connect Legalsense to Looker through Jourier?

Yes. Jourier builds a bespoke Legalsense → Looker integration through the Data Hub layer. Legalsense data is modeled, kept current, and exposed to Looker as a clean dataset your team can build utilization reporting on top of. The same modeled tables can feed coded React applications and AI assistants alongside Looker, so the numbers stay consistent regardless of which surface a stakeholder uses. No connector licence fees if you self-host the data layer.

Is the Legalsense → Looker sync real-time?

Where Legalsense supports change-data-capture, yes — updates surface in Looker within seconds. Where it doesn't, scheduled polling and webhooks keep the layer current at the cadence the business actually needs (5 minutes for operational dashboards, hourly for finance, daily for archival). Time to first sync is typically instant to one day. The Data Hub holds the canonical state, so reports and dashboards never read directly from Legalsense's API.

What does a Legalsense → Looker engagement cost?

Bespoke project, scoped to the Legalsense workflows that matter and the Looker reports your team actually uses. Pricing is project-based, not subscription-based — a fixed-fee build for the data layer + the Looker dataset, then optional managed-services if you want Jourier to run it. No per-seat licences from Jourier, no platform fees if you self-host. Looker licences are paid directly to Google; we never mark them up.

Who owns the Legalsense → Looker integration code?

You do. Pipelines, data model, semantic layer config, Looker dataset definitions, documentation: all yours. Self-host or have us host. Hand it to another vendor whenever you want, or take it over with your own team. Jourier delivers everything as code in a repository you own, with runbooks for how to operate it. No lock-in, no per-engagement licence.

Can I move off Looker later but keep the Legalsense integration?

Yes. The Data Hub feeds Looker today, and the same layer feeds open-source dashboards (Apache Superset, Metabase, Grafana), a bespoke React application, or a different vendor BI tool tomorrow. The Legalsense side of the integration — the pipeline, the modeling, the access controls — is unchanged when you switch front-ends. Most of our customers keep multiple consumers running in parallel during a transition window.

How long does a Legalsense → Looker engagement take?

First sync of Legalsense data is typically instant to one day. A scoped engagement covering Legalsense plus the Looker reports that matter usually runs four to eight weeks. Bigger transformations are split into phases, each shipping value before the next begins. Jourier handles the Legalsense pipeline, the modeling, the Looker dataset, and the access controls. Your team validates the reports and trains the analysts.

Can existing Looker reports built on Legalsense be migrated to the new model?

Usually yes. Most existing Looker reports become thin wrappers over the new modeled tables — the report logic stays, the data source switches from a direct Legalsense connector to the Data Hub. Jourier audits the existing Looker workspace, identifies what's worth keeping, and rebuilds report-by-report against the new model. Reports that were workarounds for Legalsense's data shape get simplified or retired.

How do permissions work for Looker pulling Legalsense data?

Permissions live in the Data Hub, not in Looker. Each Looker user authenticates against your identity provider; the dataset that Looker reads is filtered server-side based on the user's role, region, or department. Looker's own row-level security still works on top of this. Result: a sales rep in Helsinki and one in New York hitting the same Looker dashboard see different rows automatically, with the rule defined once in the layer.

Get started

Let’s discuss connecting Legalsense to Looker.

Book a meeting
Aleksi Stenberg Founder & CEO