Connecting to databases

You can use different authentication methods to provide access from Datacap to DB2® , Microsoft SQL Server, or Oracle databases.

About this task

You can connect to databases by using one of the following authentication methods:

  • Windows Authentication: Uses Microsoft Active Directory Domain service account credentials for Datacap Server Service, Datacap Web, and Rulerunner Service. Create one or more local SQL Server user accounts, and grant them read/write access to the Datacap databases. When you create connection strings for your application to access the databases, include the appropriate local SQL Server user name and password in each connection string.
  • SQL Authentication: Requires a SQL Server Login ID and password in connection strings that are provided by Datacap Application Manager.

For Oracle databases, you must use Oracle Authentication. This requires that each client or server provides an Oracle Login ID and password which must match the credentials of a user who is defined in the Oracle database.

Procedure

To connect to the database:

  1. Configure Windows authentication for SQL Server:
    1. Open the SQL Server Configuration Manager or SQL Server Management Studio and log in to Administrator or to an account with rights to create users.
    2. Set up user credentials and permissions for the SQL Server.
      These user credentials and permissions must exist in the Datacap databases.
    3. Grant Read/Write access to the Datacap databases to the Microsoft Active Directory Domain service account.
    4. See the documentation that was provided with your SQL Server database for instructions on setting user credentials and permissions.
  2. Configure SQL Server authentication:
    1. Open the SQL Server Configuration Manager or SQL Server Management Studio and log in to Administrator or to an account with rights to create users.
    2. Set up user credentials and permissions for the SQL Server.
      These user credentials and permissions must exist in the Datacap databases.
    3. See the documentation that was provided with your SQL Server database for instructions on setting user credentials and permissions.
  3. Configure Oracle authentication:
    1. Open the Net Configuration Assistant and log in to Administrator or to an account with rights to create users.
    2. Create a single Oracle Net Service Name.
      A Net Service Name is required for every Datacap Server that accesses the Administration and Engine databases and every Datacap Client that accesses the Fingerprint database.
    3. See the documentation that was provided with your Oracle database for instructions on creating a Net Service Name.
      When you create connection strings for Datacap to access the database, include the Oracle user name and password for the Datacap database in each connection string.
  4. Configure DB2 authentication:

    For DB2 databases, you must use DB2 Authentication. This requires that each client or server provides a DB2 login ID and password, which must match the credentials of a user who is defined in the DB2 database.

    1. Open the IBM® Data Studio Database Administration tool for DB2 10.5.
    2. Using the Administration Explorer, connect to the target DB2 database.
    3. See the documentation that was provided with your DB2 database for instructions on creating a user ID and password to use when logging into the database from a Datacap application..

      When you create connection strings for Datacap to access the database, include the Datacap user name and password for the Datacap database in each connection string. If the user that created the database tables is different from the user ID that is connecting to the database, then you must also use the CurrentSchema setting in the connection string and specify the user ID that created the tables.