第四章——数据抽取（案例二：抽取json数据到数据库extract中的数据表json中）

1.准备一个名为json_extract.json的JSON文件，内容如下：

{
    "status": "ok",
    "response": {
        "submissions": [
            {
                "id": "59434767",
                "timestamp": "2011-11-21 09:21:53",
                "user_agent": "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:8.0) Gecko/20100101 Firefox/8.0",
                "remote_addr": "192.168.1.1",
                "payment_status": "",
                "data": [
                    {
                        "field": "13776121",
                        "value": "Baylor Dallas"
                    },
                    {
                        "field": "13776401",
                        "value": "CHF"
                    },
                    {
                        "field": "13777966",
                        "value": "John Doe"
                    }
                ]
            },
            {
                "id": "59474875",
                "timestamp": "2011-11-21 17:01:22",
                "user_agent": "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:8.0) Gecko/20100101 Firefox/8.0",
                "remote_addr": "192.168.1.1",
                "payment_status": "",
                "data": [
                    {
                        "field": "13776121",
                        "value": "Healthsouth,"
                    },
                    {
                        "field": "13776401",
                        "value": "Pneumonia"
                    },
                    {
                        "field": "13777966",
                        "value": "Jane Doe"
                    }
                ]
            }
        ],
        "total": 2,
        "pages": 1
    }
}

2.新建一个转换并按照下述建立步骤后用跳连接

3.双击JSON input进行配置

 之后点击字段按照下图进行配置

  最后点击预览看数据是否抽取进来

 

 4.双击JSON input 2进行配置

勾选源定义在一个字段里并在从字段获取源后面写上data

然后点击字段进行如下配置

 5.双击表输出进行配置

接着点击目标表右边的浏览选择表json并勾选掉指定数据库字段 

 

 最后点击数据库字段进行获取字段和输入字段映射

 6.保存并运行

 7.查看导入到数据库表json中的数据