In addition to automated data connections for any DELMIA Apriso Central Configuration connections, the Dashboard Builder also allows you to establish a connection to various data sources such as SQL databases, XML/CSV data files or OLAP cubes.
The following data source types are supported.
To connect to various SQL databases, DevExpress Dashboard requires corresponding providers to be installed on the DELMIA Apriso server. The table below lists the supported data sources and the required data providers.
| SQL Data Source | Supported Versions | Data Provider | .NET Standard Support |
|---|---|---|---|
|
Microsoft SQL Server |
2005, 2008, 2008R2, 2012, 2014, 2016, 2017, 2019 2005 Express Edition, 2008 R2 Express, 2012 Express, 2014 Express, 2016 Express, 2017 Express, 2019 Express Azure SQL Database |
System.Data.dll (Included in .NET Framework) System.Data.SqlClient |
Yes |
|
Microsoft Access |
2000 or higher |
System.Data.dll |
|
|
Microsoft SQL Server CE |
3.5, 4.0 |
System.Data.SqlServerCe.dll (Included in .NET Framework) |
|
|
Oracle Database |
19c or higher |
The 64-bit Oracle Data Access Components for Windows (19c) Please select the “Configure ODP.NET and/or Oracle Providers for ASP.NET at machine-wide level” option during installation. Oracle.ManagedDataAccess.dll |
|
|
Amazon Redshift |
n/a |
Npgsql.dll |
|
|
Google BigQuery |
n/a |
DevExpress.DataAccess.BigQuery.dll |
|
|
Teradata |
13.0 or higher |
Teradata.Client.Provider.dll |
|
|
SAP Sybase Advantage |
Advantage Database Server 9.1 or higher |
Advantage.Data.Provider.dll |
|
|
SAP Sybase ASE |
Sybase Adaptive Server 12.0 or higher |
Sybase.AdoNet4.AseClient |
|
|
SAP SQL Anywhere |
11 or higher |
Sap.Data.SQLAnywhere |
|
|
IBM DB2 |
9.5 or higher |
IBM.Data.DB2.dll |
|
|
Firebird |
1.5 or higher, Dialect 3 |
FirebirdSql.Data.Firebird.dll FirebirdSql.Data.FirebirdClient.dll |
Yes |
|
MySQL |
4.1 or higher |
MySql.Data.dll |
Yes |
|
Pervasive PSQL |
9.x or higher |
Pervasive.Data.SqlClient.dll |
|
|
PostgreSQL |
7.x or higher |
Npgsql.dll |
Yes |
|
VistaDB |
4, 5 |
VistaDB.5.NET40.dll |
|
|
SQLite |
3.x |
System.Data.SQLite.dll Microsoft.Data.SQLite |
Yes |
|
XML file |
n/a |
n/a |
Yes |
Note that if you use a custom connection string to establish connection to data, you should specify the XpoProvider parameter. Refer to the How to Configure Third Party Connection topic to see how to specify this parameter.
To use the OLAP data source, the following (MS SQL 2019) Analysis Services Client Libraries have to be installed on DELMIA Apriso server:
The following OLAP servers are supported.
The following features are partially supported for OLAP data sources:
The following features are not supported for OLAP data sources: