Description
SQL Server replication for better business intelligence and reporting
Increase scalability, maximize
availability and provide near real-time
data integration with SharePlex for SQL
Server. This simple-to-use solution
ensures business continuity while
meeting your database operational
goals; it provides a near real-time
copy of production data by ofoading
reporting and analysis — without
impacting OLTP performance and
availability. This highly reliable,
high-performance and low-impact
technology ofers a low-cost alternative
to other replication tools.
With SharePlex for SQL Server, you can
easily replicate multiple copies of data
locally, remotely or in-the-cloud to:
• Dramatically reduce downtime
during migrations from Oracle to
SQL Server — Return control of the
maintenance schedule to IT professionals
by no longer depending on technology
runtimes.
• Achieve cost-efective scalability —
Isolate and remove the operational
reporting and data warehousing loads
from Oracle to SQL Server with a near
real-time copy of your data.
• Reduce storage costs — Archive historical
data afordably. A lean Oracle transaction
instance with SQL Server acts as an
archive repository.
• Maximize the value of your data —
Support business intelligence and
analytics projects with near real-time data
integration.
SharePlex for SQL Server
SQL Server replication for better business intelligence and reporting
Bene?ts:
• Dramatically reduce downtime
during migrations.
• Improve OLTP performance.
• Enable real-time reporting and data
warehousing.
• Optimize business intelligence,
reporting and analytics applications
for real-time use.
SharePlex use case scenarios when replicating data from Oracle to Microsoft SQL Server.
Ofoad reporting/
archiving/data warehousing
Data distribution/
distributed processing
Centralized reporting
(consolidation)
Data integration Migrations
“With SharePlex, we were
able to successfully
integrate our Oracle and
SQL Server databases
without the need for
additional programming
resources, all while
keeping our data secure.”
Luís Alfredo Rodríguez M.
Infrastructure Administrator
Comunicaciones Empresariales de
Colombia S.A.S.
© 2015 Dell, Inc. ALL RIGHTS RESERVED. Dell, Dell Software, the Dell Software logo and products—as
identi?ed in this document—are registered trademarks of Dell, Inc. in the U.S.A. and/or other countries.
All other trademarks and registered trademarks are property of their respective owners.
Dell Software
5 Polaris Way, Aliso Viejo, CA 92656 | www.dell.com
If you are located outside North America, you can ?nd local
ofce information on our Web site.
Features
Business intelligence support —
Integrates directly into SQL Server
environments to support your business
intelligence initiatives.
Impact-free migrations — Enables
modernization of IT environments with
nearly zero downtime during migrations.
User-de?ned data delivery — Facilitates
delivery of Oracle data to SQL Server
databases for complete platform
migrations, archiving, analytics, data
distribution, distributed processing and
centralized reporting.
SharePlex Manager — Provides a
GUI dashboard to easily monitor your
SharePlex environment.
Superior total cost of ownership —
Requires the lowest capital (CapEx)
and operational expenditures (OpEx) of
all industry-leading solutions. Reduce
CapEx with a complete, low-cost
solution that includes all the necessary
tools for migrations, reporting, data
warehousing and application integration
without requiring any add-ons. Reduce
OpEx with a highly coupled solution
that provides unrivaled operational and
administrative efciency.
World-class support — Provides rapid
answers to all your questions and
invaluable guidance from industry
experts, consistently earning excellent
approval ratings from more than 94
percent of customers. Mission-critical,
multi-tier support is available 24x7
through multiple, localized, non-
outsourced support centers.
Services — Ofers implementation,
con?guration and migration services
from a highly quali?ed and experienced
team with a signi?cant track record of
customer satisfaction and success.
Superior development — Delivers
new features to the marketplace when
they’re needed, even outside of release
cycles.
For more information on SharePlex, visit
www.dellsoftware.com/shareplex.
About Dell Software
Dell Software helps customers unlock
greater potential through the power
of technology—delivering scalable,
afordable and simple-to-use solutions
that simplify IT and mitigate risk. This
software, when combined with Dell
hardware and services, drives unmatched
efciency and productivity to accelerate
business results. www.dellsoftware.com.
Datasheet-SharePlexSQL-US-AC-26178
System requirements
Software
SharePlex 8.6
Target environments
SQL Server 2008 R2, 2012, 2014
Windows Server 2003, 2008,
2012, 2012R2
Source environments
Oracle 10g–12c
Unix, Linux, Exadata, Windows
Server
See release notes for details on
supported platforms.
doc_632396858.pdf
SQL Server replication for better business intelligence and reporting
Increase scalability, maximize
availability and provide near real-time
data integration with SharePlex for SQL
Server. This simple-to-use solution
ensures business continuity while
meeting your database operational
goals; it provides a near real-time
copy of production data by ofoading
reporting and analysis — without
impacting OLTP performance and
availability. This highly reliable,
high-performance and low-impact
technology ofers a low-cost alternative
to other replication tools.
With SharePlex for SQL Server, you can
easily replicate multiple copies of data
locally, remotely or in-the-cloud to:
• Dramatically reduce downtime
during migrations from Oracle to
SQL Server — Return control of the
maintenance schedule to IT professionals
by no longer depending on technology
runtimes.
• Achieve cost-efective scalability —
Isolate and remove the operational
reporting and data warehousing loads
from Oracle to SQL Server with a near
real-time copy of your data.
• Reduce storage costs — Archive historical
data afordably. A lean Oracle transaction
instance with SQL Server acts as an
archive repository.
• Maximize the value of your data —
Support business intelligence and
analytics projects with near real-time data
integration.
SharePlex for SQL Server
SQL Server replication for better business intelligence and reporting
Bene?ts:
• Dramatically reduce downtime
during migrations.
• Improve OLTP performance.
• Enable real-time reporting and data
warehousing.
• Optimize business intelligence,
reporting and analytics applications
for real-time use.
SharePlex use case scenarios when replicating data from Oracle to Microsoft SQL Server.
Ofoad reporting/
archiving/data warehousing
Data distribution/
distributed processing
Centralized reporting
(consolidation)
Data integration Migrations
“With SharePlex, we were
able to successfully
integrate our Oracle and
SQL Server databases
without the need for
additional programming
resources, all while
keeping our data secure.”
Luís Alfredo Rodríguez M.
Infrastructure Administrator
Comunicaciones Empresariales de
Colombia S.A.S.
© 2015 Dell, Inc. ALL RIGHTS RESERVED. Dell, Dell Software, the Dell Software logo and products—as
identi?ed in this document—are registered trademarks of Dell, Inc. in the U.S.A. and/or other countries.
All other trademarks and registered trademarks are property of their respective owners.
Dell Software
5 Polaris Way, Aliso Viejo, CA 92656 | www.dell.com
If you are located outside North America, you can ?nd local
ofce information on our Web site.
Features
Business intelligence support —
Integrates directly into SQL Server
environments to support your business
intelligence initiatives.
Impact-free migrations — Enables
modernization of IT environments with
nearly zero downtime during migrations.
User-de?ned data delivery — Facilitates
delivery of Oracle data to SQL Server
databases for complete platform
migrations, archiving, analytics, data
distribution, distributed processing and
centralized reporting.
SharePlex Manager — Provides a
GUI dashboard to easily monitor your
SharePlex environment.
Superior total cost of ownership —
Requires the lowest capital (CapEx)
and operational expenditures (OpEx) of
all industry-leading solutions. Reduce
CapEx with a complete, low-cost
solution that includes all the necessary
tools for migrations, reporting, data
warehousing and application integration
without requiring any add-ons. Reduce
OpEx with a highly coupled solution
that provides unrivaled operational and
administrative efciency.
World-class support — Provides rapid
answers to all your questions and
invaluable guidance from industry
experts, consistently earning excellent
approval ratings from more than 94
percent of customers. Mission-critical,
multi-tier support is available 24x7
through multiple, localized, non-
outsourced support centers.
Services — Ofers implementation,
con?guration and migration services
from a highly quali?ed and experienced
team with a signi?cant track record of
customer satisfaction and success.
Superior development — Delivers
new features to the marketplace when
they’re needed, even outside of release
cycles.
For more information on SharePlex, visit
www.dellsoftware.com/shareplex.
About Dell Software
Dell Software helps customers unlock
greater potential through the power
of technology—delivering scalable,
afordable and simple-to-use solutions
that simplify IT and mitigate risk. This
software, when combined with Dell
hardware and services, drives unmatched
efciency and productivity to accelerate
business results. www.dellsoftware.com.
Datasheet-SharePlexSQL-US-AC-26178
System requirements
Software
SharePlex 8.6
Target environments
SQL Server 2008 R2, 2012, 2014
Windows Server 2003, 2008,
2012, 2012R2
Source environments
Oracle 10g–12c
Unix, Linux, Exadata, Windows
Server
See release notes for details on
supported platforms.
doc_632396858.pdf