VCL Backend: Supported Database Systems

• Dec 12, 2025
• 3 minutes to read

The VCL backend and data connection components support multiple relational database management systems (RDBMS). If you need to connect your ExpressReports or ExpressDashboards-powered application to a particular database, use the corresponding XPO data storage adapter together with a TdxBackendDatabaseSQLConnection component.^[1]

Supported Database Engine List

This section lists all supported database engines (including database provider assemblies), corresponding XPO data storage adapters, and connection string examples.

Microsoft SQL Server & Azure SQL

Microsoft SQL Server and Azure SQL Database are proprietary relational database management systems developed by Microsoft.

Tip

The VCL Backend implementation has built-in support for Microsoft SQL, Azure SQL, and SQLite database engines.

You can use the TdxBackendDatabaseSQLConnection component to connect TdxDashboardControl and TdxReport components to these databases without additional dependencies and extra configuration.

Version	Database Provider Assemblies	NuGet Packages
Microsoft SQL Server 7.0, 2000, 2005, 2008, 2012, 2014, 2016, 2019, 2022, 2025, SQL Azure™	Microsoft.Data.SqlClient.dll 5.*	Microsoft.Data.SqlClient

Connection String Examples

  // Microsoft SQL Server
  XpoProvider=MSSqlServer;Data Source=(local);User ID=username;Password=password; Initial Catalog=database;Persist Security Info=true
  // Azure SQL
  XpoProvider=MSSqlServer;Data Source=tcp:YourServerName.database.windows.net;User Id=azureuser;Password=password;Initial Catalog=DXApplication384

SQLite

SQLite is an open-source relational database engine.

Tip

The VCL Backend implementation has built-in support for Microsoft SQL, Azure SQL, and SQLite database engines.

You can use the TdxBackendDatabaseSQLConnection component to connect TdxDashboardControl and TdxReport components to these databases without additional dependencies and extra configuration.

Version	Database Provider Assemblies	NuGet Packages
SQLite 3	Microsoft.Data.SQLite.dll 8.* System.Data.SQLite.dll 2.*	Microsoft.Data.SQLite System.Data.SQLite

Connection String Example

  XpoProvider=SQLite;Data Source=filename

In-Memory

To bind TdxDashboardControl and TdxReport components to data stored in memory (in JSON format), use the TdxBackendInMemoryJSONConnection component.

You can use the TdxBackendInMemoryJSONConnection.ConnectionString property to:

• Directly specify data as a JSON string.
• Specify a Web Service Endpoint URL or a path to the source JSON file.

Connection String Examples

  // A Web Service Endpoint URI example
  Uri=https://northwind.netcore.io/customers.json;Username=user; Password=pwd; header:MyAuthHedaer1=secretToken1; header:MyAuthHeader2=secretToken2; query:id=123456;query=name=MyName
  // A JSON data string example
  Json=''[{"id":1, "caption":"test1"},{"id":2, "caption":"test2"}]''

PostgreSQL

PostgreSQL is an open-source relational database management system.

Versions	Database Provider Assembly	NuGet Package
PostgreSQL 7, 8, 9, 10, 11, 12, 15, 16, 17, 18	Npgsql.dll 9.*	Npgsql

Connection String Example

  XpoProvider=Postgres;Server=127.0.0.1;User ID=MyUserName;Password=MyPassword; Database=MyDatabase;Encoding=UNICODE

MySQL

MySQL is an open-source relational database management system.

Version	Database Provider Assemblies	NuGet Packages
MySQL 5.0, 5.1, 5.7, 8.0.31, 9.1.0	MySql.Data.dll 9.* MySql.Connector.dll 2.*	MySqlConnector MySql.Data

Connection String Example

  XpoProvider=MySql;Server=MyServerAddress;User ID=MyUserName;Password=MyPassword;Database=MyDatabase;Persist Security Info=true;Charset=utf8

Oracle

Oracle Database is a proprietary multi-model database management system developed by Oracle Corporation.

Versions	Database Provider Assembly	NuGet Package
Oracle 9i, 10g, 11g, 12c, 18c, 21c, 23ai	Oracle.ManagedDataAccessCore.dll 23.*	Oracle.ManagedDataAccess.Core

Connection String Example

  XpoProvider=Oracle;Data Source=TORCL;User ID=MyUserName;Password=MyPassword

Firebird

Firebird is an open-source SQL relational database management system.

Versions	Database Provider Assembly	NuGet Package
Firebird 1.5, 2.5.7, 3.0.2, 5.0.1	FirebirdSql.Data.FirebirdClient.dll 10.*	FirebirdSql.Data.FirebirdClient

Connection String Example

  XpoProvider=Firebird;DataSource=localhost;User=SYSDBA;Password=masterkey; Database=MyDatabase.fdb;ServerType=0;Charset=NONE

Footnotes

1. If you need to store data in memory, use the TdxBackendInMemoryJSONConnection component instead.