Navigation:  System Requirements > Server-side Requirements >

Database (optional)

Previous pageReturn to chapter overviewNext page

Prerequisite for a working Database connection is an installation of a JDBC driver on the application server.

 

Important note: ODBC connections are not supported anymore with Java 8.

Note: JDBC drivers are available for almost any database. Search the database provider websites for detailed information and JDBC driver download. The most important databases like ORACLE or Microsoft SQL Server provide JDBC driver setups for free. In case that no JDBC driver is available for a specific database, then it is possible to use the so called JDBC-ODBC bridge implemented by SUN in the SUN Java Virtual Machine (JVM). Using the JDBC-ODBC bridge it is possible to access the database from JAVA using an existing OBDC data source.

Note: In case of problems in the DB connection between the WebOffice application server and the database, make sure that the corresponding used port is enabled in the firewall of the database.

 

WebOffice 10.8 SP2 supports the following relational database management systems (RDBMS):

Microsoft SQL Server

MySQL

Oracle

PostgreSQL

SQLite

Teradata

UCanAccess

 

Note: Database management systems supported in Esri ArcGIS are listed here: Supported database management systems.

 

The following JDBC driver versions are currently in use with WebOffice 10.8 SP2:

RDBMS

JDBC Driver version

Microsoft SQL Server

8.2.2

MySQL

8.0.17

Oracle

19.7.0.0

PostgreSQL

42.2.12

SQLite

3.27.2.1

Teradata

16.20.00.10

UCanAccess

5.0.0

From WebOffice 10.8 SP2 supported JDBC driver versions

 

SQL Server

To make a connection to a MS SQL Server database, be sure to have a MS SQL Server Native Client installed on the client machine. Follow Microsoft's instructions for the installation of the SQL Server Native Client on your client machine.

 

Note: Please find also more details in the ArcGIS Online help: Add a database server to ArcMap.

 

Oracle

When using Oracle as RDBMS, the installation of a correct Oracle client on your system is necessary:

Administrative computer:

o32bit Oracle client (when using ArcMap - minimum requirement is Instant Client)

o64bit Oracle client when using WebOffice author standalone (the product components to be installed at 64bit - see below - must be considered!)

Since WebOffice 10.8 the WebOffice author standalone is delivered as a 64-bit application. Please note that the ArcMap Connector, which is responsible for the connection to MXDs, is still delivered as a 32-bit application as it is based on the 32-bit based ArcObjects.

GIS- and application server:

o64bit Oracle client

 

Note: Please use in a single server scenario both, 32bit and 64bit Oracle client. 

Note: The installation of the InstantClient is not enough, because too few components are installed.

 

The following software components have to be installed:

 

o32bit

req_database_oracle01

 

req_database_oracle02

 

o64bit

req_database_oracle03

 

req_database_oracle04

 

 

 

PostgreSQL

When using Postgres as RDBMS, additionally install PostGIS and a JDBC driver with the help of your Application Stack Builder. Open the wizard, choose your installed Postgres RDBMS and click Next.

 

Selection of the Pstgres RDBMS in the Application Stack Builder wizard

Selection of the Pstgres RDBMS in the Application Stack Builder wizard

 

Open the node Database Drivers and chose the JDBC driver. Furthermore, open the node Spatial Extensions and choose the PostGIS extension suitable for your Postgres version.

For WebOffice 10.8 SP2, following database versions are supported (minimal requirement):

PostgreSQL 9.4.5 (64 bit)

•  PostGIS 2.1

PostgreSQL 9.3.10 (64 bit)

•  PostGIS 2.1

PostgreSQL 9.2.14 (64 bit)

•  PostGIS 2.0

 

Continue the installation.

 

Selection of the JDBC driver and the PostGIS extension

Selection of the JDBC driver and the PostGIS extension

 

When the installation is complete, open the file pg_hba.conf in the directory <PostgreSQL-directory>\data and insert the following lines:

 

Inserting information about the IP addressing of the server in the file pg_hba.conf

Inserting information about the IP addressing of the server in the file pg_hba.conf

 

Replace the IP addresses with the addresses of your server. You can identify your IPv6 and IPv4 address by entering the command ipconfig in the command line interpreter cmd.exe. Make sure to add a slash and the number of bits to the IP address.

 

Copy the file st_geometry.dll, to be found in the directory <ArcGIS-Client installation directory>\Desktop10.4\DatabaseSupport\PostgreSQL\<PostgreSQL-Version>\Windows64, in the folder <PostgreSQL directory>\lib.

 

Note: See also ArcGIS Online Help: Create a geodatabase in PostgreSQL on Windows.

 

To create an enterprise geodatabase, execute the tool Create Enterprise Geodatabase in ArcMap.

Note: Only use lowercase letters to name your new database.

 

Creation of a new geodatabase by using the tool Create Enterprise Geodatabase in ArcMap

Creation of a new geodatabase by using the tool Create Enterprise Geodatabase in ArcMap

 

Open ArcCatalog and add a Database Connection. Select your newly created database.

 

Database connection in ArcMap

Database connection in ArcMap