Sprinkler is a data distribution tool, created to simplify and automate replication of information between distinct databases of Microsoft Dynamics NAV,
available for NAV 2016 and NAV 2017. Find Sprinkler in two versions:
Sprinkler Lite has basic functionality, while Sprinkler eeLite offers more advanced features.
Connectivity is simpler with Sprinkler. The linked servers can be in the local network or distributed. The practical solution is here, try it out!
In the development process, we minimize the impact on the normal user operation, outsourcing the most burdensome tasks to dedicated Application Servers.
The update is assured: Sprinkler is constantly kept up-to-date with releases dedicated to the specific versions of Microsoft Dynamics NAV.
Do you have questions? Sprinkler offers a Partner specific support, with the option of on-site interventions for training and assistance.
Features v.0.7.00 | SprinklerLite | Sprinkler eeLite |
On-demand data replication (Insert, Modify) | X | X |
Nearly Real Time data replication (Insert, Modify, Delete, Rename) | X | |
Unidirectional or bidirectional data distribution between different Microsoft Dynamics NAV databases, even different versions | X | X |
Data distribution between different Company on the same Microsoft Dynamics NAV database | X | X |
Microsoft Dynamics NAV databases can be built on the same SQL Server (distribution via Stored Procedures) | X | X |
Microsoft Dynamics NAV databases can be built on different SQL Servers or Instances (distribution via SSIS Packages) | X | X |
Microsoft Dynamics NAV databases can be built on different SQL Servers (connected via eeRis DeliveryLayer relay service, hosted in Azure cloud) | incoming | |
Targeting the same table (ex. T.18 Customer on T.18 Customer) or not corresponding table (ex. T.18 Customer on T.50000 Partner’s Customer) | X | X |
Targeting the same field (Field1 on Field1) or not corresponding field (Field1 on Field50000) | X | X |
Different targeting setup for data imported from different master databases (ex. data for [Customer] imported from HeadQuarter master database and data for [Currency Exchange Rate] imported from Partner master database) | X | X |
Distribution configuration can be imported and exported in .xml file | incoming | |
Conditional distribution described by filters on data (ex. only changes on Active Customers should be replicated) | X | X |
Table replication utilities: simulated INS, MOD or INS + MOD for every record of the table | X | X |
On-Demand single record replication function available for developers | X | |
Setup available to make a table or specific fields not editable, without code modification | X |
Starting from version v.0.6.00, a new test codeunit is developed for use with the...
It is important for us to provide support and advice to all our customers....
From version v.0.6.00 we have better defined the functionality of Lite and eeLite versions:...
Sprinkler’s development roadmap includes changes to the staging tables of the Sprinkler database to...
No one better than a Partner can fully understand the needs of customers, and...
Starting from June 2017 eeRis becomes a partner of Quattro Business Solutions (QBS Group)....
Much more than a forumWelcome to the eeRis Forum dedicated to Sprinkler! Here you can ask questions, know everything about new Sprinkler updates, get support and much more! Register or log in to join the Community.
