inlong
inlong copied to clipboard
[INLONG-6045][Sort] Support all migrate for Oracle connector
Sort support all migrate for Oracle connector
- Fixes #6045
Motivation
The thing is sometime user want to export all data from database with diffrent schema to kafka with canal json This is something flinkcdc cannot do since we all need to specify the source shema when writing sql
Modifications
refer: #4010
Documentation
- Does this pull request introduce a new feature? (yes)
Verifying this change
run AllMigrateOracleTest
How to config option
Option | Required | Default | Type | Description |
---|---|---|---|---|
migrate-all | optional | false | String | Specify 'migrate-all' = 'true' to enable the all database migration function |
schema-name | required | (none) | String | Schema name of the Oracle database to monitor. If you want to capture multiple schemas, you can use commas to separate them. For example: 'schema-name' = 'SCHEMA1,SCHEMA2' |
table-name | required | (none) | String | Table name of the Oracle database to monitor. If you want to capture multiple tables, you can use commas to separate them. For example: 'table-name' = 'SCHEMA1.TB.*, SCHEMA2.TB1' |