SQLConverter
This sheet summarizes value, pricing and use cases. From here you can move to the dedicated areas or to the client portal for the next action.
Multi-dialect SQL conversion platform and ETL integration: from dialect conversion to extraction of legacy AS/400 and DB2 schemas, to ETL pipelines with 25+ connectors, AI (NL2SQL in Italian), and native GDPR compliance.
What it solves
- Migrazioni DB lunghe e costose (ETL custom 100k+ EUR)
- Dati bloccati in sistemi legacy AS/400 e DB2
- GDPR Compliance/BillPA and SQL Injection risks
- Manual conversions between SQL dialects prone to errors
What it does
SQLConverter Pro was born as a multi-database SQL converter and grew to become a complete platform for data conversion, migration, and integration, with a strong focus on the Italian market. It converts DDL and queries between the main dialects managing auto-increment, data types, and syntax differences, then extends everything with an ETL engine, a compliance layer, and an AI-based assistant.
| Module | What it does |
|---|---|
| SQL Converter | Translates DDL/queries among 7 dialects with type management, auto-increment and conversion comments |
| Schema Migration | Extracts schema from live DB, generates target DDL, applies in transaction with rollback |
| Assessment | Classifies objects by complexity (automatic / assisted / manual) and estimates effort before migration |
| ETL Engine | Extract-Transform-Load pipeline with over 40 connectors, scheduling and monitoring |
| Compliance | GDPR checker, SAF-T Italy, Electronic Invoice PA, audit trail, SQL injection scanner |
| AI Assistant | Natural Language to SQL (IT/EN), query optimizer, anomaly detection, smart data catalog |
| Data Warehouse & BI | DW builder (star schema), reusable metric semantic layer, column-to-column lineage, reconciliation vs baseline |
Key Features
- SQL Conversion between PostgreSQL, MS SQL Server, SQLite, Oracle, MySQL, IBM DB2 and DB2/400 based on sqlglot with dedicated pre/post-processing.
- Headless end-to-end schema migration: extraction via reflection, DDL generation, transactional apply.
- Migration assessment in traffic light style to estimate times and risks before execution.
- Over 40 ETL connectors: databases, cloud (AWS S3, BigQuery, Azure), files (CSV, Excel, JSON, XML, Parquet), protocols (REST, Kafka, MQTT, Modbus), Italian ERPs (TeamSystem, Zucchetti, Passepartout, Odoo), e-commerce (WooCommerce, Shopify, PrestaShop, Magento) and POS (Cassa in Cloud, SumUp, Axerve).
- Import from external BI/ETL tools (Talend, Qlik, Power BI, Cognos, SAS) to an internal canonical model.
- Compliance suite: personal data detection and GDPR anonymization, SAF-T and Fattura PA generation, immutable audit trail, SQL vulnerability scanner (OWASP).
- AI Assistant: from natural language to SQL in Italian and English, query optimization with index suggestion, anomaly detection and automatic data cataloging.
- DW builder with star schema, materialized views, semantic layer of metrics and reconciliation of totals against a baseline Excel/CSV.
- Batch conversion, performance profiling, reporting and templating.
Architecture
The product is built around a headless Python core (Qt-free) that concentrates all the conversion, migration, and ETL logic. The SQL conversion relies on sqlglot and sqlparse; schema extraction and application use SQLAlchemy; data processing uses pandas. The core is exposed in three ways: a desktop GUI in PyQt5, a CLI, and a REST API in FastAPI (an HTTP adapter over the core, with authentication, asynchronous jobs, and observability). Above the API runs a management console in Angular that can be packaged as a desktop Electron app. ETL adopts an extendable plugin system with JSON configuration; core functions are designed as pure and testable functions. Runtime storage on files (presets, history, logs) and SQLite for audit trail.
Requirements
- Operating system: Windows 10/11 x64 or Linux x86_64 (kernel >= 5.x).
- Runtime: Python 3.8 or higher (3.8-3.12 supported).
- RAM: Minimum 2 GB, recommended 4 GB; approximately 200 MB of disk space plus the space for projects.
- Main dependencies: PyQt5, sqlglot, sqlparse, SQLAlchemy, pandas, numpy, PyYAML, cryptography.
- Optional database drivers and ETL connectors installable as extra pip packages (mysql, postgres, oracle, mongodb, cloud, etc.).
- For GUI: screen resolution >= 1366x768. No administrator privilege required for user installation.
Compliance & regulations
Regolamento generale sulla protezione dei dati (UE 2016/679)
Rilevamento automatico di dati personali e sensibili (email, codice fiscale, partita IVA, IBAN), compliance score, anonimizzazione, diritto all'oblio e portabilita' dei dati.
Fattura Elettronica PA / SDI
Generazione e parsing dei tracciati XML FatturaPA (FPR12 e FPA12) con validazione dei campi obbligatori e verifica P.IVA/CF, secondo lo standard del Sistema di Interscambio dell'Agenzia delle Entrate (D.Lgs. 127/2015).
Standard Audit File for Tax (OECD) - Italia
Export della contabilita' in XML validato per i controlli fiscali digitali dell'Agenzia delle Entrate, con moduli master data, general ledger, clienti e fornitori.
OWASP Top 10 (sicurezza applicativa)
Scanner di SQL injection con classificazione di severita', security score e raccomandazioni di remediation; audit trail immutabile delle operazioni.
Reports & dossiers
- Assessment di migrazioneJSON / report strutturato
Stima l'effort di conversione classificando gli oggetti in automatico, assistito e manuale prima di migrare.
- Report di riconciliazioneReport varianze
Verifica che i totali del Data Warehouse coincidano, periodo per periodo, con un baseline Excel/CSV, con tolleranza configurabile.
- Report GDPRTXT / JSON
Documenta dati personali trovati, compliance score e violazioni, pronto per audit.
- SAF-T ItaliaXML
File contabilita' conforme OECD per trasmissione all'Agenzia delle Entrate.
- Fattura Elettronica PAXML (FPR12 / FPA12)
Tracciato pronto per l'invio al Sistema di Interscambio.
- Security scanTXT
Esito della scansione SQL injection con vulnerabilita', severity e raccomandazioni.
- Data qualityTXT
Punteggio di qualita' dati con problemi critici, duplicati, valori mancanti e outlier.
- PerformanceTXT
Profiling di conversioni e pipeline con bottleneck e throughput.
- Audit trailJSON / CSV / TXT
Log immutabile chi/cosa/quando delle operazioni ETL e degli accessi ai dati.
Try it
Da DDS a SQL, riga per riga
Un tracciato record AS/400 che diventa una tabella, con le differenze fra database di destinazione messe in evidenza.
SQLConverter: dai dati sparsi al cruscotto
Vendite, magazzino e contabilita' che diventano una vista sola, e una domanda per filiale che ha risposta subito invece che al prossimo report.
Frequently asked questions
Quanti dialetti SQL converte?
Sixteen. The conversion is available both from the interface and from the command line and REST API, so the same transformation can be done manually on a single case or within an automated procedure on an entire archive.
È un'applicazione da installare?
Yes, SQL Converter Pro is a desktop application, with an added command line and APIs. The choice has a practical reason: the SQL code to be converted often cannot leave the customer's network, and a local application completely avoids the problem.
Can recurrent configurations be saved?
Sì, con i preset, e le conversioni fatte restano nello storico. Su una migrazione vera la stessa combinazione di opzioni si riusa decine di volte, e ricostruirla a mano ogni volta è il modo più semplice per introdurre differenze fra un file e l'altro.
Use cases
PMI: migrazione AS/400 verso PostgreSQL
Estrazione automatica degli schemi DDS legacy e conversione verso DB moderni.
E-commerce: integrazione ETL multi-sorgente
Pipeline ETL tra gestionale, e-commerce e cloud.