|
|
|
## 1.MSSQL 数据管理概述
|
|
|
|
1. 通过sql语句获取第三方数据库数据
|
|
|
|
2. 对提取的数据进行转换处理
|
|
|
|
## 2.部署
|
|
|
|
1. PHP 配置 sqlsrv 扩展
|
|
|
|
|
|
|
|
|
|
|
|
## 3.配置
|
|
|
|
1. 进入接口管理，添加api，选择mssql
|
|
|
|
2. 配置数据
|
|
|
|
3. 支持token，[api:svc:pm.parser::getQueryData(id)]这个token可以获取到前端传入的数据id参数的值，当前用户名：[current-user:name]
|
|
|
|
|
|
|
|
|
|
|
|
```
|
|
|
|
settings:
|
|
|
|
api:
|
|
|
|
etl_config:
|
|
|
|
source:
|
|
|
|
host: 172.18.0.4
|
|
|
|
port: '1433'
|
|
|
|
database: users
|
|
|
|
user: root
|
|
|
|
pass: '12344'
|
|
|
|
character_set: UTF-8
|
|
|
|
fields:
|
|
|
|
- name: INFO
|
|
|
|
label: Info name
|
|
|
|
selector: INFO
|
|
|
|
- name: SEQ
|
|
|
|
label: seq label
|
|
|
|
selector: SEQ
|
|
|
|
ids:
|
|
|
|
INFO:
|
|
|
|
type: string
|
|
|
|
sql_query: SELECT top 6 INFO,SEQ FROM HELP
|
|
|
|
plugin: sqlsrv
|
|
|
|
api_id: '18'
|
|
|
|
process:
|
|
|
|
name:
|
|
|
|
- plugin: get
|
|
|
|
source: INFO
|
|
|
|
mydata:
|
|
|
|
- plugin: get
|
|
|
|
source: SEQ
|
|
|
|
destination:
|
|
|
|
plugin: api_response_data
|
|
|
|
id: api_id_18
|
|
|
|
label: mssql连接示例
|
|
|
|
migration_group: API
|
|
|
|
id: '18'
|
|
|
|
type: sqlsrv
|
|
|
|
status: 1
|
|
|
|
title: mssql连接示例
|
|
|
|
url_alias: "/portal/mssql/demo"
|
|
|
|
access_roles:
|
|
|
|
- authenticated
|
|
|
|
|
|
|
|
|
|
|
|
```
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
