LXP Connector

The LXP connector uses the SQL Server database Connectivity interface and provides standards configurations for database connection. LXP as ERP use standard SQL Data Base. This specific connector is proposed to reduce the access to different database schemes and allow only access to production data (and not product development data). The proposed API implements the standard SQL Server functions and adds new ones while ensuring the conformance to ISO/CEI 25051 recommendations. Therefore, it contains all Minimum and Core SQL grammar and an extended set of statements and datatypes supporting common DBMS extensions (to SQL) to ensure the proper ODBC driver SQL conformance level. This connector offers several options as:

  • User connection to LXP Database.
  • Change connection configuration (user, database, port, connectTimeout, …).
  • SQL Request to the database (only data fetch for reliability constraints).
  • Basic error handling (SQL Exceptions) for missing data and inconsistent data checking.

The proposed connector fetches the data and return it as JSON via a REST call. The technologies picked for the development of this API connector are: Yeoman, Loopback, Node.js, mssql npm package, and Microsoft SQL Server.

Connection to Database

Provides a connection to an LXP database that can be used to execute queries.

Set Special Configuration

Provides solution to set special configurations to connect the database with another user or server.

Set Default Configuration

Sets database configuration at the default values that will be input at the deployment.

Execute SQL Request

Allows to execute SQL queries and return data as JSON via a REST call.

Additional ressources

Learn more about i4FS by visting the project website for general information, the wiki for information about the core components, the Technical Manual for API documentation, and downloading the repository’s source code.


Get a better understanding of the global architecture and information flow.

Source code

Our source code is opensource and available on our Gitlab repository.

API endpoints

Let your infrastructure communicate with the i4 Platform.