Best Practice

Resource Articles

Postgres To Oracle: Load Data In Minutes

This article looked at two popular and powerful database management systems - PostgreSQL and Oracle Database. You were also shown their key features and what makes them stand out amongst database systems. We also explored two approaches for migrating data from Postgres to Oracle.

August 29, 2023

Informix to MySQL: 2 Easy Ways

Looking to migrate from Informix to MySQL? Discover the seamless and efficient transition with our expert guide. Get step-by-step instructions, best practices, and key considerations for a successful migration.

Matt Tanner
August 25, 2023

AWS RDS To Snowflake: Load data In Minutes With 2 Easy Methods

Discover how to seamlessly migrate your data from AWS RDS to Snowflake with our comprehensive guide. Maximize the power and flexibility of Snowflake's data warehousing capabilities while leveraging the benefits of AWS RDS.

Luke Smith
July 14, 2023

How To Load Data From MySQL To BigQuery

This step-by-step blog is going to explore two methods that can be used to move data from MySQL to BigQuery: using Arcion log-based CDC solution vs. manual transfer, both comes with code snippet that you can copy and paste. We'll also go over the pros and cons of both approaches.

Matt Tanner
July 6, 2023

How To Load Data From Postgres To Snowflake

In this blog, we’ll give you a step-by-step process showing how to load data from Postgres to Snowflake using Arcion with Change Data Capture.

Luke Smith
June 20, 2023

Oracle to Databricks: The Definitive Guide

Looking to migrate your data from Oracle to Databricks? Discover the benefits of making the switch and learn how to transfer your data with expert tips and guidance seamlessly.

Matt Tanner
April 28, 2023

Real-Time Data Integration: The Definitive Guide

In this blog, we'll dive into what is real-time data integration, why it's important, and three integration processes: capture data, transform data, and load data. We'll also go over the components needed for a real-time data integration architecture.

Luke Smith
March 31, 2023

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

6 Best Snowflake ETL Tools For 2023

As Snowflake continues to rise in popularity, the demand for efficient ETL capabilities within the platform follows suit. This comprehensive review covers six top-tier ETL tools for Snowflake integration, with their advantages and limitations.

What is Data Streaming? The Complete Guide

Streaming data, as the name suggests, refers to data that is continuously generated from various sources and flows like a stream to various destinations. This data is often generated at a high speed and in large volumes.

Postgres To Kafka: Load Data In Minutes With 2 Easy Methods

Learn how to efficiently integrate and stream data from Postgres to Kafka using our expert guidance. Harness the power of Kafka's distributed messaging system to enable real-time data processing and analytics.

Microsoft SQL Server to BigQuery: 2 Best Ways

Looking to migrate from SQL Server to BigQuery? Discover the seamless and efficient transition with our expert guide. Get step-by-step instructions, best practices, and key considerations for a successful migration.

Real-time Data Ingestion: The Ultimate Guide

In this blog, we’ll dive into what real-time ingestion is, along with its benefits and limitations. We’ll also feature 12 data ingestion tools to help you with your evaluation process.

Real-time Big Data Analytics: The Complete Guide

Real-time big data analytics is a modern technology that can be described as a process used for the analysis of large volumes of data the moment they are created or stored. In this blog, we'll walk you through what are the technologies used in big data analytics, its advantages and limitations, and a few processing examples.

Real time data streaming: The Ultimate Guide

Real-time data typically refers to data that is readily available from a source system or process for follow-up actions to be performed on it at that given time usually in the realms of sub-milliseconds. In this post, we’ll go over data streaming vs. ETL, why we need it, and its benefits, challenges, and limitations.

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.