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 […]