Database (optional)
Prerequisite for a working database connection is installation of a JDBC driver on the application server.
|
•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 R4 supports the following relational database management systems (RDBMS):
|
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 R4:
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.
|
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). |
|
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!)
|
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
|
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
•64bit
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
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 R4 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
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
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.
|
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.
|
Only use lowercase letters to name your new database. |
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