Creating Databases

In the following section, we will explain how to create a database in Virtual DataPort.

There are two types of databases depending on the method used to authenticate users:

  1. Normal authentication: the database relies in the Virtual DataPort access control, which means that the users that access Virtual DataPort have to be created in Virtual DataPort. See section Creating a Database with Normal Authentication.

  2. LDAP authentication: the database delegates the authentication of users to an LDAP server. See section Creating a Database with LDAP Authentication.

Note

The authentication type of the database does not matter if the client connects to Virtual DataPort using Kerberos authentication. The reason is that in this case, the privileges granted to the user will depend on the roles obtained for this user, from the LDAP server selected in the Kerberos configuration dialog (see section Setting-Up the Kerberos Authentication in the Virtual DataPort Server).

For both types of databases, you can configure the following settings:

  1. Enable or disable the support for Unicode identifiers.

  2. Enable or disable the automatic cost-based optimization.

  3. Enable or disable the automatic simplification of queries.

  4. Enable or disable the summary rewrite optimization.

If you select Default for any of these options, the database will use at all times the current value configured for this Virtual DataPort server. For example, if in a database you set the “automatic cost-based optimization” to “Default” and this feature is disabled globally (see the global value of this feature in the dialog “Queries Optimization” of the menu Administration > Server configuration), it will be also be disabled for this database. If later you enable this feature globally, it will be also enabled for this database without you having to change the specific configuration of the database.

To enable Kerberos authentication for ODBC/ADO.net clients, set ODBC/ADO.net authentication type to Kerberos.

Important

If you do this, the ODBC/ADO.net clients that connect to this database will only be able to use Kerberos authentication; the authentication with login/password will be refused.

Creating a Database with Normal Authentication

To create a database with normal authentication, click Database management on the Administration menu. In this dialog, click New database. The Tool requests the following data (see Creating a new database with “Normal” authentication type):

  • Name of the database.

  • Description of the database (optional).

  • Identifiers charset: if you select Default, the database will use the setting configured for the entire Server (see Identifiers Charset).

  • Authentication type: Normal.

  • Click Ok to create the database.

When a user tries to connect to this database, Virtual DataPort will check the credentials of this user with the “list” of users created in Virtual DataPort. These users are the ones created in the “User Management” dialog (see section Creating Users).

Creating a new database with "Normal" authentication type

Creating a new database with “Normal” authentication type

Creating a Database with LDAP Authentication

A database with LDAP authentication delegates the authentication of users to an LDAP server. The benefit over the Normal authentication is that you rely on an LDAP server such as Microsoft Windows Active Directory to authenticate users. This simplifies the management of users and their privileges. You can get more details about how to create a database with LDAP authentication in the section LDAP Authentication.