How to integrate FileMaker DBMS and 1C?

Question

1C

There is a main DBMS in which employees work 90% of the time, but to issue invoices and check their payment (as the accountant makes), you still have to use 1C (8.2 on PostgreSQL). What is the best way to automate this process (creating an invoice and getting the status of its payment): exchange through files, access via ODBC, web services, or something else?

Experienced habrazhitel, tell me how to deal with such a scourge.

Answer 1

Who cares - done through ODBC. The exchange logic is implemented on the 1C side in self-written external processing, which accesses FM through the ODBC driver. Not without subtleties, but grown together.

Answer 2

Personally, I would do it from FileMaker: creating an account - through Execute SQL, getting the status - through Import ODBC. (It is assumed that Postgres is available via ODBC.) If it were MS SQL, MySQL or Oracle, then it would be possible to slip them into FileMaker as an external data source.

Answer 3

1. Indirect access is possible through the OLE interface of 1C itself - you can receive data in the form of COMSafeArray. Another way, but you probably don’t need it, is to write an external component to 1C as a proxy.
2. Direct access via ODBC is also an option, because faster than through OLE. The structure of the 1C SQL database is documented, it is simply generated automatically based on metadata, therefore, it can change when changes are made to the database configuration (for example, when updating).
The general concept of the 1C table structure is described in Radchenko's book “Professional Development on the 1C Enterprise 8.0 Platform”, you can find out the correspondence between specific 1C objects and the postgres table structure using the GetDatabaseStorageStructure() function.
This is in a nutshell, if you need details - ask, I will write in detail.

Answer 4

The question is what if you upload this information to a file and then upload it to the DBMS you need?
For me, as a person working with 1C, only such a solution emerges, since it will take a long time online

Answer 5

The topic, of course, is outdated, but I came across just now:
Perhaps the most reliable way is to exchange files (xml or csv).
There is another option to contact FileMaker Server via an http request, forcing it to execute the desired script with the required parameters. At the output, you will receive xml with the data of the light on which the script finished working. That is, FM will return to you the data that you request from it (in your case, for example, new issued invoices).
The technique is described in detail here:
fmteam.ru/vypolnenie-skriptov-na-servere-v-filemak...