Home
Administering Connections 6.5
Welcome to the HCL Connections 6.5 documentation. HCL Connections is social networking software designed for the workplace. Its features help you to establish dynamic networks that connect you to the people and information you need to achieve your business goals.
Installing
To install HCL Connections™, you need to follow a detailed series of procedures.
Pre-installation tasks
Complete the following tasks before installing HCL Connections. If you are migrating from a prior release of HCL Connections, do not complete the tasks for creating databases or populating the Profiles database. The migration process handles those tasks automatically.
Creating databases
Create databases for the applications that you plan to install. You can use the database wizard or run the SQL scripts that are provided with HCL Connections™.
Creating SQL Server databases
Create databases with SQL Server. You can use the database wizard or run the SQL scripts that are provided with HCL Connections™.
Configuring Unicode for SQL Server databases
Each database in your HCL Connections deployment must be configured for Unicode. This procedure must be completed before you install HCL Connections because you cannot configure the database Unicode collation after installation.

Administering Connections 6.5
Welcome to the HCL Connections 6.5 documentation. HCL Connections is social networking software designed for the workplace. Its features help you to establish dynamic networks that connect you to the people and information you need to achieve your business goals.
- What's new in HCL Connections
  Find out about features that are new or updated in this release of HCL Connections.
- Product overview
  Learn how to deploy, customize, and administer the HCL Connections social networking product.
- Planning
  Before installing HCL Connections™, study the system requirements, deployment options, and documentation conventions.
- Installing
  To install HCL Connections™, you need to follow a detailed series of procedures.
  - The installation process
    Review the steps that are required to install HCL Connections.
  - Pre-installation tasks
    Complete the following tasks before installing HCL Connections. If you are migrating from a prior release of HCL Connections, do not complete the tasks for creating databases or populating the Profiles database. The migration process handles those tasks automatically.
    - Verifying disk space and open file limits before installing HCL Connections
      On all operating systems, ensure that you have 6 GB of temporary disk space. On AIX® and Linux™, set the Open File Descriptor limit to at least 40000 before installing HCL Connections.
    - Preparing to configure the LDAP directory
      Determine which Lightweight Directory Access Protocol (LDAP) attributes you want to use as the identifiers for HCL Connections users.
    - Installing IBM® WebSphere® Application Server and IBM® HTTP Server
      HCL Connections requires an environment where the WebSphere® Application Server Deployment Manager and one node are installed and configured in advance. IBM® HTTP Server and the Web Server Plug-ins for IBM WebSphere Application Server are also prerequisites. This software is provided with the HCL Connections package.
    - Accessing Windows® network shares
      Configure a user account to access network shares in an HCL Connections deployment on the Microsoft® Windows® operating system
    - Setting up federated repositories
      Use federated repositories with IBM® WebSphere® Application Server to manage and secure user and group identities.
    - Creating databases
      Create databases for the applications that you plan to install. You can use the database wizard or run the SQL scripts that are provided with HCL Connections™.
      - Creating DB2® databases
        Create databases using DB2®. You can use the database wizard or run the SQL scripts that are provided with HCL Connections™.
      - Creating Oracle databases
        Create databases using Oracle. You can use the database wizard or run the SQL scripts that are provided with HCL Connections™.
      - Creating SQL Server databases
        Create databases with SQL Server. You can use the database wizard or run the SQL scripts that are provided with HCL Connections™.
        Configuring Unicode for SQL Server databases
        Each database in your HCL Connections deployment must be configured for Unicode. This procedure must be completed before you install HCL Connections because you cannot configure the database Unicode collation after installation.
        Preparing the database wizard for SQL Server
        Before you can use the wizard to create databases for your HCL Connections deployment, prepare the database server.
        Using the database wizard for SQL Server
        Use the database wizard to create databases for the HCL Connections applications that you plan to install.
        Using the database wizard in silent mode for SQL Server
        Run the database wizard in silent mode when you need an identical installation on multiple servers.
        Creating SQL Server databases manually
        Create Microsoft™ SQL Server databases with SQL scripts instead of using the HCL Connections database wizard.
        Creating multiple SQL database instances
        Create SQL database instances using the SQL Server installation wizard. If you need to have only one database instance, you can skip this task.
    - Populating the Profiles database
      Populate the Profiles database with data from the LDAP directory.
    - Before installing
      Verify that all necessary prerequisite conditions are complete before installing HCL Connections.
  - Installing HCL Connections
    Select the HCL Connections applications that you plan to use and install them in a clustered deployment.
  - Post-installation tasks
    After installation, you need to perform further tasks to ensure an efficient deployment.
  - Optional: Installing and configuring the Tiny Editors for HCL Connections
    HCL Connections 6.5 can use the optional Tiny Editors: TinyMCE or Textbox.io, to replace the HCL Connections™ default rich text editor.
  - Copying Search conversion tools to local nodes for AIX and Linux
    To enable full indexing of data, copy the Search conversion tools to local nodes.
  - Copying Search conversion tools to local nodes for Windows
    To enable full indexing of data, copy the Search conversion tools to local nodes.
  - Optional post-installation tasks
    Complete the post-installation tasks that are relevant to your deployment.
- Uninstalling HCL Connections
  Uninstall HCL Connections.
- Migrating and updating
  Migrate HCL Connections™ and its supporting software to the latest release and then update the installation with the latest deployment, interim fixes, or Cumulative Refresh (CR).
- Administering
  Run administration and maintenance tasks to keep your environment up-to-date. For example, learn how to customize your deployment or how to use the wsadmin utility to edit configuration files. You can also schedule tasks, maintain application databases, moderate content, or manage users and their roles.
- Customizing
  Customize HCL Connections™ to fit your environment.
- Security
  HCL Connections™ provides a flexible security infrastructure that supports an open, easily shareable data model.
- Mobile
  See the HCL Connections™ Mobile documentation for Connections Cloud and Connections on-premises.
- Developing
  Get information about how to use the APIs provided with HCL Connections™ and how to use Connections Customizer to modify the Connections pages that are returned to users.
- Troubleshooting and support
  To isolate and resolve problems with your HCL products, you can use the troubleshooting and support information. This information contains instructions for using the problem-determination resources that are provided with your IBM® products, including HCL Connections™.

Configuring Unicode for SQL Server databases

Each database in your HCL Connections deployment must be configured for Unicode. This procedure must be completed before you install HCL Connections because you cannot configure the database Unicode collation after installation.

Before you begin

You must use the Latin1_General_BIN collation for Unicode handling in Connections. The collation must be set during installation because it cannot be modified after installation.

Procedure

Find the option for changing the collation order.
- SQL Server 2016
  During setup, on the Server Configuration page, click Collation and then click the Windows collation designator and sort order option.
Select Latin1_General.
Select the Binary option to make Latin1_General_BIN the default collation.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box. Note: To report a problem or question about the product software, do not use this form. Instead, go to the HCL Software Support site.