Skip to main content

Data Source Drivers

  • Updated

Data Source Drivers

Supported Driver List

Below is a list and the associated links for recommended ADO.NET drivers for each type of data source.

Exceptions, Caveats and Notes

MySQL on Linux v2019.2+

As of v2019.2 the Exago Linux Installer does not install a MySQL ADO.NET driver at the time of installation. Instead, clients wishing to use a MySQL data source for either reporting or for Storage Management will need to provide their own.

Exago has provided wrappers around two popular MySQL data drivers that clients may choose to install on their own.

  • Devart dotconnect free edition
  • MySQL ADO.NET

If you need more product information, including new purchases and upgrades, contact your Exago Customer Success Manager. Install the driver by extracting the contents of the download and then running either installMySql.sh or installDevartMySql.sh as root. Provide the Exago installation path to the installer script. For example:

sudo ./installDevartMySql.sh /opt/Exago

Once installed, update the Admin Console > General > Database Settings to reflect the new data provider.

If using the Storage Management command-line transition utilities add this line to LoadReportsToDb.exe.config between <system.data><DbProviderFactories>:

<add name="dotConnect for MySQL" invariant="Devart.Data.MySql" description="Devart dotConnect for MySQL" type="Devart.Data.MySql.MySqlProviderFactory, Devart.Data.MySql, Version=8.3.215.0, Culture=neutral, PublicKeyToken=09af7300eec23701" />

Oracle.ManagedDataAccess.Client and Npgsql Installation via Nuget

The Oracle.ManagedDataAccess.Client driver for Oracle Data Sources and the Npgsql driver for PostgreSQL Data Sources are installed via the Nuget Package Manager. Therefore, manual editing of Exago’s web.config is required to give Exago access to the drivers.

Using Nuget is beyond the scope of Exago’s documentation, but more information on installation of these drivers can be found at the links below. If you need more information, contact Exago Support.

 

Related articles