lxconnect.de

What It Is

LX Connect is a database access and REST API solution from Co-Orga GmbH for the on-premises versions of Lexware Pro and Premium. The key background is Lexware’s migration from SQL Anywhere to PostgreSQL, after which previously common approaches such as direct ODBC connections, third-party tools, and self-built queries will no longer work. LX Connect aims to provide a new standard path: reading data through a structured Data Warehouse, accessing it via OData, and securely writing data back to Lexware through a REST API.

Core Capabilities

Functionally, it does not directly expose Lexware’s internal database. Instead, it synchronizes data into an optimized data model that supports SQL queries, joins, aggregations, and BI analysis. The target database can be MSSQL, Azure SQL, PostgreSQL, MariaDB, MySQL, or Oracle, and can be deployed locally, on your own remote server, or in a cloud environment. On the API side, it provides read access via OData and write access via REST. Supported write targets include customers, products, orders, invoices, delivery notes, and more, with API key-level permissions and audit logs. The data model is described as publicly documented, with schemas and OpenAPI specifications available for developers and automation tools.

Pricing and Deployment

The product is planned to launch in July 2026 and will offer a 14-day full-featured trial with no payment information required. Official pricing is €99/month or €990/year, both excluding tax; annual billing saves about 17%. Licensing is charged per Lexware installation, not per company, and includes the full Data Warehouse, OData, and REST API feature set. Purchase, payment, and cancellation are all handled inside the software. Payments are processed through Stripe, with support for credit cards and SEPA direct debit.

Pros and Cons

Its strengths are clear positioning and a timely solution to the integration breakage caused by Lexware’s PostgreSQL migration. A unified data model can reduce the learning cost across SQL, OData, and REST access methods. Customer data is processed locally, with external connections mainly used for licensing and payments. The drawbacks are also obvious: the product is not yet officially available; it only supports Lexware 2026+ Pro/Premium on-premises editions with PostgreSQL enabled, and does not support Lexware Office; the Data Warehouse and OData do not guarantee coverage of every field; and custom requirements beyond Lexware’s official API cannot be guaranteed.

Who It’s For and Access from China

It is suitable for companies in Germany or businesses using the on-premises version of Lexware, as well as ERP/CRM integrators, BI teams, and developers who need to migrate away from legacy ODBC workflows. For users in China, the source material does not provide information about network accessibility from China, Chinese-language support, or RMB payment options. Stripe payments and the German/European tax environment may create additional barriers, so access status should be considered unknown. If you use Lexware Office, the official Public API is the more appropriate path. If your need is only downstream analytics, Power BI, Excel, and Tableau can serve as consumption-side tools, but they cannot replace LX Connect’s role as the Lexware connectivity layer.