Databases

Datacap is installed with a Microsoft Access database, however, Microsoft Access is not supported in a Datacap production environment. You can configure your Datacap production environment to use a DB2®, Microsoft SQL Server, or Oracle database.

Review this planning information before you define and configure a DB2, Microsoft SQL Server, or Oracle database for your Datacap application databases.

You must be a Database Administrator with a working knowledge of the database management system to create a DB2, Microsoft SQL Server, or Oracle database. And to define the structure of the Datacap application databases for it.

The DB2, SQL Server, or Oracle database Server and Client software is not installed as part of the Datacap product installation. This software is available on the vendor media or by download from the vendor website.

Install the database server software on the computer where you want to run the database. You must have access to this computer.

Evaluate your needs and resources to decide the type of environment on which you want to install your database:

• In smaller environments, you can install the database server and some or all of the Datacap software components on the same computer
• In larger, distributed systems, you might want to install one database server for all of the clients that use the database. Or you can one database server for each environment, such as Test and Production.

You must run the database client software on every Datacap computer that accesses the database server.

Any computer that does lookups on the database must have access to the computer where the database server is installed.

Using the DB2, SQL Server, or Oracle Administration Tools, you create an initial, empty or database for the Administration, Engine, and Fingerprint databases. You must specify the elements of the database, for example the name of the database, user permissions.

Verify that the Datacap applications that you want to copy to the DB2, SQL Server, or Oracle were created.