Recent Articles

SQL Server Streaming: Easy Way To Stream Data In Real-Time

June 30th, 2020 By Ofem Eteng in Data Engineering, Data Streaming

This article introduces the concepts of streaming data, its benefits, and its applications. Streaming data is beneficial in scenarios where new dynamic data is generated continually. Hence, real-time streaming applications…

Oracle Standby Redo Logs vs Online Redo Logs: Comprehensive Analysis

June 29th, 2020 By Vivek Sinha in Data Strategy, Versus

Do you want to learn about Oracle standby redo logs and online redo logs? If yes, then you are in the right place. Oracle is a very popular relational database…

Salesforce Database Integration: 4 Easy Methods

June 26th, 2020 By Muskan Kesharwani, Rashid Y in Data Integration

Key Takeaways There are four straightforward approaches for Salesforce database integration, each suited for different business needs:  Use Hevo Data (No-Code Pipeline) if you want a super-easy way to connect…

Kafka CDC SQL Server: A Detailed Guide

June 26th, 2020 By Talha in Change Data Capture CDC

The change data capture functionality was introduced in SQL Server 2016 SP1. This feature allows SQL Server users to monitor databases and tables and store the changes committed into specifically…

Salesforce Export Data to Data Warehouse: 2 Best Methods

June 25th, 2020 By Talha in Data Strategy, Sales Operations

Data integration is essential to performing a holistic analysis. It is thus important to be able to move your data from different applications to a central repository. Salesforce is a…

Step By Step Guide to Connect Salesforce to S3

June 24th, 2020 By Aman Sharma in Data Integration

With the growing data generation, businesses must leverage a platform that helps them make good use of their customer data, and Salesforce is one such CRM platform. By moving this…

AWS RDS SQL Server Replication: 2 Easy Steps

June 23rd, 2020 By Vishal Agrawal in AWS, Data Replication, SQL Server, Tutorials

With the introduction of Cloud technologies, the demand to Replicate the on-premises data to Cloud technologies has increased. AWS, an abbreviated term for Amazon Web Services, is the world's leading…

Oracle SQLPlus Export To CSV Data: A Comprehensive Guide

June 23rd, 2020 By Monica Patel, Vishal Agrawal in Data Integration

Key Takeaways To export data from Oracle SQLPlus to CSV, you can utilize the SPOOL command: Step 1: Configure SQL*Plus SettingsSet the necessary parameters to format the output correctly. Step…

How to Automate Salesforce Data Export: Step-by-Step Explanation

June 22nd, 2020 By Vivek Sinha in Data Strategy

Key Takeaways Automating Salesforce data export is essential for seamless data integration, backups, and analytics across your business systems. Method 1: Hevo Data Automated Export  Best for organizations seeking a…

Postgres WAL Replication: Easy Step-By-Step Guide

June 22nd, 2020 By Nicholas Samuel in Data Replication, PostgreSQL, Tutorials

Data replication ensures the duplication of data on an ongoing basis so that the replicate is in a consistently updated state and is synchronized with the source. This ensures high…

Postgres Replication Types: Key Concepts & Features Explained

June 22nd, 2020 By Ofem Eteng in Data Replication, PostgreSQL, Tutorials

The advent of the internet coincided with the rise of distributed systems. More services now have to support a massive number of users. For many such services, it is no…

Understanding Postgres WAL: What It is and How It Works

June 20th, 2020 By Nikhil Annadanam in Database Management System, PostgreSQL

Write-Ahead Log (WAL) is a very important term in transaction processing. In PostgreSQL, it is also known as a transaction log. A log is a record of all the events…

Achieving PostgreSQL Master Slave Replication: 7 Easy Steps

June 20th, 2020 By Nikhil Annadanam in Database Management System, PostgreSQL

PostgreSQL is an extremely robust open-source database used by noted players like Skype, Reddit, Instagram, and OpenStreetMap. As the traffic on websites and applications increases the frequency of reading and…

expdp: Export Data From Oracle Instantly

June 19th, 2020 By Oshi Varma in Data Strategy

Are you looking for an easy way to export your data from Oracle? If yes, then you are in the right place. This blog focuses on exporting a complete database,…

Using MySQL BinLogs: A Detailed Guide

June 19th, 2020 By Nicholas Samuel in Database Management System, MySQL

The availability of data is a crucial aspect of every business or organization. Organizations practice various methods to ensure that data is available for replication & recovery. MySQL BinLogs play…

Mastering MySQL Workbench Database Dumps: A Comprehensive Guide

June 19th, 2020 By Shruti Garg in Database Management System

Do you want to backup your MySQL database? Are you not familiar with SQL queries? Don’t worry, we have you covered. This guide will take you through the steps of…

Exporting MongoDB to JSON: 3 Simple Methods for Your Data

June 17th, 2020 By Divij Chawla, Sarthak Bhardwaj in Data Integration, MongoDB

Key Takeaways Here are three effective methods to export MongoDB data to JSON format: Method 1: Using mongoexport CommandUtilize the mongoexport command-line tool to export data from a MongoDB collection…

Data Export MySQL Workbench: 2 Easy Methods

June 17th, 2020 By Vishal Agrawal in Database Management System, MySQL

When I first needed to perform a data export MySQL Workbench task, I honestly expected it to be straightforward. But instead, I ran into unclear settings, confusing formats, and export…

Mastering Kafka CDC Postgres: Step-by-Step Explanation

June 17th, 2020 By Nicholas Samuel in Change Data Capture CDC

Nowadays, the use of CDC (Change Data Capture) in applications is a MUST.  Of course, you don’t want to hear that the changes that you made to the database were…

Connecting CleverTap To PostgreSQL: 2 Easy Methods

June 16th, 2020 By Sai Surya in Data Integration, PostgreSQL

CleverTap is the only platform that uses AI (Artificial Intelligence) and ML (Machine Learning) to personalize customer experience using real-time behavioral and pattern data. These precise predictive models result in…