SAP Sybase ASE discovery

Discovery and Service Mapping uses the Sybase pattern to find SAP Sybase Adaptive Server Enterprise (ASE) databases and catalogs in your infrastructure. Discovering some of these resources may require updating to the latest version of the Discovery and Service Mapping Patterns application from the ServiceNow Store.

Request new or enhanced Patterns on the ServiceNow® Store

Visit the ServiceNow Store to view all the available updates and for information about submitting requests to the store. For cumulative release notes information for all released apps, see the ServiceNow Store version history release notes.

Prerequisites

• Verify that the applications are up to date.

  Discovery and Service Mapping Patterns

  CMDB CI Class Models

  Visibility Content

  For details on the product discovered see Detailed information on products discovered by ITOM Visibility

  Note: Discovery finds Sybase Catalog that run on Linux only.

• Verify the configuration of OS server credentials.

• Verify the configuration of the Applicative Credentials

  When configuring the Applicative Credentials, make sure you specify Sybase Instance [cmdb_ci_db_syb_instance] as the CI type.

  For more information on Applicative Credentials, see Applicative credentials

• Verify that the user have permission to run the following commands

  Execute the isql command.

  Have the Sybase environment run one of the commands:

  • "echo -ne 'set nocount on select name from sysdatabases\ngo\n' | " + $isql_path + " -U $$username$$ -P '$$password$$' -S " + $instance + " -w 999 -b -y " + $process.environmentVariables.SYBASE.value
  • "export SYBASE=" + $process.environmentVariables.SYBASE.value + " && . " + $process.environmentVariables.SYBASE.value + "/SYBASE.sh && echo -ne 'set nocount on select name from sysdatabases\ngo\n' | " + $isql_path + " -U $$username$$ -P '$$password$$' -S " + $instance + " -w 999 -b -y " + $process.environmentVariables.SYBASE.value
  • Verify the configuration of a Discovery schedule

  For detailed information, see Running discoveries in your network

Data collected during Horizontal discovery

Discovery populates the following data in the CMDB when running the Sybase pattern.

|Sybase instance [cmdb_ci_db_syb_instance]| |Label|Field Name| |-----------------------------------------------| |-----|----------| |Name|name| |Version|version| |Installation directory|install_directory| |Instance name|Instance| |Configuration file|config_file|

|Sybase Catalog [cmdb_ci_db_syb_catalog]| |Label|Field Name| |---------------------------------------------| |-----|----------| |Name|name|

CI relationships

These relationships are created to support the Sybase ASE discovery.

Parent Topic:Database discovery