Skip to main content
The LearnInk data sync provisions a dedicated read-only Postgres database containing all of your organisation’s learning data. It’s updated every 24 hours (at around 3am EAT) and designed to plug directly into BI tools or be queried with SQL. This is the right integration if you want to:
  • Build custom dashboards in tools like Looker, Metabase, or Tableau
  • Join LearnInk learning data with data from other systems (e.g. sales performance, HR data)
  • Run ad-hoc SQL queries against your organisation’s learning data

​
Getting access

Contact support@learn.ink to provision your data sync database. Before access can be granted, you’ll need to provide an IP allowlist — a list of the IP addresses that should be permitted to connect. If you’re connecting via a BI tool (e.g. Looker or Metabase), include those servers’ IP addresses too. We’ll share your read-only credentials via a secure mechanism once the database is provisioned.

​
Database structure

The database contains 11 tables covering users, groups, courses, sequences, learning paths, performance data, and survey responses.

users

User profiles and registration status

user_groups

Group definitions used for content access and segmentation

courses

Course catalogue

sequences

Ordered collections of courses

learning_paths

Assigned learning programmes with deadlines

learningpath_courses

Relationship between learning paths and courses

user_learningpaths

Each user’s learning path status

user_course_performance

Per-user, per-course performance data

user_sequence_performance

Per-user, per-sequence performance data

survey_questions

Survey questions attached to courses

survey answers

Answer options and user responses

​
A note on timestamps

Offline mode: If a user completes courses in offline mode, their progress data is saved with the timestamp of when the activity occurred — not when it synced to the database. This means historical figures (e.g. completions last week) can change as users come back online.Device clock accuracy: A small number of users have incorrectly set device clocks. We are building error handlers to detect and correct this. We’ll keep you updated on progress.

​
Sample queries

Ready-to-use SQL queries to replicate common analytics views: