Welcome Guest! Log in
Stambia versions 2.x, 3.x, S17, S18, S19 and S20 are reaching End of Support January, 15th, 2024. Please consider upgrading to the supported Semarchy xDI versions. See Global Policy Support and the Semarchy Documentation.

The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…


Stambia Data Integration allows to work with Elasticsearch servers to produce fully customized Integration Processes.

An Elasticsearch Metadata is available to reverse all the Indexes and Document Types that can then be used in mappings to perform operations on the Elasticsearch server.

Prerequisites:
  • Stambia DI Designer S18.2.3 or higher
  • Install the Elasticsearch libraries in the Designer and Runtime (as explained in the getting started article)

Note:

Stambia DI is a flexible and agile solution. It can be quickly adapted to your needs.

If you have any question, any feature request or any issue, do not hesitate to contact us.

This component may require a dedicated license.

Please contact the Stambia support team if you have any doubt and if you need to use it in a production environment.

 

Download

You can find below the necessary resources to work with this Component in Stambia DI

Name Description Download
Component resources You can find in download section the Component resources. Component resources download

 

To learn how to install and use the connector with Stambia DI, have a look at the following getting started article.

 

Supported features

You can find below an overview of what Stambia DI can do with Elasticsearch databases

Name Description
Reverse

The following Elasticsearch objects can be reversed in a dedicated Metadata:

  • Indexes
  • Document Types
  • Search Queries
Document Operations

The following operations can be performed on Document Types:

  • Insert
  • Update
  • Upsert
  • Get
  • Delete
Search Queries

The search queries reversed in the Metadata can be used to retrieve the query's response data and store it into rdbms.

The following query types are supported:

  • Scan
  • Count
  • Dfs_query_and_fetch
  • Dfs_query_then_fetch
  • Query_and_fetch
  • Query_then_fetch
Search Scroll Mode The Scroll Mode can be used when using search queries
Aggregations Aggregations can be performed through the search queries
Security
  • HTTP Basic Authentication is supported (for Reverse)
  • SearchGuard security is supported (for Document operations)
Elasticsearch Supported Server Versions
  • 2.x
  • 5.x
  • 6.x
  • 7.x

 

 

Articles

Suggest a new Article!