In an increasingly technological and digitized world, interoperability is a must for business processes to work. The myth of the Tower of Babel already predicted the importance of interoperability and can be taken today as an example of why interoperability is essential.
Big Data has transformed the way data is managed and stored, creating new demands for traditional data storage processes. Over time, requirements for higher volume and velocity have transformed ETL processes towards a new perspective: ELT.
Most companies already run their data assets through ETL processes and increasingly these processes are moving to cloud environments. Nevertheless, before committing to an ETL cloud service, there are certain considerations we should take into account.
While ETL is still a primary process in business, in recent years a new trend has emerged: ELT. In this article we go through the differences between the two and try to decipher which is the best option according to your data assets and what you want to do with them.
Data warehouse automation is a next-generation technology that relies on advanced design patterns and processes to automate the planning, modeling, and integration steps of the entire data warehouse lifecycle. Automation provides an efficient alternative to traditional data warehouse design because it reduces[...]
If you're here, you probably have already heard about the ETL process - if not, we explain what ETL is here - and you probably know that it's essential so that companies can have control over their data, make better decisions and optimize their business intelligence strategies. If you're thinking about implementing an[...]
Nowadays there are many well-known data processing processes, tools and platforms. Even so, from time to time it is important to remember the basics: let's talk about ETL and SSIS.