SharePlex – How many birds can this stone kill?

For the majority of larger organisations, gone are the days of “the production database”.
DBAs nowadays have to deal with multiple production databases, tighter SLAs and, in many cases, more than one database technology.

From speaking to clients, the most common reason behind this is BI.
Companies are desperate to store data – all kinds of data, sometimes not knowing what business value or advantage is to be gained from storing it – but at least they have it, they can figure out how to use it later! This means DBAs are dealing with increased volumes of data, decreased tolerance for downtime but the budget that’s funding this is not growing accordingly.

 

It’s a very frustrating position to be in and leads DBAs and IT teams to venture off to new technologies in order to reduce costs, whether it be the cloud or other database platforms.
This however leads to another problem. It’s rare that a company has multiple databases that never communicate. Eventually these databases need to talk – data needs to move between them. This can lead to further complexity of the IT infrastructure with a mixture of DR tools and replication tools, some developed in-house and others a mixture of native and/or 3rd party offerings; some in real-time, others in batch processing – you get the point!

So at this point I’d like to introduce SharePlex – the change data capture tool. A single tool that enables you to achieve all of the above. It captures and replicates data changes between databases in real-time and/or batches.

Take, for example, a company with the above scenario. They have a few on-premise Oracle production databases serving different business purposes, with a custom in-house built solution replicating data changes on a sub-set of tables between databases every few seconds. They all have RAC for HA and DataGuard for DR. Another custom in-house built replication solution moves data from the Oracle databases into an Azure-based SQL Server data warehouse in batches every few hours.
The beauty of SharePlex is that it can be used for several purposes, including all scenarios listed above like High Availability, Disaster Recovery, replication of all or a sub-set of tables and replication from Oracle to SQL Server. Better than that, it can be used for several purposes concurrently. So you could setup a DR site with SharePlex and since it’s always on and always up-to-date it can meet your High Availability needs also, and why not use that DR/HA database for to report off as well?
And when it’s time to migrate or upgrade your databases, you can do so with minimal downtime and risk by using SharePlex again.

I think you’ll agree that having one tool that can cater for all these use cases will not only simplify and improve your IT environment but also save you time and money, while allowing you to be flexible in terms of database technologies and platforms.

If only it could make me a cuppa tea as well!

As a follow up, we've released chapter 3 of 'Simplify Your Database Migrations and Upgrades', you can download the e-book here:

About the Author
Denis.OSullivan
Hi folks, I'm a system consultant with Quest since 2015 based in Cork, Ireland. Prior to joining Quest I worked as a database administrator and application server administrator. My role at Quest...