Once I was getting ready for the Salesforce Information Cloud certification, I got here throughout the time period Zero-ETL. The Information Cloud presents the chance to entry information immediately from different techniques akin to information warehouses or information lakes or sharing information with these techniques with out the info being copied. Salesforce describes this additionally as Convey Your Personal Lake (BYOL), referring to the time period Convey Your Personal System (BYOD). I wished to raised perceive the idea of Zero-ETL and illustrate it in an comprehensible approach.
On this article, I’ll present you how one can create a simplified ETL course of with Python to raised perceive this idea, what Zero-ETL or Zero-Copy means and the way this new method to information integration is carried out within the Salesforce Information Cloud.
Desk of Content material
1) Conventional ETL course of: Step-by-step information with Python for Rookies
2) So what’s Zero-ETL?
3) Why Zero-ETL? Benefits and Disadvantages
4) What does Zero-ETL appear to be within the Salesforce Information Cloud?
5) Remaining Ideas
In case you are already accustomed to the ETL and ELT processes, you may skip this part. In case you are new to this subject, check out the tremendous simplified instance to raised perceive the Extract — Remodel — Load course of. And even higher, construct it your self — by making use of it, you’ll often perceive the ideas higher.
