Home
Administering Connections 7.0
Welcome to the HCL Connections documentation site. 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.
Upgrading and updating
Upgrade HCL Connections and its supporting software to the latest release and then update the installation with the latest interim fixes or cumulative fixes. Refer to the What's New in HCL Connections to review the features in the latest release and gather download links or links to the latest fix list and update strategy information.
In-place and hybrid upgrades
With the Update function in IBM Installation Manager, you can upgrade the existing version of Connections to the next version, either in your production environment or in a in a new environment identical to production.
Updating databases
Update your HCL Connections 6.5 CR1 databases to version 7.0 in a WebSphere® Application Server and database environment.
Updating SQL Server databases
Manually update HCL Connections 6.5 CR1 databases to version 7.0 in a WebSphere® Application Server and Microsoft™ SQL Server database environment.

Administering Connections 7.0
Welcome to the HCL Connections documentation site. 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 Connections
  To install HCL Connections™, you need to follow a detailed series of procedures.
- Installing or upgrading Component Pack for Connections
  HCL Connections 7.0 now supports the latest Component Pack based in Harbor, an open-source container and Helm registry hosted by HCL for the Component Pack build. Deployments that are new or carrying Component Pack 7 will use this approach for a simplified installation/upgrade process, while releases prior to 7.0 will first need to upgrade to Component Pack 7 using a zip file and a local Docker registry.
- Post-installation tasks
  After installation, you need to perform further tasks to ensure an efficient deployment.
- Optional: Installing and configuring Tiny Editors for HCL Connections
  The Tiny editors are alternative rich-text editors which can be installed for HCL Connections™. They provide additional features and extensive customization options not available with the default editor.
- Optional post-installation tasks
  Complete the post-installation tasks that are relevant to your deployment.
- Uninstalling
  Uninstall HCL Connections.
- Upgrading and updating
  Upgrade HCL Connections and its supporting software to the latest release and then update the installation with the latest interim fixes or cumulative fixes. Refer to the What's New in HCL Connections to review the features in the latest release and gather download links or links to the latest fix list and update strategy information.
  - Getting ready for upgrading or updating
    Take steps to inform users and protect data before starting an HCL Connections upgrade or update.
  - Ways to upgrade to Connections 7
    You can upgrade to HCL Connections 7 by by doing either a side-by-side or an in-place upgrade, or by taking an approach that is a hybrid of the two.
  - Side-by-side upgrades
    You can upgrade to Connections 7.0 by installing it in a new environment and then migrating data, configurations, and customizations from the existing production environment before switching over.
  - In-place and hybrid upgrades
    With the Update function in IBM Installation Manager, you can upgrade the existing version of Connections to the next version, either in your production environment or in a in a new environment identical to production.
    - Considerations for an in-place or hybrid upgrade
      Both the in-place and hybrid approach use the Update function in IBM Installation Manager to apply 7.0 updates to a 6.5 CR1 server, preserving some of the existing configuration settings.
    - Performing an in-place or hybrid upgrade
      Upgrade to an HCL Connections 7.0 deployment by running the Installation Manager Update function on a Connections 6.5 CR1 deployment. This can be done either in-place (in your existing production environment) or using a hybrid approach of installing 6.5 in a new environment identical to production, updating that to 6.5 CR1, and then running the upgrade to 7.
    - Updating databases
      Update your HCL Connections 6.5 CR1 databases to version 7.0 in a WebSphere® Application Server and database environment.
      - Updating Db2 databases
        Manually update HCL Connections 6.5 CR1 databases to version 7.0 in a WebSphere® Application Server and DB2® database environment.
      - Updating Oracle databases
        Manually update HCL Connections 6.5 CR1 databases to version 7.0 in a WebSphere® Application Server and Oracle database environment.
      - Updating SQL Server databases
        Manually update HCL Connections 6.5 CR1 databases to version 7.0 in a WebSphere® Application Server and Microsoft™ SQL Server database environment.
  - Updating Connections 7.0 with the latest fixes
    There are two types of fixes for HCL Connections 7.0 - interim fixes (iFixes) and cumulative fixes (CFixes). iFixes address single issues, while cumulative fixes address groups of issues. Both iFixes and CFixes are installed in the same manner and will be referred to as "fixes" in the installation instructions.
  - Synchronizing nodes
    Synchronize all the nodes in a cluster.
- 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 HCL products, including HCL Connections™.

Updating SQL Server databases

Manually update HCL Connections 6.5 CR1 databases to version 7.0 in a WebSphere® Application Server and Microsoft™ SQL Server database environment.

Procedure

Back up the Homepage database.
Run the script located in /Wizards/connections.sql/homepage/sqlserver/upgrade-60CR4-70.sql as follows:
```
sqlcmd -U dbUser -P dbPassword -i upgrade-60CR4-70.sql
```