Database (optional)

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

icon_comment

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.

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.9 SP1 supports the following relational database management systems (RDBMS):

Microsoft SQL Server

MySQL

Oracle

PostrgreSQL

SQLite

Teradata

UCanAccess

icon_cross-reference

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

 

The following JDBC driver versions are currently supported in WebOffice 10.9 SP1:

RDBMS

JDBC Driver Version

Microsoft SQL Server

11.2.0

MySQL

8.0.30

Oracle

21.7.0.0

PostrgreSQL

42.5.0

SQLite

3.39.2.1

Teradata

17.20.00.08

UCanAccess

5.0.1

HSQLDB

2.7.0

Jackcess

4.0.2

Supported JDBC driver versions for WebOffice 10.9 R2

SQL Server

To connect to an MS SQL Server database, a supported version of SQL Server Native Client must be installed on the client machine. Follow the instructions from Microsoft to install the SQL Server Native Client on your client machine.

icon_comment

Microsoft SQL Server 2016 and later support TLS 1.1 and TLS 1.2. Updates may be required for earlier versions and dependent libraries. For more information, see KB 3135244: TLS 1.2 support for Microsoft SQL Server (KB 3135244: TLS 1.2 support for Microsoft SQL Server).

icon_cross-reference

You can also find more details in the ArcGIS online help under 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!)

icon_comment

Since WebOffice 10.8, the WebOffice author standalone is delivered as a 64-Bit application. It should be noted that the ArcMap connector, which is responsible for the connection to MXDs, is still delivered as a 32-bit application, since it is based on the 32-bit ArcObjects.

GIS and application server:

o64bit Oracle client

icon_comment

In a single-server scenario, both the 32bit and 64bit Oracle clients must be installed on the server.

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

 

The following software components have to be installed:

32bit
 
req_database_oracle01
 
req_database_oracle02

64bit
 
req_database_oracle03
 
req_database_oracle04

PostrgreSQL

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 Postgres RDBMS in the Stack Builder

Selection of the Postgres RDBMS in the Stack Builder

 

Open the node Database Drivers and chose the JDBC driver. Also open the node Spatial Extensions node and select an appropriate PostGIS extension from the list.

For WebOffice 10.9 SP1 the following database versions are supported (minimum requirements):

PostgreSQL 9.4.5 (64 bit)

oPostGIS 2.1

PostgreSQL 9.3.10 (64 bit)

oPostGIS 2.1

PostgreSQL 9.2.14 (64 bit)

oPostGIS 2.0

 

Continue the installation.

Selection of the JDBC driver and the PostGIS extension

Selection of the JDBC driver and the PostGIS extension

 

After successful installation, open the file pg_hba.conf in the directory <PostgreSQL directory\data and add a new line in the section #IPv4 local connections and #IPv6 local connections with the following content:

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. Your IPv4 as well as IPv6 address can be entered in the command line interpreter cmd.exe by entering the command ipconfig to find out. 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-Desktop-Verzeichnis>\DatabaseSupport\PostgreSQL\<PostgreSQL-Version>\Windows64, in the folder <PostgreSQL directory>\lib.

icon_cross-reference

See also ArcGIS online help Create a geodatabase in PostgreSQL on Windows.

 

To create an Enterprise geodatabase open ArcMap and run the tool Create Enterprise Geodatabase.

icon_comment

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. As user name , enter the newly created geodatabase administrator role.

Database connection in ArcMap 

Database connection in ArcMap