Sage 300 CRE SQL Replicator
Overview
Key Features
User Interface
Installation Requirements
Overview:
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.
Key Features:
| Feature | Description |
|---|---|
| On Demand Syncing | Users can independently synchronize data on demand from a securely accessed web page |
| Scheduled Syncing | 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. |
User Interface:
Installation Requirements:
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
(1) If SQL Express is being used the amount of data being replicated cannot exceed 10GB
Brochure Download:
