Author name: Sharon Reaves

Up until recently, the decision of whether to transform data before or while loading it into a data warehouse was simple. If your main concern was data staging and processing, you went with ETL (extract, transform, load). If your organization prioritized data accessibility and storage, you chose ELT (extract, load, transform) you opted for an

De-Silo Your Data Organization 90% of the world’s data has been produced within the past two years. For businesses, this data is scattered across departments and different types of storage facilities, including data lakes and data warehouses. Business leaders must collect this data into a centralized location, where the information can be used for analysis

There’s no question that Service-Oriented Architecture (SOA) changed the paradigm of software design and data integration when the term was first coined. With SOA, architecture in software services became less monolithic, allowing for service sharing in a more interoperable environment, while each component worked independently. Yet SOA as an idea first emerged in the 20th-century—what

In modern software development, application integrations are king. Your data can do so much more when you leverage the power of other pre-built enterprise apps. That’s why K3 ETL connects to dozens of applications. Moreover, if you’re using a legacy application not listed below, K3 can build a new connector within 48 hours. Just get

When it comes to data management, open source and highly-scalable databases take the cake, particularly when using K3 data integration solutions. Among the most popular of these databases is MongoDB, which is perhaps the most famous of the NoSQL databases, allowing you to store and process structured and semi-structured data with ease. What is the

The world of data management has evolved greatly since the first MySQL relational database debuted in 1995. Back then, cutting-edge tools like K3 ETL were not yet available, and many once-popular database tools and legacy architectures have vanished. Yet MySQL isn’t just still around—it is, in fact, one of the world’s most popular database management

The world of data management has advanced considerably in the past few years. On-site data storage is rapidly giving way to cloud solutions like Redshift and Snowflake, enabling not only more effective data movement, but entire new possibilities for optimizing operations. Data orchestration describes the process of connecting data across an increasingly complex ecosystem, building

Data Warehouse ETL is a series of processes: Extract data from across an organization; Transform data for consumption; Load data to a relational or non-relational data store;    Use this data to facilitate business intelligence, reporting, analytics, data science, and other activities. Let’s Unpack This: Any time one moves data there is an exceptionally high probability

As companies look towards data science and its future, the focus is increasingly on big data use cases. Even small to mid-sized companies generate massive amounts of data compared to just a few years ago, highlighting the importance of being data smart: using data science to transform information into insight. Broadpeak Partners helps companies improve

Will the Real Gamestop Please Stand Up True story.   My college friend Ed. Maybe I shouldn’t use his real name….meh, his name is Ed. Anyway, back in the day Ed was a floor  trader on one of the Chicago exchanges. A far cry from today’s electronic marketplace. These were the days traders stood in pits

When it comes to enterprise data transformation, businesses have a number of options for cloud-based data management services. One provider, Matillion, has offered ETL and data warehousing tools since 2011—yet how do their services stack up when compared to K3 ETL? Let’s take a deeper dive into the similarities and differences between these two platforms