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.
To set up your custom queries, edit the crest_data_systems_sybase.d/conf.yaml file with the following format:
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.
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.
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:
