At the heart of data integration is the ETLÂ (extract, transform, load) process...
At the heart of data integration is the ETL (extract, transform, load) process. Data integration begins with extracting data from various sources and moving it into a single data warehouse. (For companies and organizations who do not use a data warehouse, the process is similar, although the data will be integrated directly into the source.) In order to facilitate the integration process, Salesforce features a range of interface points including REST, SOAP, and BULK API. These interfaces connect with and extract large volumes of data at a time.
During the transformation stage, data is cleansed, validated, de-duplicated, organized, and standardized. At this point, all of the various sets of data are now in conversation with each other. Finally, the newly-converted data is loaded (or delivered) to its final destination.
At the heart of data integration is the ETL (extract, transform, load) process. Data integration begins with extracting data from various sources and moving it into a single data warehouse. (For companies and organizations who do not use a data warehouse, the process is similar, although the data will be integrated directly into the source.) In order to facilitate the integration process, Salesforce features a range of interface points including REST, SOAP, and BULK API. These interfaces connect with and extract large volumes of data at a time.
During the transformation stage, data is cleansed, validated, de-duplicated, organized, and standardized. At this point, all of the various sets of data are now in conversation with each other. Finally, the newly-converted data is loaded (or delivered) to its final destination.