pdf_icon Download contentACCESS Manual as PDF

  1. Introduction to contentACCESS
    1. Services provided by contentACCESS
    2. Software requirements
  2. Installation of contentACCESS
  3. contentACCESS Tools
    1. Installing Virtual drive
    2. Installing the Proxy server (contentACCESSWS)
    3. Installing the Proxy web services
    4. Installing Outlook forms
    5. Legacy email archive connectors
    6. Legacy archive connector for Metalogix Archive Manager Exchange Edition (MAM EE)
    7. Legacy archive connector for Email Lifecycle Manager (ELM)
    8. Installing TECH-ARROW’s WinShortcutter
  4. contentACCESS Central Administration
    1. Central administration login
    2. contentACCESS Central Administration user interface
  5. Tenants in contentACCESS
    1. How to create a new tenant
    2. Tenant limitations
    3. How to provide access to a tenant (adding new tenant administrators)
    4. Tenant administrator invitation types
  6. General system configurations
    1. Connection
    2. User interface
    3. Users — role types, creating new users, adding user logins
    4. How to activate your license key
    5. How to create user logins to an already existing user?
    6. System administrators
    7. Login providers
    8. System
    9. Licensing
    10. Notifications
    11. Monitoring — how to find out possible misconfigurations / reasons of potential system/job failures
    12. Distributed environment in contentACCESS — Clusters
    13. Statistics
    14. How to create/configure databases — All databases
  7. Common features
    1. Databases
    2. Schedules
    3. Retentions
    4. Storages
    5. Exchange connections
    6. Importing contentACCESS configurations from files
  8. Creating new jobs in contentACCESS
  9. Jobs’ page, jobs’ context menu
  10. File Archive
    1. Introduction to File system archive
    2. File Archive settings
    3. File archive Databases
    4. File archive System settings
    5. File archive Retentions
    6. File archive Storages
    7. Root folders
    8. Aliases
    9. File archive Schedules
    10. Provisioning settings and managing access to contentWEB
    11. Configuring aliases
    12. Configuration of jobs available in contentACCESS File Archive
    13. Configuration of File system archive job
    14. Configuration of a File system restore job
    15. Configuration of File system recovery job
    16. Configuration of Remote shortcutting job
    17. Active/inactive documents in File system archive
  11. Email Archive
    1. Important settings before creating an Email Archive job
    2. Database settings
    3. Email archive System settings
    4. Provisioning settings
    5. Retention settings
    6. Shortcuts in email archiving
    7. Storing of archived emails
    8. Creating email archive schedulers
    9. User experience
    10. Exchange 2013: Mail app in OWA 2013 or on MS Outlook 2013 desktop version
    11. Exchange 2010: OWA 2010 integration
    12. Address book objects
    13. Granting access rights for mailbox users and explicit users to view the mailbox archive?
    14. Creating contentWEB users (option 1)
    15. Manage access to a mailbox archive (option 2)
    16. How the end user should log in to contentWEB (archive) over Internet?
    17. Database and store assignment in email archiving
    18. How to assign database and storage to an Exchange group?
    19. How to assign database and storage to a mailbox?
    20. How to move data from source database/storage into a second (target) database/storage?
    21. Creating Email archive jobs: archive, restore, recovery, mailbox move
    22. Email archive job
    23. Email restore job
    24. Email recovery job
    25. Mailbox move job
  12. Custom plugins
  13. Email management job configuration
  14. SharePoint archive plugin
  15. Storage replication plugin
  16. Sharing plugin
  17. Datengut plugin
  18. Email synchronizer plugin
  19. contentWEB
  20. officeGATE
  21. accessGATE Mobile
  22. Virtual drive
  23. Terms of use
  24. FAQ

6.14.How to create/configure databases — All databases

Processing plugins of a tenant write the metadata into the selected SQL database, which was formerly created by the administrator. The system database is always created during the installation process of contentACCESS, but it is not associated with a tenant. Databases associated with specific tenants are set up by the system administrator, on the All databases page.

Factors to be considered before creating databases:
The number of users expected for your database – if the company (tenant) has more than 2,000 mailboxes, it is recommended to create more archive databases (e.g. for storage, email archive, provisioning, or to set separate databases for the Exchange groups) to ensure a better transparency of data.

The amount of expected data in the database – always estimate how much space your data will require.

It is also worth to consider the retrieving capacities of the database.

