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.
-
SQL Server
- No external ADO.NET driver needed
-
Oracle
- Oracle ODAC Connector
- Oracle.ManagedDataAccess.Client
-
MySQL/MariaDB
- Devart Connector
- MySql.Data.MySqlClient
- PostgreSQL
-
DB2/Informix
- IBM Data Server Driver Package — 5.exe or newer
-
SQLite v2021.1.8+
- No external ADO.NET driver needed
-
ElasticSearch, Redshift, Snowflake, MongoDB, Google BigQuery
-
Important:
As of v2024.2.1, CData drivers are no longer available for use in Exago BI products. See CData Drivers.
-
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.