Supported DBMS

Support of work with PostgreSQL DBMS: 13.x, 14.x, 15.x, 16.x, 17.x. Version support periods are given at the PostgreSQL official website.

Support of work with derived DBMS: Postgres Pro, Postgres Pro AXE, Tantor.

It is required to install an application that contains a driver to connect to PostgreSQL, for example:

• Single ODBC driver (recommended).

• PostgreSQL DBMS back end.

• Other commercial applications or open-source applications developed and provided to work with PostgreSQL.

To correctly connect to PostgreSQL DBMS, bitness of Foresight Analytics Platform and installed driver must match. Various driver versions are available at the PostgreSQL official website.

When working in Windows OS, after installing the driver add a path to the bin folder with driver libraries to the PATH system variable. For example, C:\Program Files\psqlODBC\1600\bin\.

Astra Linux SE OS supports PostgreSQL DBMS included in operating system distribution.

Support of work with Microsoft SQL Server DBMS 2014, 2016, 2019, 2022.

It is required to install DBMS front end (Native Client). Connection via the OLE DB and ODBC interfaces is supported.

The front end and installation guide are available at the Microsoft official website.

NOTE. The front end version must not be earlier the DBMS server version.

Support of work with Oracle DBMS 12.x, 18.x.

It is required to install DBMS front end.

To correctly connect to Oracle DBMS, bitness of Foresight Analytics Platform and Oracle DBMS front end must match.

Work with Oracle 12.x is not supported if Oracle Multitenant was enabled on installing server back end.

The front end and installation guide are available at the Oracle official website.

When installing and setting up back end and front end take into account the language settings to be used on data transfer and storage. For details about the language settings, the NLS_LANG parameter and methods for its setting see the developer website.

NOTE. It is not recommended to use the settings that use the variable length of character encoding UTF8 and UTF16.

Support of connection by means of ODBC drivers installed in Windows OS or Linux OS. The web application can connect directly to the database ClickHouse DBMS.

NOTE. They are not used to connect to repository.

An ODBC driver is available at the ClickHouse official website. Connection is similar to Generic ODBC.

During driver installation, copy ANSI and Unicode versions of the driver to the libraries folder. When working with the platform use Unicode version of ODBC driver- clickhouseodbcw.so.

Constraints at working with ODBC driver:

• Available: creating of standard cubes, extracting of changed data, server data aggregation, using subqueries when retrieving data.

• Creation of tables and data insertion are not supported.

• Creating stored procedures/functions and table triggers is not supported.

• The following repository objects cannot work with DBMS: automatic cubes, multidimensional calculation on database server, time series database.

Constraints at working with ClickHouse DBMS directly:

• Available: creating of tables, queries, external tables, views, DBMS commands, and functions. Created tables can be used as data sources for table dictionaries.

• It does not support creating of stored procedures and table triggers.

• The following repository objects cannot work with DBMS: any cube type, MDM dictionary, composite MDM dictionary, multidimensional calculation on database server, time series database.

Support of connection to various data sources via ODBC providers installed in the operating system.

NOTE. They are not used to connect to repository.

It is required to install ODBC drivers in the operating system.

Support of queries and DBMS commands alone. Support of creating and use of tables, views, procedures and functions depending on the functionality of a certain DBMS and its correspondence with SQL standards.

It can be used to connect to supported DBMS (PostgreSQL, Oracle, and so on), data sources (Greenplum, SAP, and so on) by specifying DSN or creating a connection string. The required ODBC driver can be obtained from appropriate manufacturer.

For example, to prepare and connect ODBC driver to Microsoft SQL Server, see the Microsoft documentation, to MySQL - see the MySQL documentation.

Support of connection to data sources based on EMC Greenplum, Arenadata DB DBMS, and PostgreSQL DBMS.

Support of work with derived Pivotal HD Hawq DBMS.

NOTE. They are not used to connect to repository.

It is required to install OLE DB drivers in the operating system.

The Greenplum driver can be used to work with databases created based on PostgreSQL DBMS based server in the read mode. In this case it is not necessary to install ODBC driver.

Support of connection to various data sources via OLE DB providers installed in the operating system. To make the setup easier, Foresight Analytics Platform has selected providers:

• OLE DB (ODBC HIVE);

• OLE DB (ODBC).

NOTE. They are not used to connect to repository.

It is required to install OLE DB drivers in the operating system.

Support of queries and DBMS commands alone. Support of creating and use of tables, views, procedures and functions depending on the functionality of a certain DBMS and its correspondence with SQL standards.