2.0 Database Requirements

If you choose to use a database for the ZENworks database other than the embedded Sybase SQL Anywhere database that is available as the default for ZENworks 2017, the database must meet the following requirements:

Item

Requirement

Database Version

  • Oracle 11g R2 with version 11.2.0.4 Standard, Enterprise Edition and Oracle RAC (with or without partitioning). For information about partitioning, see Oracle Enterprise with Partitioning.

  • Oracle 12c R1 with version 12.1.0.2 Standard, Enterprise Edition and Oracle RAC (with or without partitioning).

  • Oracle 12c R2 with version 12.2.0.1 Standard, Enterprise Edition and Oracle RAC (with or without partitioning).

    NOTE:If you are planning to use Oracle Real Application Clusters (Oracle RAC) with ZENworks, see the following information:

  • Microsoft SQL 2008 SP3 and higher, including Cluster (Standard and Enterprise editions)

  • Microsoft SQL 2008 R2 and higher, including Cluster (Datacenter, Standard and Enterprise editions)

  • Microsoft SQL Server 2012 SP3 and later, including Cluster (Standard, Enterprise, and Business Intelligence editions)

  • Microsoft SQL Server 2014and later, including Cluster (Standard, Enterprise, and Business Intelligence editions)

  • Microsoft SQL Server 2016, including Cluster (Standard and Enterprise editions)

  • Microsoft SQL Server 2017, including Cluster (Standard and Enterprise editions)

  • Sybase Anywhere 17 (and latest Electronic Bug Fix)

  • PostgreSQL 9.5.

  • PostgreSQL 10.x (supported only on an external server)

    NOTE:

    • PostgreSQL 10.x is not supported as an embedded database.

    • Embedded PostgreSQL can support a maximum of 5000 devices and external PostgreSQL can support a maximum of 20,000 devices.

Database Server Hostname

The database server hostname must be resolvable by the Domain Name Server Service.

TCP Ports

The server must allow Primary Server communication on the database port. For MS SQL, ensure that you configure static ports for the database server.

Default Ports:

  • 1433 for MS SQL

  • 2638 for Sybase SQL

  • 2639 for Audit Sybase DB

  • 1521 for Oracle

  • 54327 for embedded PostgreSQL

  • 5432 for external PostgreSQL (you can assign a different port, if required.)

You can change the default port number if there is a conflict. However, you must ensure that the port is opened for the Primary Server to talk to the database.

UDP Ports

1434 for MS SQL (if ZENworks uses named instance of the database)

WAN Consideration

Primary Servers and the ZENworks database must reside on the same network segment. Primary Servers cannot write across a WAN to the ZENworks database.

Default Character Set

For Sybase, the UTF-8 character set is required.

For MS SQL, ZENworks does not require any specific character set. ZENworks supports all character sets supported by MS SQL.

For Oracle, the NLS_CHARACTERSET parameter must be set to AL32UTF8, and the NLS_NCHAR_CHARACTERSET parameter must be set to AL16UTF16. If the existing Oracle Database is installed with another character set, then to migrate to the AL32UTF8 character set, contact Oracle Support.

Collation

ZENworks is not supported with a case-sensitive instance of the MS SQL database. Therefore, you must ensure that the database is case insensitive before setting it up.

Database User

Ensure that there is no restriction for the ZENworks database user to connect to a remote database.

For example, if the ZENworks database user is an Active Directory user, ensure that the Active Directory policies allow the user to connect to a remote database.