inlong icon indicating copy to clipboard operation
inlong copied to clipboard

[INLONG-6045][Sort] Support all migrate for Oracle connector

Open e-mhui opened this issue 2 years ago • 0 comments

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'

e-mhui avatar Oct 13 '22 09:10 e-mhui