Skip to content

[Microsoft SQLServer] Add support for List of Dynamic counters #14083

Open
@muthu-mps

Description

@muthu-mps

Summary

The integration currently supports dynamic counter value using LIKE operator which provides capability to add more counters based on the input provided.

Based on the recent research we try to use the Regex operator to add multiple counter values as input.

Challenges in using Regex:

  • As a user knowing the exact metrics, Do we need to build a regex pattern?
  • Using regex doesn't offer the exact match for a metric and pulls additional metrics.

Solution

Is it possible to add list of counter values as an input?

  • Yes its possible to pass list of values as input and generate query out of it.
  • I have made the counter value as array and that which generates me the query to match the given input.

Integration Upgrade

Will changing the input parameter from text to an array ensure seamless integration upgrade experience for the end user?

  • Yes / No
  • Yes, If the dynamic counter is black. This may not be the case as we have default value for this config.
  • No, The integration fails to upgrade and reports issue with the field type when the counter value exists.

How to fix the upgrade failure?

  • This can be achieved by removing the existing input value from the config and save the integration then upgrade the integration by providing the dynamic counter values.
  • We can check whether its possible to upgrade integration without modifying the input value.

Short video on integration upgrade scenario,

mssql-change-input-text-array.mp4

cc: @lalit-satapathy

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions