Back to Overview

Technical Architecture

How GX Core + AI Enhancement integrates with your existing data platform

Data Pipeline Architecture

GX + AI integrates after Alteryx loads data into Oracle Staging — Alteryx continues ETL, GX adds intelligent validation

1

Suppliers

CVS, Walgreens
McKesson, Cardinal
+ 146 more
2

Alteryx

Extract & Transform
Standardize formats
Load to Oracle
VALIDATION POINT
3

Oracle Staging

Data lands here
GX reads from here
4

GX Core

Run expectations
Generate Data Docs
Track history
5

AI Layer

Dynamic thresholds
Client impact
Alert if issues
6

EDW

Clean data only
Quality assured
Alteryx Role
ETL: Extract, Transform, Load
GX Core Role
Validate: 300+ checks, Data Docs, History
AI Layer Role
Enhance: Dynamic thresholds, Impact, Predict

Why GX Core? What Alteryx Doesn't Do

Alteryx is great for ETL. GX is purpose-built for data validation at scale.

Reusable Validation Rules

Define once, apply to 150 suppliers. No copy-paste across workflows.

Alteryx: Embedded in each workflow
GX: Expectation Suites

Version Control

Track changes, rollback, audit trail. Know who changed what and when.

Alteryx: Files on shared drive
GX: Git-native YAML

Auto-Generated Reports

HTML validation reports out of the box. Share with stakeholders instantly.

Alteryx: Custom build needed
GX: Data Docs built-in

300+ Built-in Checks

Nulls, uniqueness, ranges, regex, distributions, and more. Ready to use.

Alteryx: Build each from scratch
GX: expect_column_*

Historical Tracking

Compare validation results over time. Spot trends and regressions.

Alteryx: Manual tracking
GX: Checkpoint history

Python/ML Extensibility

Native Python. Easy to add ML models, custom logic, API integrations.

Alteryx: Clunky Python tool
GX: Native Python

The Impact

150
Suppliers with unified rules
300+
Ready-to-use validations
1-click
Validation reports
$0
Additional license cost

AI Layer: The Differentiator

This is what neither Alteryx nor GX Core alone can do. This is the Bounteous value-add.

Dynamic Thresholds

ML models that learn normal patterns and adjust automatically.

  • • Day-of-week patterns
  • • Seasonal adjustments
  • • Supplier-specific baselines

Client Impact Analysis

Know which clients are affected and by how much. Prioritize response.

  • • Dependency mapping
  • • Impact calculation
  • • Priority ranking

Predictive Forecasting

Know about anomalies before they happen. Proactive, not reactive.

  • • 7-14 day forecasts
  • • Confidence intervals
  • • Holiday predictions

Natural Language Queries

Ask questions in plain English. Get answers in seconds.

  • • "Show critical anomalies"
  • • "Which clients affected?"
  • • "Compare CVS vs Walgreens"

How GX Reads from Oracle: Implementation Patterns

Three ways to trigger GX validation after data lands in Oracle Staging

RECOMMENDED

Orchestration-Triggered

Alteryx/Airflow triggers GX after load completes. Most common pattern.

# Airflow DAG
alteryx_load >> gx_validate
# Or Alteryx Python tool
run_gx_checkpoint()
Minimal infrastructure change
Works with existing Alteryx
Latency: Minutes after load
SIMPLEST

Scheduled Micro-Batches

GX runs on schedule, queries Oracle for new/unvalidated records.

# Every 15-30 minutes
SELECT * FROM staging
WHERE validated = 'N'
AND load_time > NOW - 1hr
No workflow changes
Decoupled from ETL
Latency: 15-30 minutes
ADVANCED

Change Data Capture (CDC)

Oracle GoldenGate/Debezium streams changes to Kafka, triggers GX.

# Event stream
Oracle → GoldenGate
→ Kafka → GX Consumer
Near real-time
More infrastructure
Latency: Seconds

Our Recommendation for SHS

Start with Orchestration-Triggered for POC. Alteryx completes → triggers GX → validates → alerts. Minimal change to existing workflows. Can evolve to CDC later if near-real-time is needed.

Integration Points

Oracle Staging

GX connects via cx_Oracle/SQLAlchemy. Reads from staging tables after Alteryx loads.

cx_OracleSQLAlchemy

Alteryx Workflow

Alteryx continues ETL. Optionally triggers GX via Python tool after load completes.

Python ToolREST API

Jira Integration

Automatic ticket creation with anomaly context, client impact, and recommended actions.

REST APIWebhooks

Apache Airflow

Orchestrates the pipeline. Triggers GX after Alteryx, manages dependencies.

DAG SupportGX Operators

Ready to See It in Action?

Explore the interactive demo or learn about the north star vision

Explore DemoNorth Star Vision