Step Four

Database

In Release 12.0 and higher, Documaker Studio defaults to a database management system (DBMS), for new workspaces. A DBMS consists of software that organizes the storage of data, and controls the creation, maintenance, and use of the database storage structures of organizations and of their users.

For Documaker, using a DBMS default structure for workspaces affects the storage and management of library resource (MRL files, user information, and entry tables) files. Using DBMS architecture provides enhanced security and the ability to deal with large amounts of business transactions and data. The benefits of the DBMS configuration for Documaker workspaces include:

  • Enhanced scalability and fail-over capabilities
  • Improved sorting and query functionality for master resource libraries (MRLs)
  • Increased security

Using a DBMS structure for workspaces means that the following must be determined prior to beginning workspace creation in Documaker Studio:

  1. Identify target database, which must be ODBC or JDBC compliant.
  2. Ensure appropriate size is allocated for workspace.
  3. Create the database and identify table/schema owner.
    • Define owner permissions to create, update, and delete.
    • Verify the user name applied to the DB Connection (ODBC, JDBC, or native driver) Data Source established on the client machine.
    • Determine if the MRL will be used for Document Factory processing. If so, the Document Factory installation will provide DDL that the database administrator (DBA) can use to create the MRL tables.

    This table lists the recommended table naming conventions:

    Table TypeConvention
    Library NameSchema.MRL
    Description(Optional) Enter the description for the library
    Library Index TableSchema.MRL
    MRL Library Data TableSchema.MRL_LBYD
    MRL Library Catalogue TableSchema.MRL_LBYC
    MRL Library Log TableSchema.MRL_LBYL
    User TableSchema.MRL_DMUSER
    Common Fields TableSchema.MRL_FLDB

  4. Create ODBC, JDBC, or native database connection on machines where Documaker Studio will be Executed.

Note: If using Oracle database and ODBC connection, the Oracle Instant Client version 11.2.0.3 must be used as the Client for the Data Source Name. Refer to the Instant Client ODBC readme for installation details.

 

For JDBC Connection in Releases 12.4 and higher:

  1. Identify target database, which must be in compliance with JDBC.
  2. Ensure appropriate size is allocated for workspace.
  3. Create the database and identify table/schema owner.
    • Define owner permissions to create, update, and delete.
    • Verify the user name applied to the DB Connection (JDBC or native driver) Data Source established on the client machine.
    • Determine if the MRL will be used for Document Factory processing. If so, the Document Factory installation will provide DDL that the database administrator (DBA) can use to create the MRL tables.

    This table lists the recommended table naming conventions:

    Table TypeConvention
    Library NameSchema.MRL
    Description(Optional) Enter the description for the library
    Library Index TableSchema.MRL
    MRL Library Data TableSchema.MRL_LBYD
    MRL Library Catalogue TableSchema.MRL_LBYC
    MRL Library Log TableSchema.MRL_LBYL
    User TableSchema.MRL_DMUSER
    Common Fields TableSchema.MRL_FLDB

 


Copyright © 2016, Oracle and/or its affiliates. All rights reserved. Legal notices.