1c:enterprise and mssql

Question

1C-Bitrix

Hello habraman.
The other day I stumbled into the insides of the DB 1s`ki and went a little crazy - about one and a half thousand tables (it seems just overtaken from dbf). Then I poked into the code of the guys who write programs and modules for us and went crazy from the fact that the requests are in Russian and (sort of like) to normal tables. Even though they don't exist physically.
The question is, is it possible to work with data somehow bypassing their configurator? Is there a description somewhere for what which table is responsible or is it all wired into the client?

Answer 1

>> Is there a description somewhere for what which table is responsible or is it all wired into the client?
Yes, it's all sewn up. In a specific configuration of a specific version. When you change the version, the structure may change. If you need to read data bypassing 1C, use LINQ. See more details here - www.linq-demo.1centerprise.com/

Answer 2

I recommend getting acquainted with 1C++ (http://www.1cpp.ru/index.php/Main) and ToySQL (http://www.1csql.ru/index.html)
these libraries will allow you to directly access data in SQL .

Answer 3

There is a community of 1C professionals, you can ask there:
www.infostart.ru

Answer 4

One link: metaprog.co.ua/
I say right away - you are tormented. But in principle, using the information from the link above, you can read quite well from the 1C base. With the record, of course, much worse.

Answer 5

Most likely there are no means and no normal description, because 1C monitors its product very strictly, because they breed a monopoly.

went crazy from the fact that queries are in Russian and (sort of like) to normal tables. Even though they don't exist physically.

In 1C queries, existing tables are accessed, they just have non-human names and non-human column names. This is again done for conspiracy and so that it is impossible to work easily and simply with the 1C base.
PS: Requests can also be written in English (in 1C there are English analogues for all commands of the built-in language and the query language)

Answer 6

If 1C 7ka, then such a file 1Cv7.DDS should lie somewhere - the rules are described there. language directories and registers and their fields. Actually, it's the only way :)
When you get into it, it's not so difficult - if you know what to get from where (you can ask the bukhs).

Answer 7

By the way, if I remember correctly, for the latest versions of 1C, working with the database directly, bypassing the engine, is prohibited by the license agreement.

Answer 8

Explanations here: v8.1c.ru/predpriyatie/questions_licence.htm
But I would not say that the ban is very explicit.
And it certainly won't stop anyone :)

Answer 9

You can use 1C data bypassing 1C itself. For version 7.x it is quite simple, for 8.x it is more difficult. For 7.x, I bypassed (directly) did almost everything in general - filled out directories, formed postings. Until I realized that this is a dead end path, having spent a lot of time and effort. It is not so difficult to learn the 1C language, especially since a relatively decent object model has appeared since 8. But! Programming even simple operations under 1C requires an understanding of accounting at a level HIGHER than that of an average accountant. Too much language is tied to the subject area.