ERP integration requirements

​

Computer for the agent

​

Network

​

Disk space

​

SQL Server login

• the agent computer’s domain account, <DOMAIN>\<COMPUTER>$, when SQL Server runs on another computer. Both computers must be in the same domain, or in trusting domains.
• NT AUTHORITY\SYSTEM, when SQL Server runs on the agent computer itself.

• read access to four tables: ARTYKUL, MAGAZYN, CENA and CENA_ARTYKULU. Membership of the db_datareader role gives it;
• EXECUTE on Wapro’s own procedure dbo.Api_ProductPriceModify, which a current Wapro Mag installs. The agent’s connection test checks it (Wapro price procedure installed) and does not pass without it. SQL Server hides a procedure from a login that may not execute it, so a missing right and a missing procedure look the same;
• optionally, read access to two more tables, JEDNOSTKA (a product’s unit) and KOD_KRESKOWY (its extra barcodes). Without them products still arrive, but without a unit and without extra barcodes, and the agent logs a warning;
• optionally, read access to three more tables, ARTYKUL_CENA_IE, POZYCJAKONFIG and INTERFIRMAPOZYCJA. They only let the agent check whether Wapro keeps prices equal across the company’s warehouses (the check Same prices in every warehouse, see Wapro). Without them prices are read and sent as usual, and the check shows its hint;
• optionally, read access to WFM_INT_SYSTEM. It only lets the agent warn about an old change-tracking registration (see Wapro); without it that warning is skipped;
• optionally, read access to ARTYKUL_BLOB, Wapro’s product images, and to WAPROERP_KONFIGURACJA. They are needed only to read product images; without ARTYKUL_BLOB only reading images goes off, and everything else carries on.

-- Read access
ALTER ROLE db_datareader ADD MEMBER [<agent-login>];
-- or, table by table:
-- GRANT SELECT ON dbo.ARTYKUL TO [<agent-login>];
-- GRANT SELECT ON dbo.MAGAZYN TO [<agent-login>];
-- GRANT SELECT ON dbo.CENA TO [<agent-login>];
-- GRANT SELECT ON dbo.CENA_ARTYKULU TO [<agent-login>];
-- GRANT SELECT ON dbo.JEDNOSTKA TO [<agent-login>];
-- GRANT SELECT ON dbo.KOD_KRESKOWY TO [<agent-login>];
-- GRANT SELECT ON dbo.ARTYKUL_CENA_IE TO [<agent-login>];
-- GRANT SELECT ON dbo.POZYCJAKONFIG TO [<agent-login>];
-- GRANT SELECT ON dbo.INTERFIRMAPOZYCJA TO [<agent-login>];
-- GRANT SELECT ON dbo.WFM_INT_SYSTEM TO [<agent-login>];
-- GRANT SELECT ON dbo.ARTYKUL_BLOB TO [<agent-login>];
-- GRANT SELECT ON dbo.WAPROERP_KONFIGURACJA TO [<agent-login>];

GRANT EXECUTE ON dbo.Api_ProductPriceModify TO [<agent-login>];

​

Rights for orders and customers

• EXECUTE on Wapro’s own procedures that place, accept and cancel orders and create customers: dbo.Api_OrderDocumentHeaderAdd, dbo.Api_OrderDocumentPositionAdd, dbo.Api_OrderDocumentAccept, dbo.Api_CustomerAddOrModify, dbo.Api_DocumentDeliveryAddressessAddOrUpdate, dbo.RM_ZatwierdzStatusZamowienia and dbo.RM_DodajZestawNaZam_Server (adds a set line to an order). The last one is required even if you sell no sets: without it the check fails and all orders and customers stop. If the login was set up before 2026-10-20, add this grant;
• EXECUTE on three functions those procedures use: dbo.AP_Func_PobierzParamKonf, dbo.RM_Func_PodajTypZamowienia and dbo.WAPROERP_Func_DateTimeToClarionDate;
• INSERT on MIEJSCE_DOSTAWY, to add an order’s own delivery place (the customer’s default place is never changed);
• UPDATE on the column ZAMOWIENIE_INTERNETOWE_ID of ZAMOWIENIE, where Omnilinker records its reference for the order;
• UPDATE on the free-field columns POLE1 to POLE10 of KONTRAHENT, ZAMOWIENIE and POZYCJA_ZAMOWIENIA. Wapro’s procedures save these fields with dynamic SQL, which runs with the rights of whoever calls it, so the login needs them even though Omnilinker uses at most one of the fields;
• SELECT on ZAMOWIENIE, POZYCJA_ZAMOWIENIA, KONTRAHENT, MIEJSCE_DOSTAWY, DOSTAWA, KRAJE, ARTYKUL, MAGAZYN, JEDNOSTKA, STAWKA_VAT, STAWKA_VAT_UE, FIRMA_VAT_UE, WALUTY, FORMA_PLATNOSCI and the view Api_V_CurrencyRates. db_datareader covers all of them;
• optionally, EXECUTE on dbo.Api_CurrencyImport, so the agent can ask Wapro to download NBP exchange rates before a foreign-currency order. The download also needs the SQL Server to allow CLR and to reach the NBP site over HTTPS; without any of it the order is still sent, with a warning. Skip the grant if you leave Download NBP exchange rates off.

