An open source project by

| 

  • More products

    Products

    i4FSMarketplace

    +

    i4Apps

    A marketplace for factory Apps. Designed to connect industry and developers.

    For Industry

    i4Support

    A support team of 4.0 industry professionals.

    i4Integration
    4.0 industry project integrators.
    i4Customisations

    A dedicated team of customisers for your own project.

    For Developers

    i4Platform

    A containerised environment to manage 4.0 industry apps.

    i4Assets

    Components that make part of 4.0 industry apps.

    i4Tools
    A set of developer tools to build 4.0 industry apps.
Components
Sign up
Sign up
Home
>
>
>
>
>
ODBC Connector

ODBC Connector

The ODBC connector uses the Open Database Connectivity (ODBC) interface and provides standards configurations for database connection. Any ODBC-compliant application can access any DBMS.

The proposed API implements the standard ODBC functions (78) and additional specific ones. This way, it ensures the conformance to ISO 92, ODBC and the Open Group designations. Therefore, it contains all Minimum and Core SQL grammar and an extended set of statements and datatypes that support common DBMS extensions (to SQL) to ensure the proper ODBC driver SQL conformance level. Hence, the ODBC connector offers access for MySQL, PostgreSQL, Oracle and DB2 DBMS. It proposes several options as:

  • Establishing connections
  • Connection options (charset, connectTimeout, dateStrings, …)
  • SSL options

API Connector expose the capabilities of the underlying DBMSs and are not required to implement capabilities not supported by the DBMS. Examples of technologies picked for the development of this API connector are: Yeoman, Loopback, Node.js mysql npm package, Node.js npm package.

Play Video

Connection Configuration

This connector provides different configurations for different types of databases.

Open Connection

This connector provides a way to connect to a database with the selected configuration.

Request to Database

This connector permits to send SQL requests to ODBC databases.

Get Tables from Database

The connector provides a service to show the schema of the ODBC database by displaying all tables.

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.

Wiki

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

Source code

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

API endpoints

Let your infrastructure communicate with the i4 Platform.
Learn more