Skip to main content

Comarch ERP Optima

The price checker reads items and prices directly from the Comarch ERP Optima company database in SQL Server. It shows the item name and its default sales price.

Before you start​

  • The price checker and the Optima server are on the same network, and SQL Server accepts TCP connections — SQL Server connection.
  • You have a read-only SQL login — script below.

Where to find the server and the database​

  • Server — the SQL server name shown when logging in to Optima, usually in the form COMPUTER\OPTIMA. On the price checker, enter the IP address instead of the computer name, e.g. 192.168.1.10\OPTIMA.
  • Database — the company database, usually with a name starting with CDN_, e.g. CDN_MyCompany. You can see the list of databases in SQL Server Management Studio.
This is not the company database

Optima also has a configuration database (usually CDN_KNF_Konfiguracja). Connecting to it works, but it contains no items — the connection test shows Connected to the server, but CDN_KNF_Konfiguracja is not a ERP Optima database. Choose the company database.

Step-by-step setup​

  1. Open the settings, Source tab.
  2. Choose ERP Optima from the list.
  3. Fill in the fields:
FieldWhat to enterExample
AddressServer IP address and the instance or port.192.168.1.10\OPTIMA
User / PasswordThe read-only SQL login.pricechecker
DatabaseThe company database name.CDN_MyCompany
Encrypt connection (SSL)Leave checked.✓
Search by product code (SKU)Search by item code.✓
Search by EAN codeSearch by the EAN code from the item card.✓
  1. Press Connection test, save the settings and scan a few products.

Which price is shown​

The app shows the price that is set as the default sales price on the item card in Optima, the way it is stored — net or gross, depending on how that price is defined in Optima. For Optima, the price checker settings have no price list choice and no net/gross switch. If customers should see the gross price, set a gross price (e.g. the retail price) as the default sales price in Optima.

Symbol or barcode​

  • Search by EAN code — comparison with the EAN field on the item card.
  • Search by product code (SKU) — comparison with the item code (case-insensitive).

Read-only login​

USE [master];
CREATE LOGIN [pricechecker] WITH PASSWORD = N'Put-a-long-password-here', CHECK_POLICY = ON, DEFAULT_DATABASE = [CDN_MyCompany];

USE [CDN_MyCompany];
CREATE USER [pricechecker] FOR LOGIN [pricechecker];
GRANT SELECT ON CDN.Towary TO [pricechecker];
GRANT SELECT ON CDN.TwrCeny TO [pricechecker];

Comarch ERP Optima — FAQ

Which Optima database do I enter on the price checker?
The company database, usually with a name starting with CDN_, e.g. CDN_MyCompany. Do not enter the CDN_KNF_Konfiguracja configuration database — it contains no items.
Which Optima price does the price checker show?
The default sales price set on the item card, net or gross according to how that price is defined in Optima. The price checker settings have no option to choose another price.
Which permissions does the price checker login need in Optima?
Only SELECT on the CDN.Towary and CDN.TwrCeny tables in the company database.