Objlab
Area partnerArea clientiArea riservata
← Torna agli scenari
Livello 2 - Scheda scenarioSQL Conversion

SQLConverter

A scenario for converting legacy SQL, mapping tables, and refactoring complex queries with a guided view.

TargetSQLConverter
ModalitàLegacy query refactor
collegamenti3 collegamenti
Output osservabili4 Output osservabili
Gateway: www.objlab.it·Demo mock: attiva·Modalità: Legacy query refactor
Richiedi una demo guidataGuarda la demo del prodotto
Livello 3 - Demo operativa

Questa vista mostra il dettaglio operativo del caso d'uso con dati mock, log e output osservabili. La versione reale gira tramite backend in LAN o il gateway Objlab.

Modalità

La demo usa dati sintetici e non richiama direttamente la VM in LAN.

Metriche mock

  • Queries converted: 94 - Guided conversions in the lab
  • Tables mapped: 31 - Normalized and reusable relationships
  • Legacy risks: 6 - Patterns to review before release

Software coinvolti

  • SQL transformer
  • Schema mapper
  • Diff viewer

Backend e orchestrazione

  • www.objlab.it gateway
  • SQLConverter API
  • review log

Flusso demo

  1. Paste the query
  2. Choose the target
  3. See the conversion
  4. Compare output and differences

Mock request

{ "source": "legacy_sql", "dialect": "oracle", "target": "postgres", "mode": "conversion" }

Mock response

{ "status": "ok", "converted": true, "tables": 31, "warnings": ["ROWNUM -> LIMIT", "CONNECT BY -> CTE"] }

Output osservabili

Modernized queryDiffTable mappingMigration notes

Log di esecuzione

Input

Legacy query with joins and nested subqueries received

Transform

Query rewritten to modern syntax

Review

2 conversions require manual verification