◆ PPDM 3.9 ◆ SQL Server ◆ Oracle ◆ Snowflake ◆ 8-Stage Pipeline ◆ FK Auto-Resolution ◆ SEG-Y & P1/90 ◆ Well Log Catalog ◆ Seismic Section Viewer ◆ PPDM Map ◆ Batch Runner ◆ 100K+ Records per Load ◆ AI Help Assistant ◆ ERD Diagrams ◆ Database Explorer ◆ PPDM 3.9 ◆ SQL Server ◆ Oracle ◆ Snowflake ◆ 8-Stage Pipeline ◆ FK Auto-Resolution ◆ SEG-Y & P1/90 ◆ Well Log Catalog ◆ Seismic Section Viewer ◆ PPDM Map ◆ Batch Runner ◆ 100K+ Records per Load ◆ AI Help Assistant ◆ ERD Diagrams ◆ Database Explorer
PPDM 3.9 · SQL Server · Oracle · Snowflake
Data
Wrangler
AI-Assisted Petroleum Data Management
Round up your data. Drive it into PPDM.
⬛ SQL Server
🔶 Oracle
❄️ Snowflake
⚡ Interactive & Batch Processing
🌊 Seismic CatalogSEG-Y · P1/90 · Section Viewer
🔗 Auto FK Detection & Seeding
🗺️ PPDM Interactive MapWells · Seismic · Fields
📏 Built-in Data GovernanceNormalization & Validation
🧠 AI HELP ASSISTANT
Python · Streamlit · SQL Server · Oracle · Snowflake
▶ Full pipeline walkthrough on YouTube
PPDM 3.9 · Petroleum Data Loading PlatformWrangling data since forever
100K+Wells per load
8Pipeline stages
3DB dialects
~45sFull load time
// Pipeline
Eight Stages. Zero Guesswork.
An interactive pipeline walks you from database connection to promoted PPDM rows — with FK dependency graphs, nullable detection, and reconciliation QC at every step.
Pipeline Stages
Click any of the nine stages above to see a description and screenshot for that step of the pipeline.
// Features
Built for Petroleum Data and Energy.
An end-to-end platform for loading, cataloging, and governing petroleum data — from raw files to a fully populated PPDM 3.9 schema.
📐
PPDM Data Loading
Interactive 8-stage pipeline loads wells, fields, and business associates into PPDM 3.9. FK dependency graph resolves foreign keys automatically. Supports SQL Server, Oracle, and Snowflake.
📂
Standard Formats Catalog
Load and search LAS, DLIS, LIS, SEG-Y, and UKOAA P1/90 files. Auto-match to PPDM wells by UWI. Includes survey maps and seismic section viewer. Export original file copies on demand.
🏛
Data Governance
Built-in normalisation (TRIM, UPPER, ISO dates) and schema-aware validation catch bad data before it reaches PPDM. Fingerprint-based column mapping eliminates manual remapping on repeat loads.
🤖
AI Assistant
Ask questions about your data in plain English. The built-in AI assistant queries your PPDM schema, explains table relationships, and helps diagnose load errors — no SQL required.
// Compatibility
Three Databases. One Tool.
Point Data Wrangler at whichever database your shop runs. Connection string in, data out.
For evaluation licenses contact: support@datawranglersolutions.com
// Live Demo
See It In Action
Watch Data Wrangler load 100,000+ wells into PPDM 3.9 — FK auto-resolution, entity seeding, LAS ingestion, and full reconciliation QC.
Watch on YouTube
Database Data Wrangler — Full Pipeline Walkthrough
Petroleum data loaded into PPDM 3.9 across SQL Server, Oracle, and Snowflake. 8-stage interactive pipeline with FK resolution and entity auto-seeding.
Pipeline Stages Covered
01ConnectDatabase connection setup — SQL Server, Oracle, or Snowflake
03NormalizeDate format detection, string truncation, type coercion
04Select PPDM TableChoose target PPDM 3.9 table and schema
05Column MappingFingerprint-based auto-mapping to PPDM target columns
06FK ResolutionDepth-first FK graph walk, entity table auto-seeding
07ValidationSchema-aware type and nullability checks, bad row export
08PromotionINSERT to PPDM target, QC reconciliation diff, row count confirmation
// Tools · Page 1 of 2
Built-in Tools
Data Wrangler ships with a full suite of tools accessible from the sidebar. Screenshots load automatically when you place the image files in the same folder as this page.
// Tools · Page 2 of 2
Built-in Tools
Data Wrangler ships with a full suite of tools accessible from the sidebar. Screenshots load automatically when you place the image files in the same folder as this page.
