Top 15 reasons to use a Json ETL tool

Advantages of using declarative json ETL software JsonEDI is a powerful enterprise declarative ETL tool based on internal Json documents. JsonEDI can read or write to nearly any datasource including SQL, NoSQL , flat files or REST. When reading from non-Json sources, JsonEDI immediately converts the data into Json for processing. Being a declarative programming […]

Use Case: Automatic ETL schema generation

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. The company must export the data for their clients in a tabular form by pivoting […]

Use Case: Load Elasticsearch ETL from SQL

Multi-table SQL data merged into hierarchical Json document using Elasticsearch ETL Nearly all OLTP centric database vendors (both SQL or NoSQL) struggle with text search. While text search engines (like Elasticsearch) are problematic with maintaining ACID transactions required of OLTP. So many business have a need to maintain separate data stores of OLTP from text […]