How to set up data exchange between 1C and MySQL?

Question

MySQL

Help me choose a way to exchange data between 1C and MySQL. I found such an article and everything seems to be fine, but the method is implemented using 1C tools, and I really don’t like it. Is there a way to do the same using MySQL or should I choose another request?

Answer 1

In the ODBC method from 1c, there is almost nothing except the data source... You write the query as you would write it in mysql, substituting the data from 1c as values ​​and giving it to odbc as you would give it from any other application... A good way, worry in vain. Here is the first thing that fell out on "1c mysql odbc database entry" kbss.ru/blog/1c_epf/47.html I looked diagonally, it seems nothing is so short and clear.

Answer 2

Well, it’s definitely impossible to build queries from MySql to 1C, so interaction in only one direction is possible.
In general, look in the direction of data exchange via XML (through an intermediary service) in most cases they do so.

Answer 3

Only in the file version. Deploy the 1C database on the sql server (MS or Postgre). But even in this case it will not be easy, since the structure will be far from trivial.