With 25 years plus experience as a Data Architect in both Fortune 500 and start up business I’ve seen a lot of pain points of…
ETL MongoDB to Oracle, SQL Server, MySQL & Postgres Note: This article is a work in progress. MongoDB is a Json based NoSQL database that…
Problems: ETL of Boarding Loans ETL of loan boarding is a complex data integration process that is a significant pain point for the mortgage servicing…
With 25 years plus experience as a Data Architect in both Fortune 500 and start up business I’ve seen a lot of pain points of…
By Jared DeckerExpertAnalytics.com To accommodate the massive influx and wide variety of data that organizations are capturing and storing for analytical and strategic value, approaches…
By Jared DeckerExpertAnalytics.com We often come across people that self-identify as fitting into one of two categories: visual people or numbers people. This discussion often comes…
Low latency, complex data model SQL data synchronization with Elasticsearch Elasticsearch (ES) is a NoSQL databases optimized for the fuzzy logic of text search. SQL…
Legacy ETL solutions are a procedural programming exercise. An ETL process starts with a source query pulling data, then through some workflow steps the data…
Mongo, Redis, Elasticsearch or Couch Legacy ETL tools are problematic for NoSQL databases. They assume tabular data and are not well suited for hierarchical Json…
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…