Data Integration

Lianja provides a lot of built-in functionality to handle all your data integration requirements.

Lianja provides universal data access via a wide array of APIs that can be used against the Lianja Database and any other database using Virtual Tables to work with data from any client application. These APIs provide secure CRUD operations on your data from anywhere.

Lianja ODBC data access

Open Database Connectivity (ODBC) is an industry standard interface for accessing data in a heterogeneous environment of relational and non- relational database management systems. Based on the Call Level Interface specification of the SQL Access Group, ODBC provides an open, vendor- neutral way of accessing data. Using the Lianja ODBC Driver in conjunction with the Lianja Cloud Server, third party ODBC-aware products have full CRUD (Create, Read, Update, and Delete) access to Lianja data (Local and Remote) no matter where it resides.

Lianja OData Server

OData is a standardized protocol for creating and consuming data APIs. OData builds on core protocols like HTTP and commonly accepted methodologies like REST. The result is a uniform way to expose full-featured data APIs. The Lianja Cloud Server has built-in support for OData. There is no need to write any custom code to use this functionality, you just point at an OData URI and the Cloud Server will perform the requested OData operation returning data in industry standard JSON format. See this article for details.

Working with JSON

Lianja provides the ability to work with JSON.

See Working with JSON for details.

Working with JSON and JQL

JQL leverages the complete flexibility of JSON with the full power of SQL. Created specifically for use with Web and Mobile applications, JQL provides a common query language and JSON-based data model that operates independently from the underlying SQL database.

JQL is based on standard SQL. It has familiar data definition language (DDL), data manipulation language (DML), and query language statements.

The JQL DDL extends SQL with support for a native JSON data type.

The JQL DML provides transparent access to the (possibly nested) members of JSON data columns. You do not need to use any special functions or operators to reference JSON encoded object members as this is handled natively by the JQL engine.

See Working with JSON and JQL for details.

Working with XML

Lianja provides the ability to work with XML documents including a powerful xpath implementation.

See Working with XML documents for details.

Working with external APIs

Lianja provides the ability to work with external http(s) APIs.

See Network requests

Node.js Module

Lianja includes a Node.js module lianjaclouddataservices enabling Node.js applications to connect to a local or remote Lianja Cloud Server and perform a variety of operations.

See Using the lianjaclouddataservices Node.js Module for details.

Python Module

Lianja includes a Python module lianjaclouddataservices enabling Python applications to connect to a local or remote Lianja Cloud Server and perform a variety of operations.

See Using the lianjaclouddataservices Python Module for details.

.NET Assembly

Lianja includes a .NET Assembly lianjaclouddataservices enabling .NET applications to connect to a local or remote Lianja Cloud Server and perform a variety of operations.

See Using the lianjaclouddataservices .NET Assembly for details.