[MUSIC PLAYING] Welcome to one of a series of SharePlex videos that introduce you to how SharePlex can help replicate data to the cloud. This video focuses on Amazon Relational Database Service-- RDS-- cloud service. Why would you consider Amazon RDS as your cloud service? Amazon RDS is a platform cloud service that allows you to rapidly and easily provision the relational database you want 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 Amazon RDS, how can you migrate or replicate your tables and data from your own 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, long based replication from databases like Oracle to different database targets, either on-prem or in the cloud. Installing, configuring, and activating replication with SharePlex requires no bouncing off 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 different cloud services. For Amazon RDS environments, SharePlex, which can only be on source, supports replicating from Oracle on-prem to Oracle, Server, and PostgresSQL on RDS 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 and heterogeneous database environments, which helps organizations achieve three core initiatives-- availability, scalability, and near real time data integration. For an on-prem to RDS cloud replication environment, which RDS can only be the target, 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. Or consolidation. Consolidate data from multiple sources to a single target. Data integration allows real time data integration from Oracle, to SQL Server, to PostgresSQL. And lastly, change history, where change history tables will maintain auditing information about every change to the database.
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 the 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.
For replication to an Amazon RDS cloud service, all SharePlex processes run on the Oracle source database server. Where, on the source system, the capture process picks up the transactions 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 uses SQL*Net to send the record to the RDS database in the cloud. On the target system, RDS applies the data to the target table.
Next is a demo to show how SharePlex replicates tables and data from an on-prem Oracle database to an Oracle database on Amazon RDS cloud service.
For this demo, we have an Oracle 11gR2 database instance on Amazon RDS cloud service. As you can see, the configuration details shows the database information, such as database name, host name, and port number. In our on-prem environment, we have an Oracle 11gR2 database and SharePlex already installed. There is a config file set up, called rdstarget, which provides SharePlex with the information to replicate from the on-prem Oracle 11gR2 database on this server, to the RDS target database, replicating splexdemo schema on source to splexdemo schema on target. You can also just specify a specific table instead of the entire schema. Once we have everything set up and have activated the config file, we are ready to begin the replication process.
First, we will create a table called demo_target on source to replicate the target. Switching over to target, you can see comparing with the result above, the table is now created. Now we will replicate data. Going back to "source", we will insert a row of data into the demo_target table and commit. On RDS target, selecting from the demo_target table, shows the new inserted record. We could also truncate the data from the demo_target table on source and it will truncate the table on target.
Back on RDS target, selecting from the table shows no data. Replication completed successfully. We can also add or remove a column on source and replicate it to target in the same manner. This concludes this demo on how to replicate table data between an on premise database to RDS database, using SharePlex.
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/register/55461, or contact your sales rep 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 share SharePlex environments. Thank you for watching this video.
[MUSIC PLAYING]
06:47