Home
Administering Connections 6 CR6
Welcome to the HCL Connections 6 CR6 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 IBM® Connections, you need to follow a detailed series of procedures.
Post-installation tasks
After installation, you need to perform further tasks to ensure an efficient deployment.
Configuring additional IBM Connections applications
You must perform additional tasks to enable IBM Connections for the Orient Me home page, the Touchpoint interactive user experience, Community Libraries, Community Surveys, Metrics applications, and more.
Setting up Cognos® Metrics to work with HCL Connections
Install and configure your IBM Cognos® Metrics environment to work with HCL Connections.
Configuring Cognos® Business Intelligence after installation
After installation, you need to perform further configuration tasks to ensure that IBM® Cognos® Business Intelligence works.
SQL Server instructions for Linux

Administering Connections 6 CR6
Welcome to the HCL Connections 6 CR6 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 6
  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 IBM Connections social networking product.
- Planning
  Before installing HCL Connections™, study the system requirements, deployment options, and documentation conventions.
- Installing
  To install IBM® Connections, you need to follow a detailed series of procedures.
  - The installation process
    Review the steps that are required to install IBM® Connections.
  - Pre-installation tasks
    Complete the following tasks before installing IBM® Connections. If you are migrating from a prior release of IBM Connections, do not complete the tasks for creating databases or populating the Profiles database. The migration process handles those tasks automatically.
  - Installing IBM® Connections
    Select the IBM® 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.
    - Registering custom widgets
      Register all custom and third-party widgets with Conenctions 6 to ensure they meet security requirements and can display in communities.
    - Reviewing the JVM heap size
      Review the size of the Java™ Virtual Machine heap and adjust it, if necessary, to avoid out-of-memory errors or to suit your hardware capabilities.
    - Configuring IBM® HTTP Server
      When you have successfully installed IBM® Connections to run on WebSphere® Application Server, you can configure IBM HTTP Server to handle web traffic.
    - Configuring the Home page administrator
      Create an administrator for Home page so that you can make changes to the application such as adding and removing widgets.
    - Configuring additional IBM Connections applications
      You must perform additional tasks to enable IBM Connections for the Orient Me home page, the Touchpoint interactive user experience, Community Libraries, Community Surveys, Metrics applications, and more.
      - Optional: Installing the Component Pack for Connections™
        The Component Pack for HCL Connections™ introduces new connectivity capabilities that enhance collaboration and boost productivity.
      - Setting up stand-alone Elasticsearch
        Deploy Elasticsearch as a stand-alone server for use with HCL Connections™, instead of deploying it as part of the Component Pack for Connections.
      - Setting up type-ahead search
        Enable type-ahead search in HCL Connections™ to suggest items in the search box based on content that is relevant to each user.
      - Installing Customizer Lite
        This topic describes how to install Customizer Lite. There are two deployment options, hereby referred to as Customizer Lite and Customizer Lite HA. Customizer Lite – the most basic deployment using a single Docker node running a single instance of each required service and Customizer Lite HA – a more resilient deployment using a pair (or more) of Docker nodes all running instances of each required service with requests load balanced across available nodes.
      - Optional: Installing Connections Touchpoint
        HCL Connections Touchpoint provides an interactive user experience that can be used for a wide variety of user scenarios, such as profile creation, community and network contact recommendations, organization polling and more.
      - Configuring IBM® Connections Content Manager for Libraries
        If you installed the IBM® Connections Content Manager add-on, you must configure FileNet® to work with IBM Connections Content Manager. Choose the instructions that match your deployment: either an existing FileNet deployment, which you installed independently before you installed IBM Connections or a new, integrated FileNet deployment that is part of a new IBM Connections installation.
      - Optional: Configuring IBM® Docs with CCM
        You can enable community members to edit files in Community libraries online if you have already installed IBM® Connections Docs.
      - Installing Community Surveys
        If you want to be able to conduct surveys within Communities to capture data and share it easily with your community in an activity stream, enable Community Surveys.
      - Setting up Cognos® Metrics to work with HCL Connections
        Install and configure your IBM Cognos® Metrics environment to work with HCL Connections.
        Configuring WebSphere® Application Server for Cognos® Business Intelligence
        Install and configure IBM® WebSphere® Application Server Network Deployment on the computer hosting IBM Cognos® Business Intelligence and also configure a new profile for Cognos, so that the server can be managed by the Deployment Manager used with IBM Connections.
        Installing and deploying Cognos® Metrics
        You must install Cognos® Metrics after installing IBM® Connections and deploy it into a cluster.
        Deploying a Cognos cluster
        Only complete this procedure if you plan to set up a Cognos cluster, otherwise skip to the next topic.
        Configuring Cognos® Business Intelligence after installation
        After installation, you need to perform further configuration tasks to ensure that IBM® Cognos® Business Intelligence works.
        DB2® instructions for AIX
        DB2 instructions for Linux
        DB2 instructions for Windows
        Oracle instructions for AIX
        Oracle instructions for Linux
        Oracle instructions for Windows
        SQL Server instructions for AIX
        SQL Server instructions for Linux
        SQL Server instructions for Windows
        Validating the Cognos® server installation
        Verify that the IBM® Cognos® BI server and Cognos Transformer server are correctly installed.
        Configuring Cognos® Business Intelligence
        Configure your IBM® Cognos® Business Intelligence environment to work with IBM Connections.
    - Optional: Installing and configuring the Ephox Editors for IBM Connections
      IBM® Connections 6.0 CR5 can use the optional Ephox Editors: TinyMCE or Textbox.io, to replace the IBM Connections default rich text editor.
    - Optional post-installation tasks
      Complete the post-installation tasks that are relevant to your deployment.
  - Uninstalling IBM® Connections
    Uninstall IBM® Connections.
