Objlab
PartnerområdeKundeområdeInternt område
← Tilbage til scenarier
Niveau 2 - ScenariearkSQL Conversion

SQLConverter

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

MålSQLConverter
TilstandLegacy query refactor
links3 links
Observerbare output4 Synlige resultater
Gateway: www.objlab.it·Demo mock: aktiv·Tilstand: Legacy query refactor
Anmod om en guidet demoSe produktdemo
Niveau 3 - Operationel demo

Denne visning viser den operationelle detalje af use casen med mock-data, logs og observerbare output. Den rigtige version kører via LAN-backends eller Objlab-gatewayen.

Tilstand

Demoen bruger syntetiske data og kalder ikke LAN-VM'en direkte.

Mock-metrics

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

Software involveret

  • SQL transformer
  • Schema mapper
  • Diff viewer

Backend og orkestrering

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

Demo-flow

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

Mock-anmodning

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

Mock-svar

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

Synlige resultater

Modernized queryDiffTable mappingMigration notes

Kørselslog

Input

Legacy query with joins and nested subqueries received

Transform

Query rewritten to modern syntax

Review

2 conversions require manual verification