Install > Set up legacy integrations

Set up legacy integrations

A legacy integration is any integration that depends on SCCL32 or the Service Manager ODBC driver. These products include Connect-It and Crystal Reports. Using legacy integrations with the Service Manager Server requires you to set up a read-only legacy ServiceCenter listener.

Follow the instructions in this section to set up legacy integrations.

Set up a legacy listener

The out-of-box server sc.ini file is configured to connect to the sample database. To connect to another RDBMS, edit the parameters in the sc.ini file.

To set up a legacy listener on a Window or Linux server:

  1. Edit the legacy sc.ini file:
    1. Log in to the Service Manager server with an administrator account.
    2. Open a command prompt and navigate to the RUN folder in the LegacyIntegration folder in the Service Manager Server directory. For example, <Service Manager installation path>\Server\LegacyIntegration\RUN.
    3. Open sc.ini with a text editor.
    4. To connect to your Service Manager RDBMS, add the database connectivity settings. Make sure that these settings match the settings that you used when you set up your RDBMS connection.

      If the legacy listener will connect to a case-insensitive Oracle database, add the parameter sql_oracle_binary_ci to the sc.ini file.

    5. (For Windows) Add the following parameter on its own line: ntservice:<Service Manager Legacy Read-only Service Name>.
    6. Save and close the sc.ini file.
  2. (For Windows) Install the Windows service:
    1. Log on to the Windows server as a user with local administrator privileges.
    2. Open a command prompt and navigate to <Service Manager installation path>\Server\LegacyIntegration\RUN.
    3. Type scservic -install.

      This command creates a Windows service with the name specified by the ntservice parameter in the sc.ini file.

  3. (For Linux) Run the scstart script in the <Service Manager installation path>\Server\LegacyIntegration\RUN folder.

Install the ODBC driver

To install the Service Manager ODBC driver, follow these steps:

  1. Log on to the Windows server as a user with local administrator privileges.
  2. Extract the reports package file into the appropriate drive of the server.

  3. Navigate to the \Reporting directory.
  4. Run the ServiceManager ODBC Driver-x.xx.exe file.
  5. Click Next to read and accept the licensing agreement. The Next button becomes active.
  6. Click Next to select your installation folder. The default installation location is C:\Program Files (x86)\Micro Focus\Service Manager x.xx\ODBC. Click Choose to select a different location.
  7. Click Next to prepare the installation process.
  8. Click Install to begin copying the installation files. A dialog box opens when the installation is complete.
  9. Click Done.

Configure the ODBC driver

The default installation sets up the ODBC DSN to connect to the default legacy listener on the local host. Configure the legacy ODBC driver to connect to the legacy read-only listener:

  1. From the Windows Start menu, click Control Panel > Administrative Tools > Data Source (ODBC).
  2. Open the System DSN tab.
  3. Select sc_report_odbc and click Configure.
  4. Configure the ODBC driver by using the following parameters:
    • Data Source Name: sc_report_odbc
    • Server: The host where the legacy ServiceCenter listener is running. The default setting is localhost.
    • Port: The port the legacy server is set to use. The default setting is 12690.

Start the legacy listener

For a Linux server, perform the following steps:

  1. Navigate to <Service Manager installation path>\Server\legacyintegration\RUN.
  2. Run the scstart script.

For a Windows server, perform the following steps:

  1. From the Windows Start menu, select Control Panel > Administrative Tools > Services. select the service that you installed when you set up the legacy listener, and then click Start.

    You can start the listener as an application rather than as a service. To do so, go to the <Service Manager installation path>\Server\ LegacyIntegration\RUN directory and run the following command using the Windows command prompt: scenter -listener:<port number> -RPCReadOnly.

  2. Verify that the ODBC driver can connect. To test the connection, use any ODBC query tool. For example, in Excel, open: Data > Get External Data > New Database Query. Select the ServiceCenter ODBC driver as your data source. If it connects, it displays the Service Manager tables.

RPC read-only mode parameter

You must start a legacy listener with the RPC read-only mode parameter. This parameter allows a Service Manager server to connect to a Service Manager database without interfering with the Service Manager server (it does not create a system lock).

The RPC read-only parameter prevents Service Manager clients (Windows, web tier, and web services) from connecting to the Service Manager server. The only connections the ServiceCenter 6.2 RPCReadOnlyMode listener accepts are connections from the Service Manager ODBC driver or Connect-It.

  • If you use Connect-It 3.81 or later, you must provide the host name and port for both the Service Manager and ServiceCenter 6.2 ReadOnly listener. Connect-It requires this information to use the RPC functions for reading the event services and other Service Manager information. The connector writes data to Service Manager through web services.
  • You can also use the legacy listener to run reports or SQL queries against your Service Manager data without affecting the Service Manager performance.

Install Crystal Reports for use with Service Manager

You can use Crystal Reports to view, update, and develop new reports with Service Manager.

Follow these steps to install Crystal Reports 2013 SP3 for use with Service Manager:

  1. If Crystal Reports 2008 with or without SP1 or SP3 has been installed before, use Uninstall or change a program from the Windows Control Panel to uninstall Crystal Reports 2008 with the service packs and all associated Language Packs.
  2. Make sure that the Service Manager ODBC Driver is installed.
  3. Log in to the Windows server as a user with local administrator privileges.
  4. Extract the reports package file into the appropriate drive of the server.
  5. Navigate to the \Reporting\CrystalReports directory.
  6. Right-click SilentInstall.bat and then select Run as administrator.

    The installation wizard starts.

  7. Restart your computer when the installation is complete. You must restart your computer before opening Crystal Reports 2013.
  8. Start the legacy listener.

Download reports for Service Manager

This release no longer provides out-of-box reports that you can run using Crystal Reports. You can download these reports from the Service Manager 9.50 release.

Using these reports requires the Service Manager ODBC driver and requires that the legacy listener is started.

  1. Make sure that the Service Manager ODBC driver is installed.
  2. Log in to the Windows server as a user with local administrator privileges.
  3. Extract the reports package file into the appropriate drive of the server.
  4. Navigate to the \Reporting\OperationalReports directory.
  5. Copy the desired reports to your local directory.