SAP Sybase ASE - Overview

Overview

SAP Adaptive Server Enterprise (ASE), also known as Sybase, is a relational database management system. It is a high-performance SQL database server that uses a relational management model to meet rising demand for performance, reliability, and efficiency in every industry.

This integration fetches live server statistics such as System CPU Utilization, I/O CPU Utilization, Network Statistics, and more, allowing you to visualize your database server health in Datadog dashboards.

Custom Query Configuration

This feature allows you to define queries directly within the integration’s configuration.

1. To set up your custom queries, edit the crest_data_systems_sybase.d/conf.yaml file with the following format:

    custom_queries:
      - query: <Query>
        columns:
          - name: <Metric_Name>
            type: metric
          - name: <Tag_Name>
            type: tag
        table_name: <Table_Name>
   

   • Explanation :
     • query: The custom Sybase SQL query to be executed. It should be a single line select statement,system procedures or complex SQL queries.
     • columns: Each column returned by the query must have a corresponding entry defining:
       • name: The name of the metric or data point. which must exactly match the column name in the queried table.
       • type: The type of the data collection. Must be ‘metric’ or ’tag.
     • table_name: A string prefix used to name the custom metrics generated from this query. It is not necessary to use the same name as the table used in the query; it is simply a prefix for the ingested metric.

2. While adding the column parameter below point need to ensure.

   • Ensure that the parameters query, columns, and table_name are included.
   • The name and type fields within each column entry must not be empty.
   • Each query should include at least one column with the metric type. Multiple metrics can be defined for a single query, in which case each metric will be associated with tag values.
   • The type fields only contains the value as “Metric” or ”Tag”.
   • One can add multiple custom queries as shown in the below example.

3. Example:

   instances:
     - SYBASE_SERVER_HOST: <IPV4 OR HOSTNAME>
       SYBASE_PORT: <PORT>
       SYBASE_USERNAME: <USERNAME>
       SYBASE_PASSWORD: <PASSWORD>
       ODBC_DRIVER: '<ODBC_DRIVER_NAME>'
       custom_queries:
         - query: SELECT Name,AccountType,Balance,Age FROM BankAccount
           columns:
             - name: Age
               type: metric
             - name: Balance
               type: metric
             - name: AccountType
               type: tag
             - name: Name
               type: tag
           table_name: BankAccount
         - query: SELECT Age, state, UserName FROM customTable
           columns:
             - name: Age
               type: metric
             - name: state
               type: tag
             - name: UserName
               type: tag
           table_name: customTable
       min_collection_interval: 300
   

Support

For support or feature requests, contact Crest Data through the following channels:

• Support Email: datadog.integrations@crestdata.ai
• Sales Email: datadog-sales@crestdata.ai
• Website: crestdata.ai
• FAQ: Crest Data Datadog Marketplace Integrations FAQ

Troubleshooting

Need help? Contact Datadog support.

This application is made available through the Datadog Marketplace and is supported by a Datadog Technology Partner. To use it, purchase this application in the Marketplace.