The E2 ERP uses two different backend systems for data storage. The iDashboards connection will connect to either of these backend systems. The small E2 environment uses a Microsoft Access backend, while the larger environments use Microsoft SQL Server backend. The below instructions will walk you through the setup of both types of the configuration first Microsoft Access then Microsoft SQL Server.
Setting up E2 ERP with Microsoft Access backend
The following applies only to iDashboards v9.1 and earlier, or later versions which are running 32-bit Tomcat and Java 1.7.
Download and install the appropriate Microsoft ODBC driver for your version of Microsoft Access. This driver should be installed on your iDashboards server.
- For Access 2013, download and install the 32 bit Microsoft Access Database Engine 2010 Redistributable from here: https://www.microsoft.com/en-us/download/details.aspx?id=13255
- For versions of Access prior to 2013, download and install the 32 bit Microsoft 2007 Office System Driver: Data Connectivity Components from here: https://www.microsoft.com/en-us/download/details.aspx?id=23734
Setting up E2 ERP with Microsoft SQL Server backend
- Download the latest JDBC driver from the sourceforge.net.