Skip to content
/

Access via the JTL database

GuideLast checked on 15/10/2026

Read the migration directly from the JTL-Wawi SQL Server – with full history, subscriptions, supplier invoices and number range counters.

JTL-Wawi stores everything in a Microsoft SQL Server database, usually named eazybusiness. With this route, the jtl-bridge helper reads the data directly from there – without any REST server or app registration. It is the most complete route.

What you need

  • A computer on the company network that can reach the Wawi's SQL Server (often the Wawi server itself).
  • The server name (or IP), if applicable the instance (e.g. JTLWAWI) and the port, if not the default one.
  • A database user. Ideally, create a dedicated user with read permission only on the database – jtl-bridge never writes anything to your Wawi.

Step by step

  1. Open Settings → Data migration → Migration from JTL-Wawi, step Connect source, and choose JTL database.
  2. Fill in SQL server, Instance (optional), Database (usually eazybusiness), Port (optional), User and Password.
  3. Switch on Encrypt the connection to the SQL server if your SQL Server offers encrypted connections.
  4. Click Save source. The password is stored encrypted and only handed out to jtl-bridge.
  5. On the right, click Create import token and copy the token – it is shown only once.
  6. On the computer in the company network, run the check first: jtl-bridge check --url https://erp.allverto.cloud --token avjtl_… jtl-bridge reports the Wawi version and the company and checks whether all required tables and columns exist (“Schema-Prüfung: alle benötigten Tabellen und Spalten vorhanden.” – schema check: all required tables and columns present).
  7. Then upload: jtl-bridge upload --url https://erp.allverto.cloud --token avjtl_…
  8. In allverto, the Detected source box shows the version, company and time of the last upload. Continue with Data found.

What is only possible via the database

  • Subscriptions (recurring orders from JTL)
  • Supplier invoices
  • Lines of invoice corrections
  • Number range counters exactly as the Wawi keeps them
  • Bill of materials components, attribute names and SEPA mandates of customer bank accounts

Versions

The database structure changes between Wawi versions. allverto detects the version and reads accordingly. This route is tested for Wawi 2.1 and 2.2; older versions from 1.5 can usually be read but are not tested. jtl-bridge check reports missing tables or columns before anything is uploaded (“FEHLT: …” (missing) or “Optional fehlt: …” (optional, missing)).

Related topics