datax常用例子

 

1.select具体字段

[root@host135 script]# more sqlserver2mysql02.json
{
    "job": {
        "content": [
            {
                "reader": {
                    "name": "sqlserverreader",
                    "parameter": {
                        "connection": [
                            {
                                "jdbcUrl": ["jdbc:sqlserver://192.168.2.84:1433;DatabaseName=db_test"],
                                "querySql": ["select id,platform,site_id from tb_test"]
                            }
                        ],
                        "password": "pub@123456",
                        "username": "sa",
                        "column": ["*"]
                    }
                },
                "writer": {
                    "name": "mysqlwriter",
                    "parameter": {
                        "column": [
                                    "id",
                                     "platform",
                                     "site_id"
                                  ],
                        "connection": [
                            {
                                "jdbcUrl": "jdbc:mysql://192.168.1.135:3306/db_hxl",
                                "table": ["tb_test"]
                            }
                        ],
                        "password": "mysql",
                        "preSql": ["truncate table tb_test"],
                        "session": [],
                        "username": "root",
                        "writeMode": "insert"
                    }
                }
            }
        ],
        "setting": {
            "speed": {
                "channel": "5"
            }
        }
    }
}

 

2.sql server导出成文本

[root@host135 script]# more sqlserver2textfile.json 
{
    "job": {
        "content": [
            {
                "reader": {
                    "name": "sqlserverreader",
                    "parameter": {
                        "connection": [
                            {
                                "jdbcUrl": ["jdbc:sqlserver://192.168.2.84:1433;DatabaseName=db_test"],
                                "querySql": ["select id,platform,site_id,add_time,update_time from tb_test"]
                            }
                        ],
                        "password": "pub@123456",
                        "username": "sa",
                        "column": ["*"]
                    }
                },
                "writer": {
                    "name": "txtfilewriter",
                    "parameter": {
                        "path": "/tmp/mydata",
                        "fileName": "mydat",
                        "fieldDelimiter":"€",
                        "writeMode": "truncate",
                        "dateFormat": "yyyy-MM-dd HH:mm:ss.SSS"                      
                    }
                }
            }
        ],
        "setting": {
            "speed": {
                "channel": "5"
            }
        }
    }
}

 

3.oracle导出成文本

{
    "job": {
        "content": [
            {
                "reader": {
                    "name": "oraclereader",
                    "parameter": {
                        "column": ["*"],
                        "connection": [
                            {
                                "jdbcUrl": ["jdbc:oracle:thin:@192.168.1.101:1521/slnngk"],
                                "querySql": ["select * from tb_ogg_test where id<=100"]
                            }
                        ],
                        "password": "oracle",
                        "username": "hxl"
                    }
                },
                "writer": {
                    "name": "txtfilewriter",
                    "parameter": {
                        "path": "/tmp/mydata",
                        "fileName": "mydat",
                        "fieldDelimiter":"€",
                        "writeMode": "truncate",
                        "dateFormat": "yyyy-MM-dd HH:mm:ss.SSS"                      
                    }
                }
            }
        ],
        "setting": {
            "speed": {
                "channel": "3"
            }
        }
    }
}