gNMI and Microsoft SQL Server Integration

<pre><code class="language-toml"> [[inputs.gnmi]] ## Address and port of the gNMI GRPC server addresses = ["10.49.234.114:57777"] ## define credentials username = "cisco" password = "cisco" ## gNMI encoding requested (one of: "proto", "json", "json_ietf", "bytes") # encoding = "proto" ## redial in case of failures after # redial = "10s" ## gRPC Keepalive settings ## See https://pkg.go.dev/google.golang.org/grpc/keepalive ## The client will ping the server to see if the transport is still alive if it has ## not see any activity for the given time. ## If not set, none of the keep-alive setting (including those below) will be applied. ## If set and set below 10 seconds, the gRPC library will apply a minimum value of 10s will be used instead. # keepalive_time = "" ## Timeout for seeing any activity after the keep-alive probe was ## sent. If no activity is seen the connection is closed. # keepalive_timeout = "" ## gRPC Maximum Message Size # max_msg_size = "4MB" ## Enable to get the canonical path as field-name # canonical_field_names = false ## Remove leading slashes and dots in field-name # trim_field_names = false ## Guess the path-tag if an update does not contain a prefix-path ## Supported values are ## none -- do not add a 'path' tag ## common path -- use the common path elements of all fields in an update ## subscription -- use the subscription path # path_guessing_strategy = "none" ## Prefix tags from path keys with the path element # prefix_tag_key_with_path = false ## Optional client-side TLS to authenticate the device ## Set to true/false to enforce TLS being enabled/disabled. If not set, ## enable TLS only if any of the other options are specified. # tls_enable = ## Trusted root certificates for server # tls_ca = "/path/to/cafile" ## Used for TLS client certificate authentication # tls_cert = "/path/to/certfile" ## Used for TLS client certificate authentication # tls_key = "/path/to/keyfile" ## Password for the key file if it is encrypted # tls_key_pwd = "" ## Send the specified TLS server name via SNI # tls_server_name = "kubernetes.example.com" ## Minimal TLS version to accept by the client # tls_min_version = "TLS12" ## List of ciphers to accept, by default all secure ciphers will be accepted ## See https://pkg.go.dev/crypto/tls#pkg-constants for supported values. ## Use "all", "secure" and "insecure" to add all support ciphers, secure ## suites or insecure suites respectively. # tls_cipher_suites = ["secure"] ## Renegotiation method, "never", "once" or "freely" # tls_renegotiation_method = "never" ## Use TLS but skip chain &amp; host verification # insecure_skip_verify = false ## gNMI subscription prefix (optional, can usually be left empty) ## See: https://github.com/openconfig/reference/blob/master/rpc/gnmi/gnmi-specification.md#222-paths # origin = "" # prefix = "" # target = "" ## Vendor specific options ## This defines what vendor specific options to load. ## * Juniper Header Extension (juniper_header): some sensors are directly managed by ## Linecard, which adds the Juniper GNMI Header Extension. Enabling this ## allows the decoding of the Extension header if present. Currently this knob ## adds component, component_id &amp; sub_component_id as additional tags # vendor_specific = [] ## YANG model paths for decoding IETF JSON payloads ## Model files are loaded recursively from the given directories. Disabled if ## no models are specified. # yang_model_paths = [] ## Define additional aliases to map encoding paths to measurement names # [inputs.gnmi.aliases] # ifcounters = "openconfig:/interfaces/interface/state/counters" [[inputs.gnmi.subscription]] ## Name of the measurement that will be emitted name = "ifcounters" ## Origin and path of the subscription ## See: https://github.com/openconfig/reference/blob/master/rpc/gnmi/gnmi-specification.md#222-paths ## ## origin usually refers to a (YANG) data model implemented by the device ## and path to a specific substructure inside it that should be subscribed ## to (similar to an XPath). YANG models can be found e.g. here: ## https://github.com/YangModels/yang/tree/master/vendor/cisco/xr origin = "openconfig-interfaces" path = "/interfaces/interface/state/counters" ## Subscription mode ("target_defined", "sample", "on_change") and interval subscription_mode = "sample" sample_interval = "10s" ## Suppress redundant transmissions when measured values are unchanged # suppress_redundant = false ## If suppression is enabled, send updates at least every X seconds anyway # heartbeat_interval = "60s" </code></pre>

<pre><code class="language-toml">[[outputs.sql]] ## Database driver ## Valid options: mssql (Microsoft SQL Server), mysql (MySQL), pgx (Postgres), ## sqlite (SQLite3), snowflake (snowflake.com), clickhouse (ClickHouse) driver = "mssql" ## Data source name ## For Microsoft SQL Server, the DSN typically includes the server, port, username, password, and database name. ## Example DSN: "sqlserver://username:password@localhost:1433?database=telegraf" data_source_name = "sqlserver://username:password@localhost:1433?database=telegraf" ## Timestamp column name timestamp_column = "timestamp" ## Table creation template ## Available template variables: ## {TABLE} - table name as a quoted identifier ## {TABLELITERAL} - table name as a quoted string literal ## {COLUMNS} - column definitions (list of quoted identifiers and types) table_template = "CREATE TABLE {TABLE} ({COLUMNS})" ## Table existence check template ## Available template variables: ## {TABLE} - table name as a quoted identifier table_exists_template = "SELECT 1 FROM {TABLE} LIMIT 1" ## Initialization SQL (optional) init_sql = "" ## Maximum amount of time a connection may be idle. "0s" means connections are never closed due to idle time. connection_max_idle_time = "0s" ## Maximum amount of time a connection may be reused. "0s" means connections are never closed due to age. connection_max_lifetime = "0s" ## Maximum number of connections in the idle connection pool. 0 means unlimited. connection_max_idle = 2 ## Maximum number of open connections to the database. 0 means unlimited. connection_max_open = 0 ## Metric type to SQL type conversion ## You can customize the mapping if needed. #[outputs.sql.convert] # integer = "INT" # real = "DOUBLE" # text = "TEXT" # timestamp = "TIMESTAMP" # defaultvalue = "TEXT" # unsigned = "UNSIGNED" # bool = "BOOL" </code></pre>