-- Orders and customers (in addition to the rights above)
GRANT EXECUTE ON dbo.Api_OrderDocumentHeaderAdd TO [<agent-login>];
GRANT EXECUTE ON dbo.Api_OrderDocumentPositionAdd TO [<agent-login>];
GRANT EXECUTE ON dbo.Api_OrderDocumentAccept TO [<agent-login>];
GRANT EXECUTE ON dbo.Api_CustomerAddOrModify TO [<agent-login>];
GRANT EXECUTE ON dbo.Api_DocumentDeliveryAddressessAddOrUpdate TO [<agent-login>];
GRANT EXECUTE ON dbo.RM_ZatwierdzStatusZamowienia TO [<agent-login>];
GRANT EXECUTE ON dbo.RM_DodajZestawNaZam_Server TO [<agent-login>];
GRANT EXECUTE ON dbo.AP_Func_PobierzParamKonf TO [<agent-login>];
GRANT EXECUTE ON dbo.RM_Func_PodajTypZamowienia TO [<agent-login>];
GRANT EXECUTE ON dbo.WAPROERP_Func_DateTimeToClarionDate TO [<agent-login>];

GRANT INSERT ON dbo.MIEJSCE_DOSTAWY TO [<agent-login>];
GRANT UPDATE ON dbo.ZAMOWIENIE (ZAMOWIENIE_INTERNETOWE_ID) TO [<agent-login>];

-- The ten free fields of customers, orders and order lines
GRANT UPDATE ON dbo.KONTRAHENT (POLE1, POLE2, POLE3, POLE4, POLE5, POLE6, POLE7, POLE8, POLE9, POLE10) TO [<agent-login>];
GRANT UPDATE ON dbo.ZAMOWIENIE (POLE1, POLE2, POLE3, POLE4, POLE5, POLE6, POLE7, POLE8, POLE9, POLE10) TO [<agent-login>];
GRANT UPDATE ON dbo.POZYCJA_ZAMOWIENIA (POLE1, POLE2, POLE3, POLE4, POLE5, POLE6, POLE7, POLE8, POLE9, POLE10) TO [<agent-login>];

-- Read access (if you grant table by table instead of db_datareader)
-- GRANT SELECT ON dbo.ZAMOWIENIE TO [<agent-login>];
-- GRANT SELECT ON dbo.POZYCJA_ZAMOWIENIA TO [<agent-login>];
-- GRANT SELECT ON dbo.KONTRAHENT TO [<agent-login>];
-- GRANT SELECT ON dbo.MIEJSCE_DOSTAWY TO [<agent-login>];
-- GRANT SELECT ON dbo.DOSTAWA TO [<agent-login>];
-- GRANT SELECT ON dbo.KRAJE TO [<agent-login>];
-- GRANT SELECT ON dbo.STAWKA_VAT TO [<agent-login>];
-- GRANT SELECT ON dbo.STAWKA_VAT_UE TO [<agent-login>];
-- GRANT SELECT ON dbo.FIRMA_VAT_UE TO [<agent-login>];
-- GRANT SELECT ON dbo.WALUTY TO [<agent-login>];
-- GRANT SELECT ON dbo.FORMA_PLATNOSCI TO [<agent-login>];
-- GRANT SELECT ON dbo.Api_V_CurrencyRates TO [<agent-login>];
-- (ARTYKUL, MAGAZYN and JEDNOSTKA are in the first block)

-- Optional: the NBP exchange rate download
-- GRANT EXECUTE ON dbo.Api_CurrencyImport TO [<agent-login>];

​

Rights for reading orders back

