You can configure a mapping in advanced mode to read from and write to Elasticsearch tables.
Use the Data Integration Mapping Designer to define and configure a mapping in advanced mode for Elasticsearch sources and targets. In advanced mode, the Mapping Designer updates the mapping canvas to include transformations and functions that enable advanced functionality.
When you run a mapping in advanced mode, Data Integration analyzes the data logic defined in the mapping to automatically assign data logic to run on an advanced cluster.
You can configure a Source or Target transformation to represent an Elasticsearch object. Add the Source and Target transformations in the mapping canvas and configure the Elasticsearch source and target properties. You cannot configure a filter in the Source transformation. However, you can configure a Filter transformation to filter records from the source. To push the filter to the Elasticsearch source, configure the Filter transformation right after the Source transformation.