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…
Implementing low latency SQL data synch into Elasticsearch Elasticsearch is a powerful text search engine that provides many features not found in typical SQL databases.…
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…