Objlab
Área de partnersÁrea de clientesÁrea reservada
← Volver a escenarios
Nivel 2 - Ficha de escenarioSQL Conversion

SQLConverter

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

TargetSQLConverter
ModoLegacy query refactor
enlaces3 enlaces
Outputs observables4 Outputs observables
Gateway: www.objlab.it·Demo mock: activa·Modo: Legacy query refactor
Solicita una demo guiadaVer demo del producto
Nivel 3 - Demo operativa

Esta vista muestra el detalle operativo del caso de uso con datos mock, logs y outputs observables. La versión real se ejecuta a través de backends LAN o del gateway de Objlab.

Modo

La demo usa datos sintéticos y no llama directamente a la VM en LAN.

Métricas 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 involucrado

  • SQL transformer
  • Schema mapper
  • Diff viewer

Backend y orquestación

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

Flujo de la 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"] }

Outputs observables

Modernized queryDiffTable mappingMigration notes

Log de ejecución

Input

Legacy query with joins and nested subqueries received

Transform

Query rewritten to modern syntax

Review

2 conversions require manual verification