Frequently asked questions
Straight answers about CertiReplica
What it needs in SAP Business One, what travels and what never does, changes in the target, two-way rules, removals, installation, security, licensing, and what it does not do yet. Something missing? Ask us.
In SAP Business One
Does CertiReplica install anything inside SAP Business One?
No. It talks to each company through its Service Layer only. There is no add-on, no stored procedure, no user-defined table or field of its own, no Transaction Notification and no database user. Everything CertiReplica remembers, such as which record of one company is which record of another, is kept in its own store on its own server.
Which SAP Business One versions and databases does it work with?
It needs the Service Layer of SAP Business One 10.0. It was run and proven on SAP Business One 10.0 on SAP HANA. Because it only uses the Service Layer, nothing in it depends on the database behind a company, but companies on Microsoft SQL Server have not been run yet, and we say so until they have.
Which SAP user does it need?
One dedicated SAP Business One user per company, not a superuser. That user's authorisations are the limit of what CertiReplica can read and write: SAP Business One holds a standard user to its authorisations through the Service Layer, for reading too. When an authorisation is missing, the refusal names the SAP user and says where to give it. Which SAP licence type that user needs is for you and your SAP partner to settle; the manual describes the set-up we recommend.
Do SAP Business One's own checks still apply?
Yes. Every record is created and changed through the Service Layer, never by writing to the database, so the same business rules apply as when a person enters the record. When SAP Business One refuses something, the record waits in Activity with SAP's own reason.
Do the companies have to be on the same server?
No. Each company only needs a Service Layer address the CertiReplica server can reach. Companies on different servers, on premise and hosted, can be sources and targets of the same rule. Companies are grouped into landscapes such as Production and Test, and a rule never crosses landscapes.
What travels
Which master data can it replicate?
32 kinds, from items, business partners, price lists and bills of materials to the setup tables they depend on, and the definitions of user-defined fields and tables. The objects page lists every one with its mark: 29 are Proven on a real system, the others are Preview.
What never travels?
Stock, balances, costs and dates of change never leave a company, whatever a rule says. Fields that usually belong to one company, such as the number series, the house bank, G/L accounts and the default warehouse, are left alone unless a rule names them. Private and payroll data of employees stays at home unless a rule names the field. Tax groups, currencies, dunning terms and payment methods are mapped between companies and never copied.
Do item codes and customer codes have to be the same in every company?
No. A rule can give records another key in the target with a template such as B-{key}, and a mapping can pair any record of one company with any record of another. Records SAP Business One numbers itself, such as item groups, are matched by name and then remembered by a link.
An item refers to an item group that does not exist in the target. What happens?
What the rule says under Missing references. With Match the item is held, with a sentence naming the item group. With Create it the item group is created first, SAP Business One gives it its number there, and the item is written with that number. A fixed value or an empty field are possible too, per referenced object.
What about user-defined fields?
They travel like any other field when the target has them. A field the target lacks is left out of the record and named in the message, instead of failing the record. A rule for user-defined fields creates the missing definitions in the target; after new fields were created, the target's Service Layer has to be restarted, and CertiReplica says so.
Can it copy prices, addresses and contact persons?
Yes. They are lists inside a record, and each list is merged (rows are added and updated) or mirrored (rows the source no longer has are removed), as the rule says. Price lists are translated like any reference, so price list 1 of the source can be price list 4 of the target.
Changes, conflicts and removals
Someone changed a record in the target company. Is that overwritten?
Only if the rule says so. CertiReplica remembers what it wrote, so it recognises a value that was changed in the target since. The rule decides: the source wins, the target keeps its change, or the record is held as a conflict that names the fields and waits for a decision in Activity.
What does two-way mean exactly?
A change made in either company travels to the other, field by field. A field only one company changed is no conflict. A field both changed goes to the winner the rule names, or waits for a person. With Lists travel both ways the same holds for rows of lists such as contact persons. Writing a change never starts a loop.
Can CertiReplica delete records?
No, never. When a record is removed in the source, its counterpart in the target is reported for a decision or put on hold, as the rule says. A record only counts as removed when the source's list lacks it and asking for it by key finds nothing, and when many seem to be gone at once nothing is put on hold unasked.
Can a write be undone?
Yes. The history keeps the before and after of every field a job wrote, and Roll back puts the old values back, including a row that a mirrored list removed. A record that was created is put on hold rather than deleted. Files that were copied, a picture or attachments, stay.
How quickly does a change arrive?
An automatic rule looks for changes about once a minute. A scheduled rule looks at the times you set. A manual rule runs when someone presses Run now. Records removed in the source are looked for about every fifteen minutes, or when someone asks.
Installation and security
Where does CertiReplica run?
On a Windows server (Windows Server 2019 or later) that can reach the Service Layer of every company. One setup program installs one Windows service with its own web app; it carries its own .NET runtime. It does not have to be the SAP server, and it needs no connection to the internet or to CERTICONS.
Where does it keep its own data?
By default in one file in its data folder, which needs no database server: back that folder up. It can keep the same data in a database on Microsoft SQL Server instead, and a command moves the data from one to the other. The keys that encrypt the stored SAP passwords stay in the data folder either way.
How are passwords and connections protected?
SAP passwords are stored encrypted with a key only that server can use. A Service Layer whose certificate the server does not trust is refused until its thumbprint is entered on the company. The web app can answer over HTTPS with a certificate from the Windows certificate store. Account passwords are kept as salted hashes, and the setup program reads passwords from environment variables, never from a command line.
Who can do what in CertiReplica?
There are three roles. An administrator sets up companies, rules, notifications, the licence and accounts. An operator runs rules and decides about records that wait. A viewer reads everything and simulates, and cannot change anything. A rule can require an operator's approval before it writes.
What happens on an upgrade?
The same setup program upgrades or repairs an existing installation and keeps every setting. Before it changes anything it puts a copy of the configuration and of the data file under backups in the data folder, and it writes what it did to a log.
Licensing
How is CertiReplica licensed?
By the number of SAP Business One companies that are active in it, and by module: Replication, Two-way, Structure and Notifications. The licence is a signed text that is checked on your server, with no connection to us, and can be tied to one installation. See Licensing.
Is there a trial?
Yes. Without a licence CertiReplica works in full for 30 days from its first start, with every module. After that, people can still look at everything, simulate and change the setup, but nothing is replicated until a licence is installed.
What does it cost?
Prices depend on the number of companies and the modules and are quoted per group. Use the contact form; it asks for what a quote needs.
What it does not do yet
CertiReplica is at version 0.1. We would rather you read its limits here than find them later.
What has not been proven on a real system?
Everything proven so far ran on SAP Business One 10.0 on SAP HANA with the UK demo company. Not yet run on a real system: companies on Microsoft SQL Server; other localisations; a row removed from a list under Mirror; the accounts of a segmented chart of accounts; the copying of pictures and attachments; the guard against many removals at once. These are covered by automated tests only. The objects marked Preview on the objects page, and the rows of user-defined tables, are not proven end to end either.
What does it not replicate?
Documents such as orders and invoices: CertiReplica is for master data. Stock, balances and costs. Period and volume discounts of a price list (special prices for a business partner do travel). The lists of an employee, such as absence and education. Prices per unit of measure and the quantity steps of a special price are added and updated, never removed.
Is there a window inside the SAP Business One client?
No, on purpose: that would need an add-on in every company. CertiReplica is a web app. Its Find a record screen has an address that names the record, which can be kept as a bookmark or a link, and shows where the record is in the other companies.
Which notification channels were tried for real?
An internal message arrived in a real company's SAP Business One messages. E-mail and the webhook were tried against local stand-ins; a mail server with sign-in and encryption and a real Microsoft Teams or Slack channel have not been tried yet.
Can its own data be kept on SAP HANA?
No. Its own data is kept in a file, or in a database on Microsoft SQL Server. This is about CertiReplica's own store only and has nothing to do with the database of your SAP Business One companies.
In which languages is it available?
The web app, the setup program and the manual are in English.