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[...]
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.