Which guidelines must my external database meet to be connected to DocuWare?
In general DocuWare supports three type of database engines: Oracle, MySQL, Micorosft SQL.
The default database that comes with the software is MySQL Engine. However, you can also use your own database engine instead the one that comes with the software.
(If you are going to use the external database for installation or AUTOINDEX or Select-List the same prerequisites apply.)
Here are some guidelines in preparing the database server before installing or using with DocuWare. The information about adaptation and additional information about other database can be found in http://help.docuware.com.
This FAQ article is to enforce the information already found in the technical reference.
Oracle Database for Installation / Direct Connection
First of all, if you are running Oracle in Windows, you cannot install DocuWare and Oracle database engine in the same server.
In order to install DocuWare using an Oracle Database Engine you need to prepare the database. This is valid both for new installations and upgrading from older versions of DocuWare to new versions. In some instances you may have to remove the old Oracle Client and install the new version of Oracle client. Look at the system requirements which Oracle Client is required for your version of DocuWare.
In Oracle environment all objects created by the installation will reside under a single Oracle user schema.
Until DocuWare 6.11:
Oracle Client has to be installed on the machine where DocuWare Servers will be installed. Please install Oracle client under Windows account (local or domain) which will be running the DocuWare services.
- Make sure that you have an Oracle user has DBA privileges at least for the installation (suggested). This user has to be able to create any database objects and manipulate any objects within that database schema. Once the installation is completed you can restrict its rights.
- 32-bit Oracle Data Access Components (ODAC) have to be installed first: ODAC 11.2 Release 5
Install following components:
- Oracle Data Provider for .NET 4 - 184.108.40.206.0
- Oracle Data Provider for .NET 2 - 220.127.116.11.0
- Oracle Providers for ASP.NET 4 - 18.104.22.168.0
- Oracle Providers for ASP.NET 2 -
- Oracle Database Extensions for .NET 4 - 22.214.171.124.0 - for upgrade only
- Oracle Database Extensions for .NET 2 - 126.96.36.199.0 - for upgrade only
- Oracle Providers for OLE DB - 188.8.131.52.0
- Oracle Objects for OLE - 184.108.40.206.0
- Oracle Services for Microsoft Transaction Server - 220.127.116.11.0
- Oracle ODBC Driver - 18.104.22.168.0
- Oracle SQL Plus - 22.214.171.124.0
- Oracle Instant Client - 126.96.36.199.0
- TNSNAMES.ORA file (required for installation or utilization )
The tnsnames.ora file is a configuration file that contains net service names mapped to connect descriptors for the local naming method, or net service names mapped to listener protocol addresses.
A net service name is an alias mapped to a database network address contained in a connect descriptor. A connect descriptor contains the location of the listener through a protocol address and the service name of the database to which to connect. Clients and database servers (that are clients of other database servers) use the net service name when making a connection with an application (source: https://docs.oracle.com).
The file "tnsnames.ora" contains the information about the Oracle server and its connections. This file can be obtained from a DBA. The file must be placed in the machine where DocuWare will be installed and under a Oracle Client Path Directory (E.g.: C:\app\product\11.2.0\\Administrator).
- Create Windows System Environment variables
- Open the run command (press [Windows]+[R]) and type: sysdm.cpl
- Open Tab "Advanced" and open the menu "Environment Variables..."
- Create a new System variable
- Enter a name and the path where the tnsnames.ora file is located
- Restart the machine where Oracle client was just installed
- Open the run command (press [Windows]+[R]) and type: sysdm.cpl
- Test Oracle Connection with SQLPlus+
Before you install DocuWare you need to make sure that the user can connect to the Oracle server. This will also verify the Oracle user schema is present in the database. You can use any Oracle tool to connect and create a test table. In this example, we use SQLPlus, which you can run in DOS. Here is a screenshot of the process:
- When Authentication server asks to connect to the database server you have to provide the configuration name that is found in the tnsnames.ora file. Typically you will enter the server-name of the database but in Oracle you have to enter the configuration name. You can find this information in your local tnsnames.ora file. The deafult port number for Oracle is 1521.
NOTE: Once the Oracle client has been configured in DocuWare server, authentication server installation will create all database objects required for DocuWare services. There no additional configuration that needs to be done in Oracle server.
Troubleshooting Oracle client
- Verify any logs generated by the setup or application in %programdata%\DocuWare\
- DocuWare support only 32bit of Oracle client
- If your database is in version Oracle 12c, try installing the Oracle 12c ODAC client
- TNS_NAME path is invalid
- Oracle user has no rights or not sufficient rights.
- Server has not been restarted after an Oracle client install
- Port number not been opened from DocuWare server to Oracle server, verify the Oracle server port or firewall
From DocuWare 6.12 on, no ODAC is required
- Make sure MSSQL server is up to date with their service packs (SP), especially if you are using old version of Micorsoft SQL Server.
- Microsoft SQL Server has to be configured with a static port number for installation. Dynamic porting is not support by DocuWare during the installation. The default port for MSSQL is 1433. Also MSSQL Express Edition is not supported by DocuWare.
- To see if SQL server instance has been configured with static or dynamic port you can use the tool called "SQL Server 20xx Configuration Manager"
- Also take a look at the "System Requirements" for each version of DocuWare.
- Micorosft SQL server has to be configured to accept SQL Authentication and Windows Authentication. During DocuWare installation SQL authentication will be utilized. This is typically done in SQL Server Management Studio (for SQL 05/08/12/14/16).
- By opening “SQL Server Management Studio” login into the SQL Server and create a SQL user with:
- Securityadmin role rights
- Sysadmin role rights
- This SQL user must be able to create databases and objects with the database (tables, triggers, indexes, etc).
- This SQL user should also be mapped as securityadmin role for tempdb databases.
- If your SQL server has multiple instances running then you have to connect from DocuWare using the full instance name (E.g.: ServerName\InstanceName) during the installation.
NOTE: Once the database has been prepared, DocuWare Authentication server installation will onnect to that database and create all necessaries components required for DocuWare software. If you are installing DocuWare in a different server, then you could test the connection by creating a test ODBC connection from that DocuWare server to the Micrososft SQL Database server (as test only).
External MySQL (Not DocuWare Internal Database) for Installation
- DocuWare supports MySQL version 4.x and 5.x
- Have a look at the system requirements to get more information about the DocuWare version and its supported database.
- Download the MySQL GUI tools from www.mysql.com (optional). This tool will allow you do backups, restores, and database maintenances.
- Create a new user with same rights as the user root account. In MySQL Administration Tool right click on the user root and select the option “Clone user”. The default port for this database is 3306.
NOTE: The MySQL database preparation will be done only if you already have a MySQL database engine running and you want adapt DocuWare into that existing database engine. The bundle database that comes with DocuWare 5/6 is MySQL. There is no preparation required if you are using DocuWare Internal Database (MySQL), everything is configured by the setup process.