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.