SqlServer 查询数据
简介
service_mssql
input
插件可以采集Sql Server查询数据。
版本
配置参数
样例
Sql Server数据库创建LogtailTest数据库,LogtailTestTable表。
表结构及数据信息如下
IF NOT EXISTS(SELECT * FROM sys.databases WHERE name = 'LogtailTest')
BEGIN
CREATE DATABASE [LogtailTest]
END
GO
USE [LogtailTest]
GO
IF NOT EXISTS (SELECT * FROM sysobjects WHERE name='LogtailTestTable' and xtype='U')
BEGIN
CREATE TABLE LogtailTestTable (
id INT PRIMARY KEY IDENTITY (1, 1),
name NVARCHAR(50),
quantity INT
)
END
GO
INSERT INTO LogtailTestTable (name, quantity) values('banana', 1);
INSERT INTO LogtailTestTable (name, quantity) values('banana', 2);
INSERT INTO LogtailTestTable (name, quantity) values('banana', 3);
INSERT INTO LogtailTestTable (name, quantity) values('banana', 4);
SELECT * FROM LogtailTestTable;
GO
采集配置
enable: true
inputs:
- Type: service_mssql
Address: 127.0.0.1
CheckPoint: true
CheckPointColumn: id
CheckPointColumnType: int
CheckPointSavePerPage: true
CheckPointStart: "0"
Database: LogtailTest
IntervalMs: 1000
Limit: true
MaxSyncSize: 100
PageSize: 100
User: sa
Password: xxxxx
StateMent: "select * from LogtailTestTable where id > ? order by id"
flushers:
- Type: flusher_stdout
OnlyStdout: true
输出
{"id":"1","name":"banana","quantity":"1","__time__":"1661416452"}
{"id":"2","name":"banana","quantity":"2","__time__":"1661416452"}
{"id":"3","name":"banana","quantity":"3","__time__":"1661416452"}
{"id":"4","name":"banana","quantity":"4","__time__":"1661416452"}
Last updated