Connection dialog box

Right-click a dataset and select Properties, then click the Connection tab to see this dialog box.

The Connection dialog box also appears when you click Next in the Identification dialog box in the Create or Register New Dataset dialogs.

• Dataset Type - the dataset type selected from the Identification dialog box.
• Database Connection String - shows the corresponding interface’s connection string for the selected dataset type.
  NOTE:
  • If you are creating a new dataset, this Content Manager process expects that the database structure has been setup in the database authoring application first. It also assumes there are no non-system objects within that structure.
  • If you are registering an existing dataset, this Content Manager process expects that the database structure has been setup in the database authoring application. It also assumes there are Content Manager related objects within that structure.

  Use the KwikSelect to add or edit the existing connection string value. The Connection Settings dialog displayed will depend on what dataset type is selected, the options are:

  • For Microsoft SQL Server - see Connection Settings dialog box for SQL Server.

    This section also covers specific settings for supporting

    • SQL Server’s AlwaysOn Availability Groups functionality
    • Azure SQL Server databases
      
  • For Oracle - see Connection Settings dialog box for Oracle
  • For PostgreSQL - see Connection Settings dialog box for PostgreSQL

  Once you have set up the database connection string, continue below.

• Command Timeout - denotes seconds - allowed time for commands to run before they time out.

  • The default is -1. -1 is equal to 30 seconds.

  • 0 means no timeout is set.

  To change this setting to anything other than the above two options, use the value in seconds that you want to set the timeout to.

  For example:

  • if you want to set a five second timeout, type 5
  • if you wanted a five minute timeout, the value would be 5 x 60 seconds = 300.

• Instant On

  These options allow the Content Manager administrators to configure access for new users not currently registered as a Location within Content Manager. This allows easier onboarding of new users into Content Manager.

  These are the options available for guest login access to this dataset, when a login is attempted by a user that is not currently registered as a valid location:

  • Deny access - to have no guest login facility.

  • Provide access as a guest, using the following user login name - Type a guest login in this field to allow users with no login of their own to access Content Manager with default Inquiry permissions.

  • Automatically register a new user in the system, using the following user login name as a template - a Content Manager user that is a template user profile.

    • Restricted to users belonging to these domains - select this option to restrict the automatic registrations to users from specified domains.

  Content Manager logs events by the guest login under the specified location.

NOTE:
• It is recommended that you do not use an existing login on the network. Instead, you should create a new login.
• If there are duplicate user profiles, Content Manager will choose the user that matches domain AND login first, followed by any user that matches the login without a domain, followed by the guest account.

In the Create or Register New Dataset dialogs, click Next to continue to the Options dialog box.