Sage 300 CRE SQL Replicator
Replicate Sage 300 CRE Data to SQL Server
Ei Dynamics' Sage 300 CRE SQL Replicator offers a seamless solution for data replication to a SQL Server database.
By migrating your Sage data into a SQL database, you unlock the potential to effortlessly generate reports and establish custom
integrations with other systems. Our replication platform boasts speed, stability, and reliability.
With our solution, concerns about data accuracy or replication status become a thing of the past. No longer do you need to
allocate personnel or resources to constantly oversee the replication process, restart services, or reconstruct tables to
ensure data concurrency. Our replication tool simplifies setup and installation, and once operational, guarantees that your SQL
database consistently mirrors your Sage data. You can have peace of mind and trust in the accuracy and reliability of your replicated data.
On Demand Syncing
Users can independently synchronize data on demand from a securely accessed web page
Data synchronization can be scheduled according to user defined table groups, allowing for a range of syncing schedules.
Sync "All" Sage Tables
All Sage datatables from all modules can be synced (GL, JC, AP, PR, AR, BL, CN, CM, EQ, PJ, PM, SM, PO, IV)
Unlimited Sync Groups
Sync groups are user defined groups of tables to be synced for specified data folders. For example you may have a group for Financial Reporting tables and another group for Payroll tables.
Multiple Data Folders
Supports the ability to sync unlimited number of Sage data folders. Multiple Sage Data Folders can even be synced concurrently for the same tables
Single SQL Database
Whether one or more data folders are being synced, all of the data is synced into a single SQL database. The data is indexed by a data folder code. This ensures all of your data is in a single location and makes consolidated reporting and centralized data access easier.
Cloud or On Premise
Data can be synced to any SQL Database whether the database resides locally or up in the Cloud such as in an Azure SQL Database
Enhanced Sync Speed
Unprecedented sync speeds, tables with millions of records can be updated in minutes. Typical refresh times for a single datafolder across dozens of tables is less than 2 minutes. The replication speed allows for near real-time data replication if so desired.
Daily Audit Reports
Schedule a daily email to inform you of any errors or data inconsistencies that you should be aware of.
Data Audit Tool
Easily check the health and status of your synced data on demand. With a built in audit tool you can quickly and easily see if your SQL Data matches Sage by table and data folder.
Web Based Interface
Enjoy the convenience of a web-based user interface that eliminates the need for workstation or client installations. Once the sync tool is installed on your server, you can seamlessly manage your sync jobs and groups securely from anywhere using just a web browser from a workstation or mobile device.
Web Service Endpoints
Trigger data replication from your custom applications using our REST API sync endpoints.
Tthe following is a list of the minimum system requirements.
(1) If SQL Express is being used the amount of data being replicated cannot exceed 10GB
- Windows Server 2012 R2 or higher
- Minimum of 16GB of RAM on the server
- Minimum of 2 processors
- SQL Server 2017 Express or higher (1)
- IIS7 or greater
- .NET 4.5.2
- An offically supported version of Sage 300 CRE