OceanBase Migration Service (OMS) Community Edition V4.2.9-CE and later allow you to migrate data from an ElasticSearch database to OceanBase Community Edition. This topic describes the parameters of ElasticSearchSource.
| Parameter | Description |
|---|---|
| retainId | Specifies whether to migrate the _id field of ElasticSearch. The default value is false. |
| esIdName | The ID field name in OceanBase Community Edition to which the ElasticSearch _id field maps. The default value is id. |
| scrollTime | The validity period of scroll_id, in minutes. The default value is 1. |
| scrollSize | The number of data items returned per scroll query. |
| sliceFieldMap | The name of the field used for slicing each table. The slicing field must be of the number data type. The format is { "tabeName1":"field1", "tableName2":"field2" } |
| enableSliceById | Specifies whether to allow slicing by the _id field. The default value is true. |
| flattenMode | Specifies whether to split object-type fields. The default value is false. |
| flattenFormat | The format of the subfield name, in which {parent} and {child} are placeholders. For example, {parent}_{child}, where {parent} represents the name of the parent field and {child} represents the name of the child field. |
| flattenFieldMap | The mapping of the nested subfield name at the source. The map structure is in the {"indexname.field.subfieldName...":"mappedName"} format. |
| insertToInsertOnDuplicate | ElasticSearch cannot distinguish between INSERT and UPDATE, so the incremental synchronization from the ElasticSearch database to OceanBase Database is enabled by default. The default value is true (indicating that it is enabled), and the INSERT ON DUPLICATE statement is used to write data. |