# kettle-script

**Repository Path**: xujiafu/kettle-script

## Basic Information

- **Project Name**: kettle-script
- **Description**: kettle 快速迁移yashandb的脚本
- **Primary Language**: Shell
- **License**: Apache-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2023-12-01
- **Last Updated**: 2023-12-01

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# kettle-script

#### 介绍
kettle 快速迁移yashandb的脚本
1. 安装Java环境、Kettle软件

2. 编辑kettle的连接信息，调整simple-jndi文件夹下jdbc.property

   例如：

   ```
   --源端oracle
   #DataInput/type=javax.sql.DataSource
   #DataInput/driver=oracle.jdbc.driver.OracleDriver
   #DataInput/url=jdbc:oracle:thin:@192.168.4.180:1521/PDB1
   #DataInput/user=KETTLE_USER
   #DataInput/password=YASDB_123
   --源端mysql
   DataInput/type=javax.sql.DataSource
   DataInput/driver=com.mysql.cj.jdbc.Driver
   DataInput/url=jdbc:mysql://192.168.4.180:3309/test
   DataInput/user=kettle_user
   DataInput/password=yasdb_123
   --目标端崖山库地址
   yasOutput/type=javax.sql.DataSource
   yasOutput/driver=com.yashandb.jdbc.Driver
   yasOutput/url=jdbc:yasdb://192.168.4.180:1688/test
   yasOutput/user=k_user
   yasOutput/password=yasdb_123
   
   ```

   注: DataInput 、yasOut

   3. 向Table.txt 添加需要迁移的表

```
Table
TEST_SLOW_LOG
```

4. Linux下用kitchen.sh执行编排的脚本

例如

```
/home/kettle/data-integration/kitchen.sh  -file=/home/kettle/data-integration/my-script/AutoInputData.kjb -logfile=/home/kettle/data-integration/my-script/kettle_run.log >> /home/kettle/data-integration/my-script/kitchen_run.log

-file 编排任务的kjb脚本
-logfile kettle输出的日志文件地址
```