D
D
DmitryName2016-02-12 09:50:51
MySQL
DmitryName, 2016-02-12 09:50:51

How to set up data exchange between 1C and 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 the question

In order to leave comments, you need to log in

3 answer(s)
S
SosnoviyAleksey, 2016-02-27
@DmitryName

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.

A
Anton Chernousov, 2016-02-12
@tech22

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.

G
gunsmyth, 2016-02-12
@gunsmyth

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.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question