SymmetricDS
Design, Implementation, and Maintenance
SymmetricDS is open source software compatible with both file and database synchronization. SymmetricDS handles multi-master replication, filtered synchronization, and transformation across the network throughout your diverse information systems environment. The software can handle multiple subscribers utilizing one-directional or bi-directional data replication, whether asynchronous or synchronized. It uses web and database technologies to replicate data as a scheduled or near real-time operation. The software was designed to scale for a large number of nodes, work across low-bandwidth connections, and withstand periods of network outage. It works with most operating systems, file systems, and databases, including Oracle, MySQL, MariaDB, PostgreSQL, Microsoft SQL Server (including Azure), IBM Db2, H2, HSQLDB, Derby, Firebird, Interbase, Informix, Greenplum, SQLite (including Android), Sybase ASE, and Sybase ASA (SQL Anywhere) databases.
Questions & Answers
Do you need database replication software?
With a full suite of features across a multitude of platforms, SymmetricDS is the open source solution you are looking for. XTIVIA can collect your replication requirements and provide an estimate to design and implement your replication project and then help you maintain it.
How do you handle failover and backups?
XTIVIA can configure SymmetricDS to replicate data to a standby copy of your critical production system. After any failures, it can then replicate any changes made to the standby back to the recovered primary. You can move between platforms and do transformations as well since SymmetricDS can replicate betweens different database platforms and between varying table structures.
Do you need to address distributed data or consolidation in your environment?
XTIVIA can help you plan and implement the distribution of data in your environment. SymmetricDS can be used to distribute data from a central location across multiple levels of synchronization. You can collect data from across your enterprise into a central repository in a pull or push synchronization with secure protocols to handle firewalls. Conflicts can be addressed via pre-defined rules or handled as your business rules dictate.
Do you need to get production data to your data warehouse?
XTIVIA can assist you with configuring SymmetricDS to replicate data from your production systems to a data warehouse environment. Any necessary transformation or filters can be handled so the data is loaded as required for your data warehouse structure.
Does reporting put a load on your production systems?
XTIVIA can configure SymmetricDS to move production data to a database used only for running reports or other analysis. This would reduce the workload of your production systems and the reporting systems do not need to be on the same database platform as your production.
How many different database platforms do you use?
Since each database vendor has their own tools and protocols XTIVIA can help you use SymmetricDS to move data between them all. Differing data structures can be transformed and data can be filtered for security reasons between different platforms.
System Requirements
Java SE version 6, 7, or 8 is needed. Windows, Linux, Solaris, HP-UX, AIX, Mac OS X, and Android are currently supported Operating Systems.
License
Licensed under the GNU General Public License (GPL) version 3.0 SymmetricDS is free software. A commercial software license is available with SymmetricDS Pro if you desire support or in order to distribute SymmetricDS with commercial software.
Contact Us
Learn how XTIVIA can help you license, implement, improve, and maintain your SymmetricDS implementation today!