Tag Archives: Data Integration

Use Case: Load Elasticsearch ETL from SQL

Posted on May 12, 2019 by Fred Zimmerman

Low latency multi-table SQL data is pulled and merged into a hierarchical Json document into Elasticsearch There is a strong need for SQL style database to off load text searches onto a search engine like Elasticsearch. With non-trivial data models … Continue reading →

Posted in Elasticsearch, Elasticsearch ETL, Json ETL | Tagged , , , | Leave a comment

Top 15 reasons to use a Json ETL tool

Posted on April 14, 2018 by Fred Zimmerman

Advantages of using declarative json ETL software Intelligent Integration is a powerful enterprise declarative ETL tool based on internal Json documents. Intelligent Integration can read or write to nearly any datasource including SQL, NoSQL , flat files or REST. When … Continue reading →

Posted in Elasticsearch ETL, Hadoop ETL, Json ETL, Mongo ETL, NoSQL ETL | Tagged , , | 2 Comments

Use Case: Automatic ETL schema generation

Posted on May 13, 2017 by Fred Zimmerman

Semistructured source data with automatic ETL schema generation at SQL destination Problem: A Software as a Service (SaaS) company stores OLTP data in a mixed format of relational and semi-structured data. This multi-tenant data consists of workflow, form data and documents. … Continue reading →

Posted in Data Warehouse ETL, Hadoop ETL, Json ETL | Tagged , , , | Leave a comment