Just finished a project to integrate Privatbank‘s Ingenico POS terminals with 1C:Enterprise – purchases, refunds etc. with automated Bonus+ handling.
The result is a stable self-contained Debian linux image which can be installed into VM or physical server, and serve as universal interface with simple API to process card payments.
1C:Enterprise does not natively support accessing to Firebird database with External data source function, thus using “Other” category for this task.
But there is one problem – when using dynamic lists, 1C:Enterprise uses constructions like:
SELECT TOP 10 … FROM …
Firebird has another syntax:
SELECT FIRST 10 … FROM …
And as a result such queries does not work.
Attached ODBC driver is patched to replace “SELECT TOP” to “SELECT FIRST” to make 1C:Enterprise work correctly.
There are some other issues left through.
Download from here
English