Tag: ELT

Article Image
September 07, 2021

Crossing the Firewall: Connecting Cloud, Hybrid Cloud, & On-Premises Data

by Haley Burton

Crossing the Firewall: Connecting Cloud, Hybrid Cloud, On-Premises Data While there are many reasons for cloud migration, most organizations migrating to the cloud continue to retain some of their existing on-premises applications and data, adopting a hybrid approach. In fact, according to...

read more

Article Image
July 22, 2021

Reverse ETL with Salesforce and SQL Server

by Haley Burton

As data usage grows many organizations turn to data warehousing in order to consolidate data for analytics, reporting, governance and decision support. Modern warehousing solutions are flexible, faster, more scalable, and more economical than ever before. But data warehousing is not witho...

read more

Article Image
July 06, 2021

ETL vs. ELT: Which is Right for Your Data Warehouse?

by Alex Pauncz

To bring their diffuse data into their data warehouse, organizations typically leverage an ETL or ELT process using a dedicated data pipeline. In this article, we define and compare ETL and ELT processes to help you determine which is right in various data integration scenarios. What are ...

read more

Article Image
June 08, 2021

World of Data Series Part 3: Analyzing and Actioning Data

by Haley Burton

Access to accurate data is only one part of the equation to making that data actionable. Only when analytics is at the forefront of your strategy will you be able to drive business outcomes using your data The ability to make sense of the data you have on hand and turn it into actionable ...

read more

Article Image
May 28, 2021

Connecting Salesforce to your Snowflake Data Warehouse

by Alex Pauncz

Salesforce is one of the world s most popular cloud-based platforms for business. For many organizations, Salesforce acts as a central hub for all customer data and customer-centric processes. As core infrastructure, the data stored within Salesforce must often be combined with other inte...

read more

Article Image
May 25, 2021

How to Evaluate the Best ETL Tools for Your Business

by Haley Burton

Data-driven organizations typically base their analytics stack on a data warehouse that hosts data replicated from various sources. To support data warehousing, organizations need efficient tools to consolidate data. Data pipelines optimize data movement from various applications and data...

read more

Article Image
May 19, 2021

World of Data Series Part 2: 4 Steps to Better Manage Your Business Data

by Haley Burton

Ensuring a balanced flow of data between business applications, sources, and warehouses is critical to delivering value from data resources . Gathering, managing, integrating, and analyzing your unique business data needs to become a core competency for your organization. It's important t...

read more

Article Image
May 10, 2021

World of Data Series Part 1: Managing Your Digital Data Growth

by Haley Burton

By 2025, IDC predicts that worldwide data will grow 61 percent to 175 zettabytes, with much of the data residing in the cloud in data centers. Maybe your organization does not need access to that much data, but the larger point is this: there is a lot of data out there in the digital univ...

read more