Replicate data to Amazon Elastic Compute Cloud (EC2) with SharePlex

[MUSIC PLAYING] Welcome to one of a series of SharePlex videos to introduce you to how SharePlex can help replicate data to the cloud. This video focuses on Amazon Elastic Compute Cloud EC2 cloud service. Why would you consider Amazon EC2 to as your cloud service? Amazon EC2 to is an infrastructure cloud service that allows you to rapidly and easily provision the instances you need to host your relational databases in a secure network environment in the cloud. You can scale the environment accordingly to meet your business needs. Once you have your relational databases set up an Amazon EC2, how can you migrate or replicate your tables and data from your on-prem databases to the cloud? SharePlex can help you accomplish these tasks. SharePlex is a near real time data replication and data integration solution that provides high speed, log based replication from databases like Oracle to different database targets, either on premise or in the cloud. Installing, configuring, and activating replication with SharePlex requires no bouncing of the databases, nor the servers, which means SharePlex can migrate your databases to the cloud with zero downtime. Data can be moved to an instance in the cloud without interrupting user access to the on-prem databases. SharePlex can then reconcile the data moved to the cloud with the activities that have happened in the on-prem database, thus there is no downtime to move the databases to the cloud. SharePlex supports a variety of topology configurations and heterogeneous database environments, which helps organizations achieve three core IT initiatives-- availability, scalability, and near real time data integration. For databases on-prem, or in the cloud, replicating to databases on Amazon EC2, all use cases are supported. High availability/ disaster recovery. Maintain a synchronized copy of your production database in a different location for high availability or disaster recovery. Migrations. Eliminate the downtime required to copy the data from the current database to the new system, which allows the users to continue working in the production database. Active-active load balancing. Balance your workload between multiple identical copies of your database. Updates from one database are visible to all databases in near real time. Offload reporting and archiving. All or a subset of data from your production database can be kept synchronized in a separate instance, thus, near real time reporting or other batch processes can be accomplished in a separate instance. Data distribution. Distribute data from a single source to multiple targets. Cascade replicates data from the source system to an intermediary system. And then, from the intermediary system to one or more remote target systems that do not have direct network connections to the source. Data integration allows real time data integration from Oracle, to SQL Server, to PostgresSQL. Change history. Where change history tables will maintain all the information about every change to the database. Consolidation. Consolidate data from multiple sources to a single target. The SharePlex architecture allows for flexibility for almost all business requirements. SharePlex is used in over 32,000 installations and has been exposed to just about all configurations, applications, and networks. The series of queues and processes that make up a SharePlex replication stream are designed to replicate transactions with minimal time and use minimal resources, yet maintain integrity and synchronize data. No matter what environmental issue may cause a break in the replication stream, such as network down or target database down, no data will be lost. Rather, it will be queued on disk until the environment issue is resolved, at which time data will automatically be synchronize. Data integrity checks for every transaction, constantly, to synchronize data. SharePlex's compare, repair utility can be used to resynchronize data. On the source system, the capture process reads the Oracle redo logs and, if necessary, the archive logs, then makes a copy of the data, target data, and sends it to the capture queue. The read process reads the capture queue, prepares the data for transport across the network, and places the data in the export queue. The export process transports the replicated data across the network to the target system. On the target system, the import process receives the data and writes it to the post queue. The post-process takes the data, constructs a SQL statement, and applies it to the target tables within the target database. The following links show you where to download the 30 day trial, get SharePlex product support, and get free SharePlex web-based training. To begin using SharePlex, you can download a 30 day trial copy by visiting quest.com/trials, or contact your sales representative for pricing information. You can get additional SharePlex product information from the support site, such as how to get started, install and upgrade, video tutorials, knowledge articles, and much more. There are also free SharePlex web-based technical training on Toad World to help you learn how to configure, optimize, and troubleshoot your SharePlex environments. Thank you for watching this video. [MUSIC PLAYING]