Labs · open source

Tools we open-source

Small, focused, free tools that come out of the integration work we do — the kind of thing you'd want on day one of a transfer. Use them, fork them, or have us wire the full version into your estate.

Canonical schema mapper

On GitHub

Introspects a source and target schema and scaffolds a field-mapping file you can hand-tune — the starting point for any transfer.

Works across BannerWorkdayOracleSalesforce

IDoc parser

On GitHub

Segment-aware SAP IDoc → JSON parser. Turns positional IDoc payloads (MATMAS, DEBMAS…) into clean, typed objects.

Works across SAPECCREST

Ethos change tailer

On GitHub

Subscribes to Ellucian Ethos change-notifications and prints normalized, deduplicated events — a drop-in for building webhooks.

Works across EllucianBannerEthos

FOAPAL → worktag crosswalk

In development

Generates a Banner FOAPAL to Workday worktag crosswalk, flagging grant and fund restrictions that must survive translation.

Works across BannerWorkday

LTI roster diff

In development

Compares an SIS section roster against LMS membership over LTI Advantage NRPS and emits the exact add/drop delta.

Works across SISCanvasMoodle

Effective-dated linter

In development

Validates effective-dated history sequences (PeopleSoft / Fusion) so a migration never lands broken retro-calculations.

Works across PeopleSoftOracleFusion

Flat-file → canonical loader

In development

A generic flat-file to canonical-model transformer driven by a mapping config — replaces one-off ETL scripts.

Works across CSVRESTETL

Webhook replay / DLQ

In development

Replays failed webhook desoonries from a dead-letter queue with backoff, so a downstream outage never loses events.

Works across WebhookEvent

Resilient API client

In development

A retry / backoff / rate-limit wrapper for flaky ERP and SaaS APIs — the boring layer every integration needs.

Works across RESTSAPSalesforce

EDA affiliation builder

In development

Builds Salesforce EDA Affiliations and Course Connections from a constituent feed, preserving program/term relationships.

Works across SalesforceCRM

SFTP drop watcher

In development

Polls an SFTP inbox for new batch extracts, validates each against a manifest, and hands the clean files off — the front door of any nightly feed.

Works across SFTPBatchETL

File contract validator

In development

Checks an inbound flat file against a declared column contract — types, required fields, enums, row counts — so a bad extract fails before it ever loads.

Works across CSVBatchETL

Snapshot delta differ

In development

Diffs today's full extract against yesterday's to emit inserts, updates, and deletes — change-data-capture for source systems that have none.

Works across BannerColleagueETL

OAuth token broker

In development

Fetches, caches, and refreshes OAuth2 client-credentials tokens for Ethos, Workday, and Salesforce APIs — the auth plumbing every connector re-invents.

Works across EllucianWorkdaySalesforce

SCIM provisioning builder

In development

Turns an identity feed into SCIM 2.0 create / update / deactivate operations, so downstream accounts track your source of truth.

Works across SCIMOktaEntra

Person match / dedupe

In development

Matches inbound constituents against existing records by deterministic keys with a fuzzy fallback, so a load never creates duplicate contacts.

Works across BannerSalesforceCRM

Term code normalizer

In development

Normalizes academic term codes across Banner, PeopleSoft, and Workday into one canonical term with start and end dates.

Works across BannerPeopleSoftWorkday

Load reconciler

In development

Reconciles a completed load against its source by row counts and field checksums, producing the sign-off report a migration needs.

Works across SalesforceOracleMigration

Need one of these built into your systems?

The open tools are the demo. The production version — wired to your live estate, with the safeguards and support — is an engagement.