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 to the cloud. This video focuses on real-time replication to Azure SQL data service.
Why would you consider Microsoft SQL Azure as your cloud service? SQL Azure is a software cloud service that allows you to rapidly and easily provision the SQL Azure databases you need in a secure network environment in Azure cloud. You can scale the environment accordingly to meet your business needs. Once you have your SQL Azure databases set up, 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 books 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 SQL Azure environments, SharePlex supports replicating from Oracle to SQL Server on target. In addition, SharePlex comes with 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 initiatives-- availability, scalability, and near real-time data integration.
For databases on-prem replicating to SQL Azure databases, the fallen 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 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 in synchronized 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 Repair utility can be used to resynchronize data. For replication to a SQL Azure database in the cloud, all SharePlex process is run on the Oracle source database server, where on the source system, the capture process picks up the transaction from the Redo log and sends it to the Capture queue. The read process then prepares the data for transport to the Post queue.
The post process takes the data, constructs a SQL statement, and users SQL NET to send a record to the SQL Azure database in the cloud. On the target system, SQL Azure applies the data to the target table.
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 courses on Toad World to help you learn how to configure, optimize, and troubleshoot your SharePlex environments. Thank you for watching this video.
[MUSIC PLAYING]