Chat now with support
Chat with Support

Quick Connect for Base Systems 2.4 - Administration Guide

Installing One Identity Quick Connect for Base Systems Working with a delimited text file Working with an LDAP directory service Working with Microsoft SQL Server Working with Novell eDirectory Working with an OLE DB-compliant relational database Working with Oracle Database Working with Oracle user accounts Working with Sun One Directory Server Working with OpenDS Working with Red Hat Directory Server Working with MySQL database Working with IBM DB2 Working with an ODBC-compliant data source Working with an OpenLDAP directory service

Installing One Identity Quick Connect for Base Systems

Installing One Identity Quick Connect for Base Systems

Installing One Identity Quick Connect for Base Systems

Before installing One Identity Quick Connect for Base Systems make sure your system meets the system requirements provided in the One Identity Quick Connect for Base Systems Release Notes. For instructions on how to upgrade from an earlier version of One Identity Quick Connect for Base Systems, see the Release Notes supplied with this version of the product.

To install the product by using the Setup Wizard

  1. Do one of the following:
    • In a 32-bit edition of Windows, run the QuickConnectForBaseSystems_x86.msi file supplied with the One Identity Quick Connect for Base Systems installation package.
    • In a 64-bit edition of Windows, run the QuickConnectForBaseSystems_x64.msi file supplied with the One Identity Quick Connect for Base Systems installation package.
  2. Follow the steps in the Setup Wizard until you are on the Completion page.
  3. Select the Restart Quick Connect service now for changes to take effect check box.
  4. Click Finish to close the wizard.

To perform a silent installation

  • On a 32-bit system, enter the following command at a command prompt:

    msiexec /i "<Path to QuickConnectForBaseSystems_x86.msi>"
    RESTART_QCSERVICE=
    <Value> /qb /l*v
    "
    <Path to file that will store the Setup log>"

  • On a 64-bit system, enter the following command at a command prompt:

    msiexec /i "<Path to QuickConnectForBaseSystems_x64.msi>"
    RESTART_QCSERVICE=
    <Value> /qb /l*v
    "
    <Path to file that will store the Setup log>"

In the above syntax:

 
Table 1: Arguments

Argument

Description

RESTART_QCSERVICE

Specifies whether or not to restart the Quick Connect Service.

The changes made by the Setup program may not take effect until the Quick Connect Service is restarted.

This argument can take one of the following values:

  • 0. Specifies not to restart the Quick Connect Service. This value is also used when the RESTART_QCSERVICE argument is omitted.
  • 1. Specifies to restart the Quick Connect Service.

For instructions on how to configure connections to supported data systems, see the following sections in this guide:

Working with a delimited text file

Working with a delimited text file

This section describes how to create or modify a connection to a delimited text file so that One Identity Quick Connect for Base Systems could work with data in that file.

To create a connection to a delimited text file, you need to use One Identity Quick Connect Sync Engine in conjunction with a special connector called Delimited Text File Connector. This connector is included in the One Identity Quick Connect for Base Systems package.

The Delimited Text File Connector supports the following features:

 

Table 2: Supported features

Feature

 

Bidirectional synchronization

Allows you to read and write data in the connected data system.

No

By using this connector, you can only read data in the connected data system.

Delta processing mode

Allows you to process only the data that has changed in the connected data system since the last synchronization operation, thereby reducing the overall synchronization operation time.

Yes

Password synchronization

Allows you to synchronize user passwords from an Active Directory domain to the connected data system.

No

In this section:

For instructions on how to rename a connection, delete a connection, or modify synchronization scope for a connection, see the One Identity Quick Connect Sync Engine Administrator Guide.

Creating a delimited text file connection

Working with a delimited text file > Creating a delimited text file connection

To create a new connection

  1. In the Quick Connect Administration Console, open the Connections tab.
  2. Click Add connection, and then use the following options:
    1. Connection name. Type a descriptive name for the connection.
    2. Use the specified connector. Select Delimited Text File Connector.
  3. Click Next.
  4. On the Specify connection settings page, use the following options:
    • Delimited text file. Click Browse to locate and select the delimited text file to which you want to connect.
    • Access delimited text file using. Select an access option:
      • Quick Connect Service account. Access the delimited text file in the security context of the account under which the Quick Connect Service is running.
      • Windows account. Access the delimited text file in the security context of the account whose user name and password you specify below this option.
    • Test Connection. Click this button to verify the specified connection settings.
  5. Click Next.
  6. On the Specify delimited text file format page, use the following options to provide information about the delimited text file format:
    • Delimiter. Select the delimiter used in the file you specified.
    • Use first row for attribute names. Select this check box if the first line of the specified file contains names of attributes. Otherwise, leave this check box cleared.
    • Advanced. Click this button to specify advanced options to access the delimited text file, such as encoding, row delimiter, value delimiter, and text qualifier.
  7. Click Next.
  8. On the Specify attributes to identify objects page, use the following options to select the attributes with which you want to uniquely identify each object in the file:
    • Available attributes. Lists the attributes that are available in the external data system. Use this list to select the attributes whose values you want to use to generate a unique identifier for each object in the external data system. You can filter attributes by typing in the text box at the top of this list. To select multiple attributes, hold down CTRL and click to select attributes in the list.
    • UniqueID attributes. Lists the attributes whose values are currently used to generate a unique identifier for each object in the external data system.
    • Add->. Moves the selected attributes from the Available attributes list to the UniqueID attributes list.
    • <-Remove. Moves the selected attributes from the UniqueID attributes list to the Available attributes list.
    • Constructed UniqueID. Displays a combination of the attributes whose values will make up a unique identifier for each object in the external data system.
  9. Click Finish to create a connection to the delimited text file.

Modifying an existing delimited text file connection

Working with a delimited text file > Modifying an existing delimited text file connection

To modify connection settings

  1. In the Quick Connect Administration Console, open the Connections tab.
  2. Click Connection settings below the existing delimited text file connection you want to modify.
  3. On the Connection Settings tab, click an appropriate item to expand it and use the options it provides.

    You can expand the following items:

    See the next subsections for the descriptions of these items.

  4. When you are finished, click Save.
Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
RSS Feed
Contact Us
Licensing Assistance
Technical Support
View All
Related Documents