Smart Extract is where every modernization begins. It connects to your existing data estate — Oracle, Teradata, SQL Server, Snowflake, or even hybrid platforms — and extracts all SQL assets with integrity, context, and lineage intact. The output is a clean, structured snapshot of your current world, ready for analysis, conversion, and planning.
Positioning
Start your modernization journey with a clean, complete picture of what you already have.
System flow
Full-fidelity extraction for any data system
- Smart Extract securely collects SQLs, schemas, logs, and metadata from diverse systems, producing reusable packages for migration and analysis.
- Multi-source Connectivity: Connect to any database engine — on-prem or cloud — through pluggable connectors. Teradata, Oracle, SQL Server, Netezza, DB2, Hive, Snowflake, and more.
- Object-level SQL Extraction: Automatically extract stored procedures, views, triggers, functions, queries, and DDLs — preserving structure and dependencies.
- Metadata + Stats Collection: Capture table statistics, storage metrics, and query logs to inform Discover’s complexity scoring and Convert’s optimization
- Integrity & Verification: Generate manifests with checksums, row counts, and lineage mapping to ensure completeness and auditability.
- Explore the extraction process
High-level subsystem schematic
- High-level subsystem schematic
- High-level subsystem schematic
Security and governance
- 🔒 RBAC
- 🧱 Residency
- 📜 Auditability
Timeline
- Days 1–2: Connectivity setup, dry runs, and validation of credentials.
- Days 3–5: Full metadata and SQL extraction; integrity verification completed.
- days 6-7: Delivery of standardized bundles; ready for Discover & Convert ingestion.