User directory connectors ODBC properties
Four ODBC options exist when creating a new user directory connector (UDC). They all have the same properties and fields, but for Access (via ODBC), Excel (via ODBC), SQL (via ODBC), and Teradata (via ODBC), some of the fields contain default values for support. You will most likely have to change those values.
The following property groups are available for ODBC UDC.
Identification
All fields are mandatory and must not be empty.
Property | Description |
---|---|
Name |
The name of the UDC configuration, defined from the QMC. |
Type |
The UDC type. |
User sync settings
Property | Description | Default value |
---|---|---|
Sync user data for existing users |
Information noteThe user attributes are only synced when a user logs in to the hub. Even if you delete the user in the QMC, the active session is still valid for the user that has been deleted. If the hub is only refreshed, the user is added to the database, but without any attributes.
|
Selected |
Connection
Property | Description | Default value |
---|---|---|
User directory name |
The name of the user directory. Must be unique, otherwise the connector will not be configured. The name must not contain spaces. |
- |
Users table name | The name of the table containing the users. Include the file extension in the table name, for example: Table.csv. Information noteWhen setting up an Oracle ODBC user directory connector, the Users table name and Attributes table name must be prefaced by the owner of those tables. For example: OWNER.USERS instead of only USERS. |
- |
Attributes table name | The name of the table containing the user attributes. Include the file extension in the table name, for example: Table.csv. Information noteWhen setting up an Oracle ODBC user directory connector, the Users table name and Attributes table name must be prefaced by the owner of those tables. For example: OWNER.USERS instead of only USERS. |
- |
Visible connection string |
The visible part of the connection string that is used to connect to the data source. Specify one of the following:
Information noteThe two connection strings are concatenated into a single connection string when making the connection to the database.
|
- |
Encrypted connection string |
The encrypted part of the connection string that is used to connect to the data source. Typically, this string contains user name and password. Example: Assume that you have a connection string as follows: Driver={Microsoft Access Driver (.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=verySecretAdminPassword; You do not want to store that connection string in the database as it is, because the secret password would then be visible to others. To protect the password, do the following: Save the first part: Driver={Microsoft Access Driver (.mdb)};Dbq=C:\mydatabase.mdb; in the Visible connection string field, and the second part: Uid=Admin;Pwd=verySecretAdminPassword; in the Encrypted connection string field. The second part is then stored encrypted in the database and is not shown when you open the UDC again for editing. Information noteThe two connection strings are concatenated into a single connection string when making the connection to the database.
|
- |
Synchronization timeout (seconds) | The timeout for reading data from the data source. | 240 |
Tags
Property | Description |
---|---|
Tags |
Tip noteIf no tags are available, this property group is empty.
Connected tags are displayed under the text box. |