July 9, 2020 What is the Difference Between ETL and IPaaS? ETL (extract, transfer, and load) and IPaaS (Integration Platform as a Service) are data integration methods to connect different IT systems and data sources together. While ETL is a set of techniques for moving data, IPaaS is a more holistic set of capabilities for moving and integrating data between IT systems. IPaaS is often… Read More
August 22, 2019 If ETL Is Integration Hell, How Do I Avoid It and Go to Heaven? Extract, Transform, and Load (ETL) is the process that has been used to share data between applications, transactional systems, and data warehouses for decades. It essentially works like this; you define an integration, pull the data out of the source system, use some mapping and aggregation rules to transform the data into the format… Read More
November 26, 2018 What’s new in Actian DataFlow version 6.6.1? Actian DataFlow is a parallel workflow platform for end-to-end data access, transformation, preparation, and predictive analysis that eliminates performance bottlenecks in your data-intensive applications. Complementary to the Actian Vector analytic database, DataFlow leverages concurrency, parallelism and pipelining to accelerate data movement between locations in your data architecture, creating faster results. DataFlow eliminates memory constraints,… Read More
May 18, 2020 SQLite Equals ETL Heavy Two weeks ago, I likened the performance of SQLite to that of a Banana Slug. Now, some may consider that a bit of hyperbole (and some UC Santa Cruz alumni may feel that I impugned the good name of their mascot, which was not my intent) but the numbers don’t lie. The measurable difference… Read More
