Databases

6 Articles in this category

Print
Share
Dark
Light

Databases

6 Articles in this category

Share
Dark
Light

Databases Overview

Overview Rivery enables migrating data from legacy and cloud databases to one of the DWHs we support. Our database connectors are built with correctness, safety, and security in mind. The term "correctness" refers to the fact that your destination...

Database Connectivity Options

Introduction This guide provides an overview of the available database connection methods, detailing their respective advantages, limitations, compatibility with Rivery, best practices, and links to in-depth documentation. Selecting the Optimal ...

Database River Modes

Introduction Rivery offers multiple database River modes to meet the needs of different use cases. Each River mode has its own advantages, and the choice of a River mode depends on the nature of the source data and the requirements of the target d...

Automatic Schema Drift Management

Introduction Schema drift refers to the gradual changes in the structure of data in a Source over time. These changes can have a significant impact on the integrity, and accuracy of data being replicated to a destination Target, such as a data war...

Database Table Configuration Options

Introduction This document provides a comprehensive walkthrough of the configuration options in Relational Database Management Systems (RDBMS). These options enable users to manage various settings within different extraction River modes, includin...

CDC 'Point in Time' Position

Introduction Within the this document, we will explore the mechanics of Change Data Capture (CDC), a system designed for monitoring of source database logs and the meticulous capture of any modifications made to the source data. Furthermore, we wi...

BigQuery

Introduction BigQuery is a fully managed, serverless data warehouse provided by Google Cloud Platform that enables super-fast SQL-like queries using the processing power of Google's infrastructure. Using BigQuery as a source in Rivery means yo...

Datastore

Introduction Datastore is a scalable NoSQL database designed for your applications. It seamlessly manages sharding and replication, ensuring you have a robust and resilient database that effortlessly adapts to accommodate your application's dema...

ElasticSearch

Introduction Elasticsearch is a distributed, RESTful search and analytics engine that can handle a wide range of scenarios. As the heart of the Elastic Stack, it saves your data centrally for lightning-fast search, fine-tuned relevancy, and scal...

MariaDB

Introduction MariaDB stands as a powerful open-source relational database management system (RDBMS). This document acts as your guide for seamlessly integrating MariaDB with Rivery, which in turn enhances your abilities in data management and de...

Microsoft SQL Server

Introduction SQL Server is a relational database management system created by Microsoft. Serving as a database server, it functions as software designed primarily to store and retrieve data upon request from various software applications. Micro...

MongoDB

Introduction MongoDB is a NoSQL database system to create a dynamic data management solution. In this document, we'll delve into MongoDB's core concepts and explore how Rivery seamlessly complements it, enabling businesses to efficiently manage,...

MySQL

Introduction MySQL is a popular open-source relational database management system (RDBMS) that is widely used for managing and storing data in various applications and websites. MySQL is known for its reliability, scalability, and performance, mak...

Oracle

Introduction Oracle is a relational database management system (RDBMS), that holds a significant presence in the data management landscape. Recognized for its robustness, scalability, and performance. his comprehensive guide is designed to empow...

PostgreSQL

Introduction PostgreSQL is a powerful relational database management system (RDBMS). PostgreSQL supports advanced data types, and offers extensive features for data integrity and performance optimization. Its versatility and adherence to standar...

Snowflake as a Source

Introduction Snowflake as a Source is Currently in Beta stage . Snowflake as a Source is a cloud-based data warehouse known for its high performance, scalability, and separation of storage and compute. Using Sno...

Teradata

Introduction Teradata on Rivery brings together the strengths of Teradata's data warehousing technology with Rivery's data integration and orchestration. This integration enables seamless loading, transformation, and analysis of data from diver...

Vertica

Introduction Vertica on Rivery combines the advanced analytics capabilities of Vertica's data warehouse with the data integration and orchestration capabilities of Rivery's platform. This integration allows users to efficiently load, transform,...