Show Transcript
Hide Transcript
[MUSIC PLAYING] Welcome to one of a series of SharePlex videos to introduce you to how SharePlex can help replicate data into the cloud. This video focuses on real-time replication from on-prem to databases in Azure.
Why would you consider Microsoft Azure as your cloud service? Azure 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 in Azure, 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 balancing 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 databases, thus, there is no downtime to move the databases to the cloud. SharePlex supports different cloud services. For Azure environments, SharePlex supports replicating from Oracle to Oracle, SQL Server, and other databases listed on target. In addition, SharePlex comes with an unrivaled, mission-critical, and highly rated, 24/7, 365 support that has earned multiple industry awards.
SharePlex supports a variety of topology configurations in heterogeneous database environments, which helps organizations achieve three core IT initiatives-- availability, scalability, and near real-time data integration. For databases on-prem replicating to databases on Azure, the following use cases are supported-- 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.
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 on a separate instance. Data distribution. Distribute data from a single source to multiple targets. Data Integration allows real time data integration from Oracle to SQL Server to PostgreSQL. Change history-- where change history tables will maintain auditing 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 at 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 synchronized. Data integrity checks for every transaction constantly to synchronize data. SharePlex's Compare or Repair utility can be used to re-synchronize 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 an 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]