The Database Properties page is used to specify the type of the DBMS installed on the server and additional connection parameters:
Determine the parameters on the page:
DBMS Type. Select the DBMS type in the drop-down list. For details about available DBMS see the Supported DBMS section.
DBMS is Case Sensitive. Select the checkbox to work with DBMS objects with different capitalization in their physical name. In the desktop application the checkbox is available in the advanced connection settings dialog box.
Server. Specify the server alias, that is, the name of the server where the connected database is stored. Global variables can be entered in this box.
Schema/Database. Database identifier to which the connection is executed. Global variable use is available in this field. If the Microsoft SQL Server 2008, 2012\2014\2016, ODBC or PostgreSQL DBMS type is selected, the field is named Database.
Schema. The field is displayed if Microsoft SQL Server 2008, 2012\2014\2016, ODBC or PostgreSQL DBMS type is selected. Specify identifier of a user schema to use this schema in database. The default schema for Microsoft SQL Server is "dbo" and for PostgreSQL is "public".
Authentication Type. There are two possible types:
Password. User specifies username and password.
Integrated Domain. The current OS account is used to connect to the server. You do not need to reenter user name and password.
Use Unicode Encoding for Data Representation. When the checkbox is selected, text fields of the NVARCHAR type are created tables, which enables the user to work with Unicode symbols; when the checkbox is deselected, the text field type is VARCHAR.
Use Delayed Loading of Descriptors. If the checkbox is selected, descriptors are loaded incompletely on loading the repository. First two levels of the repository tree level are to be loaded if the last selected object is not specified. Descriptors of this object with all parent objects and objects of the same level for each parent up to the root are loaded, if the last object is specified.
Log In Automatically. This group can be set up when the Password authentication is selected. If this checkbox is selected, the connection to this database is established automatically. Select required connection method:
Use Login Credentials. If this checkbox is selected, the DBMS server connection uses the username and the password specified at establishing repository connection. At the same time, on DBMS server the user gets the required permissions for all available tables registered in the repository. If this checkbox is selected, the User Name and Password fields become unavailable.
User Name and Password. Specify user credentials that will be used for server connection. If the Domain authentication type is selected, it is required to specify domain and user name in the format: <Domain\User Name>.
In the desktop application, clicking the Advanced Settings button opens the advanced connection settings dialog box.
To finish the wizard:
In the web application click the Save button.
In the desktop application click the Finish button.
As a result, the Repository Connection repository object will be created.
See also: