ETL08.MSSQL 数据管理

1.MSSQL 数据管理概述

通过sql语句获取第三方数据库数据
对提取的数据进行转换处理

2.部署

PHP 配置 sqlsrv 扩展

3.配置

进入接口管理，添加api，选择mssql
配置数据
支持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