• ZAMOWIENIE and POZYCJA_ZAMOWIENIA: the orders and their lines;
• POZYCJA_DOKUMENTU_MAGAZYNOWEGO and DOKUMENT_MAGAZYNOWY: the warehouse documents that realise an order;
• DOKUMENT_HANDLOWY, including its column KSEF_ID: the invoices and their KSeF numbers;
• TYP_DOKUMENTU_HANDLOWEGO: the types of those documents, which tell a sale invoice from other documents;
• optionally, MAG_SLOWNIK_STATUSOW_DOKUMENTOW: Wapro’s names for order statuses. Without it the read-back works, but the card cannot show Wapro’s own name for a status.

-- Reading orders back (if you grant table by table instead of db_datareader)
-- GRANT SELECT ON dbo.ZAMOWIENIE TO [<agent-login>];
-- GRANT SELECT ON dbo.POZYCJA_ZAMOWIENIA TO [<agent-login>];
-- GRANT SELECT ON dbo.POZYCJA_DOKUMENTU_MAGAZYNOWEGO TO [<agent-login>];
-- GRANT SELECT ON dbo.DOKUMENT_MAGAZYNOWY TO [<agent-login>];
-- GRANT SELECT ON dbo.DOKUMENT_HANDLOWY TO [<agent-login>];
-- GRANT SELECT ON dbo.TYP_DOKUMENTU_HANDLOWEGO TO [<agent-login>];

-- Optional: Wapro's names for order statuses
-- GRANT SELECT ON dbo.MAG_SLOWNIK_STATUSOW_DOKUMENTOW TO [<agent-login>];

​

Rights for changing orders

• EXECUTE on Wapro’s own procedures that prepare an order for change and change or remove a line: dbo.Api_OrderDocumentPrepareForModify, dbo.Api_OrderDocumentPositionModify and dbo.Api_OrderDocumentPositionDelete. Adding a line and accepting the order use procedures you granted for sending orders;
• SELECT on POZYCJA_ZAMOWIENIA_SPRZEDAZ_TRANSGRANICZNA (the cross-border rows of a line), and on the four tables of reading orders back (POZYCJA_DOKUMENTU_MAGAZYNOWEGO, DOKUMENT_MAGAZYNOWY, DOKUMENT_HANDLOWY and TYP_DOKUMENTU_HANDLOWEGO), because Omnilinker checks whether Wapro has fulfilled or invoiced the order before it changes anything. db_datareader covers all of them.

-- Changing orders (in addition to the rights above)
GRANT EXECUTE ON dbo.Api_OrderDocumentPrepareForModify TO [<agent-login>];
GRANT EXECUTE ON dbo.Api_OrderDocumentPositionModify TO [<agent-login>];
GRANT EXECUTE ON dbo.Api_OrderDocumentPositionDelete TO [<agent-login>];

-- Read access (if you grant table by table instead of db_datareader)
-- GRANT SELECT ON dbo.POZYCJA_ZAMOWIENIA_SPRZEDAZ_TRANSGRANICZNA TO [<agent-login>];
-- GRANT SELECT ON dbo.POZYCJA_DOKUMENTU_MAGAZYNOWEGO TO [<agent-login>];
-- GRANT SELECT ON dbo.DOKUMENT_MAGAZYNOWY TO [<agent-login>];
-- GRANT SELECT ON dbo.DOKUMENT_HANDLOWY TO [<agent-login>];
-- GRANT SELECT ON dbo.TYP_DOKUMENTU_HANDLOWEGO TO [<agent-login>];

​

Omnilinker access

​

ERP integration feature

​

Permissions for the tenant admin

​

The agent’s own access

​

Checklist

• Omnilinker has enabled the ERP integration for your organization.
• The tenant admin has the permissions listed above.
• A 64-bit Windows computer that stays on and can reach the ERP database server.
• A local administrator account on that computer for the installation.
• The Windows accounts of the people who will configure the agent, to add to Omnilinker ERP Sync Operators.
• Outbound HTTPS (port 443) to omnilinker.pl and releases.omnilinker.com from that computer.
• Network access from that computer to the SQL Server port of your ERP database.
• A SQL Server login with read access to the four tables and EXECUTE on dbo.Api_ProductPriceModify, and, to send orders, the rights for orders and customers, and, to read their status and invoices back, the rights for reading orders back, and, to change orders that are already in Wapro, the rights for changing orders. For Windows authentication, a login for the agent computer’s account.
• The ERP database server name, database name and the company number.