To open All databases page in contentACCESS, navigate to System tab ⇒ Tenants ⇒ All databases control on the Central Administration ribbon. On this page you may find all databases created to all tenants. The server, where the tenant databases are installed, the database name, schema, user details and the associated tenants are also displayed in the grid:

Documentation173



+ create new
To be able to run processing jobs in contentACCESS, a new database must be created. This database must be then selected on the job’s configuration page, or in case of archiving the Exchange, it can be also associated to a mailbox from the address book. Click on + create new option and fill required data in the Database repository window.

Documentation174



Connection name: Enter a display name for the newly created database. This will be the name of the database in contentACCESS Central Administration.


If you want to use system database server check the “Use system database server” checkbox as it is shown on the screenshot above. This will populate the server settings. Type the database name into the “Database” field. This will be the name of the database on the SQL server. If you want to use database server which differs from the system database server, then follow the next steps:

a. Type: choose the type of database from the dropdown list (MSSQL is supported by default)

b. Server name: enter the name of the database server (where MSSQL is installed) here

c. Database: the database will be created on SQL server under this name

d. Schema: type in the database schema (optional)

Under Database user configurations you may create a database user. There are multiply options how to create a database user: 1) You can use an already existing user to connect to the database, or 2) you can create a new database user. 3) It is also possible to use the service user credentials to connect to the database, or 4) you may create a database user with random credentials (the user name can be edited).

1. If you want to use an already existing user, check the Use explicit user checkbox and enter the user credentials into the New or existing user/Password/Confirm password textboxes.

Documentation175


2. If you want to create a new database user with custom credentials, type them into the New or existing user/Password/Confirm password textboxes. Do NOT click on the Generate user and password button.

3. To connect with the service account, leave the Use explicit user checkbox unchecked and leave all the fields empty.

4. To create a new user with a random password check the Use explicit user checkbox, and click on the Generate user and password button. The user name can be edited directly here.

A newly created database user will have access permissions only to the currently created database.

Under Connect with user enter the credentials of the database user, who has the right to create a new database on the SQL server. If the Use explicit credentials checkbox is not checked, then contentACCESS will automatically connect to the database (MSSQL) under the contentACCESS service account. If you want to connect with an explicit user, check this checkbox, then enter the login data.

Test database connection: with a click on this button run a test connection to check if contentACCESS managed to connect to the selected database server (MSSQL).
Tenants: select a tenant from the dropdown list to which the database will be associated.
Click on Save and the New database will turn up in the list of databases.

Note: When we are archiving from the Exchange server, the database must be associated with the mailbox from the address book, or the first running email archive job will associate the configured database to the archived mailbox(es). In case of file system archive a database must be selected during the configuration process of the job.



+ configure existing
If you need to establish a connection between an already existing SQL database and contentACCESS, click on + configure existing and configure the required data in the Database repository window. In this case, you do not create a new database; an already existing database from the SQL server is used only.

Documentation179



Connection name: Enter a display name for the database. This will be the name of the database in contentACCESS.
If you want to use system database server check the “Use system database server” checkbox as it is shown on the screenshot above. This will populate the server settings. Type the database name into the “Database” field. This will be the name of the database on the SQL server. If you want to use database server which differs from the system database server, then follow the next steps:

a. Type: choose the type of database from the dropdown list (MSSQL is supported by default)

b. Server name: enter the name of the database server here (where MSSQL is installed)

c. Database: type here the name of an already existing database on the SQL server.

d. Schema: type in the database schema (optional)

Use explicit credentials: if this checkbox is not checked, then contentACCESS will automatically connect to the database (MSSQL) under the contentACCESS service account. If you want to use an explicit database user, check the checkbox and enter the user credentials.

Test database connection: with a click on this button run a test connection to check if contentACCESS managed to connect to the selected database server (MSSQL).

Tenants: select a tenant from the dropdown list to whom the database will belong to

Click on Save and the New database will turn up in the list of databases.

Documentation179.1 Update all databases
With a click on this option it is possible to update the structure of all databases. Click this button and the status bar of the updating plugin will appear. In this status bar, the following operations are accessible; start/stop running, manual refresh, enable/disable auto refresh and logs (this will redirect the user to the last run session of the database updating plugin):

Documentation180

Yes No Suggest edit
Help Guide Powered by Documentor
Suggest Edit