Welcome
Upgrading and migrating
Learn how to upgrade and migrate data for the product.
Configuring your environment after upgrading
After upgrading HCL Compass and installing any new components, there are series of tasks to perform both to verify a successful upgrade, and to configure new or upgraded components.
Setting database properties and connection information
Database properties and connection information for SQL Server
If you use a SQL Server database and are upgrading to latest version for Windows™, Linux™ and the UNIX™ system, you might need to modify the database properties of your schema repositories and user databases.
Using SQL Server from Linux

HCL Compass V2.2.8
Overview
Learn general information about the product.
Installing
Learn how to install the product.
Upgrading and migrating
Learn how to upgrade and migrate data for the product.
- Planning your upgrade
  To plan a HCL Compass upgrade, identify prerequisite requirements for hardware and software, choose an upgrade strategy, select HCL Compass features to install, understand how to upgrade HCL Compass server components, and prepare your environment.
- Upgrading HCL Compass
  Review the upgrade information and complete optional and required tasks for upgrading HCL Compass.
- Configuring your environment after upgrading
  After upgrading HCL Compass and installing any new components, there are series of tasks to perform both to verify a successful upgrade, and to configure new or upgraded components.
  - Restart and verify servers
    After the servers have been upgraded, restart each one and verify that it is operating correctly.
  - Clearing the browser cache
    After a HCL Compass server upgrade, notify HCL Compass Web client users to clear their browser cache, delete cookies, and temporary internet files.
  - Updating link configuration for OSLC integrations
    If you upgraded from HCL Compass version 8.0.0.3 or earlier and your environment supports OSLC integrations, update the OSLC configuration to prevent link errors.
  - Changing the feature level and metaschema version
    Changing the HCL Compass feature level and metaschema version can take several hours. The process changes the schema repository and all associated user databases. Typically, new tables are added to all databases, and new columns might be added to existing tables.
  - Migrating Compass Web configuration settings
    After upgrading HCL Compass, you might want to apply the same configuration settings to HCL Compass Web Server that existed in your previous configuration of Compass Web. Some settings are automatically propagated during the upgrade, while others must be set manually.
  - Upgrading packages to the latest versions
    Each package has its own version number that is unrelated to the HCL Compass product version number.
  - Setting database properties and connection information
    - Database properties and connection information for DB2®
      If you use a DB2® database and upgrading, you must update the database properties of your schema repositories and user databases.
    - Database Password Encryption for Oracle
      By default, HCL Compass sends an encrypted database passwords to the Oracle server.
    - Database properties and connection information for SQL Server
      If you use a SQL Server database and are upgrading to latest version for Windows™, Linux™ and the UNIX™ system, you might need to modify the database properties of your schema repositories and user databases.
      - Supporting mixed environments for SQL Server
      - SQL Server connection information
      - Configuring Microsoft™ SQL Server
        To use HCL Compass with SQL Server databases, you must install a supported version of SQL Server on your database server.
      - Using SQL Server from Linux
  - Propagating connection information to clients
    If the connection information for HCL Compass schema repositories or user databases has changed, propagate a new connection profile to HCL Compass clients.
Administering
Learn how to administer the product.
Reporting
Learn how to generate reports for the product.
Developing
Learn how to develop schemas by using the HCL Compass Designer.
Managing change and releases
Learn how to manage change and release in the product.
Integrating
You can integrate HCL Compass with other software by adding packages to existing schema.
Extending product function
Learn how to extend the product.
Reference
Review reference information for the product.
Glossary
Tutorials

Using SQL Server from Linux

By default, Compass on Linux uses Microsoft ODBC Driver 17 for SQL Server (version 17.4).

To use Microsoft ODBC Driver 18, perform the following steps:

Follow the directions from Microsoft to install the ODBC driver version 18 for SQL Server on Linux.
Locate the cqodbcinst.ini file in the Compass installation. This file can be found in the linux_x86-64/resources/ directory of the installation.

Edit the cqodbcinst.ini file so that the following section points at the newly installed driver:

[CCM Microsoft ODBC Driver for SQL Server]
Description=Microsoft ODBC Driver 18 for SQL Server
Driver=/opt/microsoft/msodbcsql18/lib64/libmsodbcsql-18.5.so.1.1