

(ODBC is another data access technology, the Microsoft implementation of which is included with Windows.) To provide a JDBC interface to Office applications via this native Microsoft interface, a JDBC driver must be able to convert JDBC calls to ODBC calls. However, Microsoft do produce an ODBC driver for the Office suite. Microsoft do not produce a JDBC driver for Jet (the underlying database engine for the Microsoft Office product suite) or Jet's successors the Office Access Connectivity Engine and the Access Database Engine. A JDBC driver implements the JDBC API for a particular database.

JDBC is a Java application programming interface (API) that connects Java to relational databases (and other tabular data, such as spreadsheets and flat files). To interact with a database, a Java application uses a JDBC driver. This article will concentrate on connecting Ignition to Microsoft Access, as that is the database our customers are using with this application. Ignition can connect to databases such as Microsoft SQL Sever and MySQL, enabling SCADA applications to expose external data, store historical information and integrate with other systems.
#MICROSOFT ACCESS DRIVERS SOFTWARE#
MES software is used to supervise and track work on a plant floor. An HMI device presents data to the operator, for example it can present diagnostic data. SCADA software is used to monitor and control industrial processes that exist in the physical world.Īn HMI is the input-output device through which an operator controls an industrial process.

Ignition (formerly known as FactoryPMI) is an industrial software platform for developing Supervisory Control and Data Acquisition (SCADA), Human Machine (HMI) and Manufacturing Execution System (MES) applications.
