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 […]
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 […]
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 […]
Data Warehouse ETL vs Data Lake ETL JsonEDI makes a fundamental change of the cost calculus between a Data Lake vs the IDW. A Data Lake is loosely integrated data typically placed in Hadoop. An IDW has tightly integrated data stored in either a relational database and/or Hadoop. Without JsonEDI, data warehouse ETL LOE is […]