Best Practice

Resource Articles

Real-time Data Analytics: The Ultimate Guide

In this article, we’ll introduce the concept and types of real-time data analytics, a detailed breakdown of the advantages and benefits of real-time data analytics, and real-life examples of how it benefits different industries. Finally, we review the challenges and limitations to watch out for during the implementation.

Luke Smith
March 20, 2023

PostgreSQL Streaming Replication: 2 Easy ways

In this blog, we’ll walk you through step-by-step how to set up PostgreSQL streaming replication with no-code platform Arcion and use PostgreSQL built-in replication for streaming.

Matt Tanner
December 20, 2022

Data Lakehouse: Everything You Need To Know

Data Lakehouse is a new data solution concept that combines elements of a data warehouse with those of a data lake. In this post, we’ll walk you through what is a Data Lakehouse, its benefits, the technology behind it, and how to use CDC to move data into a Data Lakehouse.

Matt Tanner
December 2, 2022

What Is Streaming SQL? The Definitive Guide

Streaming SQL is a fundamental component of any modern data architecture as many companies now rely on their ever-increasing data production to make data-driven decisions not minding where the data resides.

Matt Tanner
November 11, 2022

Building Data Pipelines - Ultimate Guide

A data pipeline is a series of data processing steps that involve the movement of data from one place, usually the source to a destination. In this blog, we’ll walk you through what is a data pipeline, the elements of a data pipeline, how to design a data pipeline, and the important factors for sustainable data pipelines.

Matt Tanner
November 11, 2022

What Is Data Ingestion? A Complete Guide

Data ingestion can be defined as the process of moving data from one or more sources into a target site for immediate use such as queries and analysis or storage. The data sources may include IoT devices, data lakes, databases, on-premise databases, SaaS applications, and so on from which data is ingested into data warehouses, data marts, or document stores.

Matt Tanner
November 4, 2022

What Is A Data Pipeline? Guide With Examples

A data pipeline is a combination of data processing steps used to move data from a source to a destination also known as a sink. In this guide, we’ll show you the difference between data pipelines and ETL, the elements of a data pipeline, different types of data pipelines, data pipeline architecture examples and more.

Matt Tanner
November 4, 2022

A Complete Guide on Database Replication

Database replication is the process of copying data from a source database to one or more target databases. Learn everything you need to know in this complete guide.

Matt Tanner
October 19, 2022

8 Best CDC Tools of 2023

CDC, or Change Data Capture, is a technology that efficiently identifies data that has been added, updated, or removed from a source database and replicates it on a target database or platform. In this definitive guide, we’ll walk you through the latest CDC solutions available in 2023 and approaches to help you choose the best one that works for your use case.

Top 10 Oracle GoldenGate Alternatives

The ten alternatives to Oracle GoldeGate that will be covered are Arcion, Qlik Replicate, Fivetran, Debezium, Striim, Hevo Data, Talend Data Integration, SharePlex, Informatica PowerCenter & InfoSphere.

Data Migration Plan: 7 Steps To Follow

When deciding on what to include in your data migration plan, you have to bear in mind that there is no one-size-fits-all strategy, as every data set might be unique. In this blog, we listed 7 steps for you to follow to help you navigate any complicated data migration projects.

A Step-By-Step Guide on How to Conduct On-Premise to Cloud Migration

Considering an on-premise to cloud migration? Be sure to read our guide that covers everything from benefits to the business and a how-to guide.

Top Considerations When Planning to Migrate Databases to Cloud

Planning to migrate your on-premise databases to the cloud? Don't start until you read our comprehensive guide detailing how to plan and what to consider at every step in the process.

Sign up for the Arcion newsletter

Join the waitlist for Arcion Cloud (beta)

Fully managed, in the cloud.