- Migrating and updating
  Migrate IBM® Connections and its supporting software to the latest release and then update the installation with the latest 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 IBM® Connections to fit your environment.
- Security
  IBM® Connections provides a flexible security infrastructure that supports an open, easily shareable data model.
- Mobile
  See the IBM Connections Mobile documentation for Connections Cloud and Connections on-premises.
- Developing
  Get information about how to use the APIs provided with IBM® 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 IBM® 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™.

SQL Server instructions for Linux

Procedure

Define the ODBCINI, LD_LIBRARY_PATH JVM variable to Cognos® Server. Add this variable to JVM environment variable list as follows:
1. Log into the WebSphere® Application Server Integrated Solutions Console of the Cognos® BI Server.
2. Click Servers > Server Types > WebSphere application servers.
3. Click the link of the Cognos® server.
4. Click JAVA and then select Process Management > Process definition > Environment Entries.
5. Add or edit entries as needed, such as:
```
 ODBCINI=/root/.odbc.ini
         LD_LIBRARY_PATH =Cognos_BI_install_path/bin64: /opt/Progress/DataDirect/Connect_for_ODBC_71/lib/
```
6. Restart the Cognos® BI Server.
Follow the same steps as previously described to add an additional entry:
```
LD_PRELOAD = /usr/lib64/libfreebl3.so
```

Make sure the ODBCINI, LD_LIBRARY_PATH environment variable is set before building a cube.

Run the following commands first before manually running the script to build cube. For example:

export ODBCINI=/root/.odbc.ini
       export LD_LIBRARY_PATH =/opt/Progress/DataDirect/Connect_for_ODBC_71/lib/

Use the following command to edit the cron jobs to set the

ODBCINI,
LD_LIBRARY_PATH

on Linux™, LIBPATH on AIX® for scheduled cube generation tasks,

crontab -e

For example, change both daily-refresh.sh and weekly-rebuild.sh cron jobs from:

05 00 * * 1-6 /opt/IBM/Cognos/metricsmodel/daily-refresh.sh
05 00 * * 0 /opt/IBM/Cognos/metricsmodel/weekly-rebuild.sh

To:

05 00 * * 1-6 export ODBCINI=/root/.odbc.ini:export LD_LIBRARY_PATH =/opt/Progress/DataDirect/Connect_for_ODBC_71/lib/: /opt/IBM/Cognos/metricsmodel/daily-refresh.sh
05 00 * * 0 export ODBCINI=/root/.odbc.ini:export LD_LIBRARY_PATH =/opt/Progress/DataDirect/Connect_for_ODBC_71/lib/: /opt/IBM/Cognos/metricsmodel/weekly-rebuild.sh

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.