Overview
Achieve high availability, scalability and data integration through real-time database replication across on-premises, cloud or hybrid databases. SharePlex database replication empowers your organization to achieve its database goals now and into the future. Make use of built-in monitoring, conflict resolution, data comparison and synchronization capabilities backed by award-winning support
Highlights
- Near real-time replication between onprem, cloud or hybrid databases
Details
Pricing
Additional AWS infrastructure costs
Type | Cost |
---|---|
EBS General Purpose SSD (gp2) volumes | $0.10/per GB/month of provisioned storage |
Vendor refund policy
None
Legal
Vendor terms and conditions
Content disclaimer
Delivery details
64-bit (x86) Amazon Machine Image (AMI)
Amazon Machine Image (AMI)
An AMI is a virtual image that provides the information required to launch an instance. Amazon EC2 (Elastic Compute Cloud) instances are virtual servers on which you can run your applications and workloads, offering varying combinations of CPU, memory, storage, and networking resources. You can launch as many instances from as many different AMIs as you need.
Version release notes
Additional details
Usage instructions
-
SSH to the instance and login as 'ec2-user' using the key specified at launch.
-
Add SharePlex License key by executing the following command: /home/ec2-user/shareplex/proddir/install/splex_add_key
-
Updating the database connection entries in TNS and ODBC file
a. For Oracle Database - Configure TNS for source and target databases: cat > $TNS_ADMIN/tnsnames.ora rds = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ${DB_SOURCE_HOST}) (PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME=${DB_SOURCE_SID}) ) )
rdstarget = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ${DB_TARGET_HOST}) (PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME=${DB_TARGET_SID})))
${DB_SOURCE_HOST} and ${DB_TARGET_HOST} are the source and target hostnames, and ${DB_SOURCE_SID} and ${DB_TARGET_SID} are the Oracle SIDs for those hosts.
b. Update odbc.ini and confirm the entries in odbcinst.ini odbc.ini --> [DSN] Driver=<DriverName as per odbcinst.ini> Description=PostgreSQL Trace=No Servername=<ServerName/IPAddress> Port=5432 UserName=<Username> Password=<Password> Database=<DatabaseName>
-
Execute the ora_setup command for source and target databases for Oracle Database ora_setup is mostly the same as a normal SQLNet SharePlex installation except for a few questions: Answer "no" to the following question: Will the SharePlex install be using a BEQUEATH connection? (Entering 'n' implies a SQLnet connection) [y] : n Answer "yes" to the RDS question if a source/target is an Amazon RDS database: Are you configuring a AWS RDS Database? (Entering 'n' implies non-RDS database) [n] : y
-
Execute the pg_setup command for source and target database for PostgreSQL Database pg_setup uses odbc.ini details to connect with postgreSQL database and perform the setup. Detailed steps are available in technical documents
More details available here: https://support.quest.com/shareplex/technical-documents
Resources
Vendor resources
Support
Vendor support
AWS infrastructure support
AWS Support is a one-on-one, fast-response support channel that is staffed 24x7x365 with experienced and technical support engineers. The service helps customers of all sizes and technical abilities to successfully utilize the products and features provided by Amazon Web Services.
Customer reviews
Great for data replication and scaleing your Oracle DB
the low overhead is a plus
did it with almost 0 downtime.
Excellent product for database replication
A largely positive experience, with some improvements needed
Best tool for Replication database
Overall review about SharePlex
SharePlex is using for Oracle database replication for large organization as well as helps to store data in better way.