Managing SQL databases via the Lianja ODBC Data Source Manager (and the native Windows/Linux ODBC utilities) allows you to securely connect, abstract, and operate external enterprise databases like MS SQL Server, MySQL, or Oracle within the Lianja APaaS platform. The Core Architecture: Virtual Tables
Lianja interacts with external SQL databases through a data-centric mapping layer known as Virtual Tables (VTs).
The Concept: Virtual Tables act as cursor adapters. They point to an external SQL database using an ODBC connection Data Source Name (DSN).
The Benefit: To the frontend developer or user, a Virtual Table behaves exactly like a native, local Lianja database table. You can drag-and-drop it into Lianja UI builders, bind fields natively, and issue standard commands while the underlying driver transparently converts those actions into remote SQL dialect commands. Step-by-Step Configuration Workflow 1. Configure the Machine Data Source (DSN)
Before Lianja can manage the data, you must establish an underlying bridge via your operating system’s ODBC administrator: Using ODBC Drivers with EMS SQL Manager – Devart
Leave a Reply