Forum

Hi,

How i connect with 1C database and run query on it.

Mahesh,
Where do you want to connect 1C database?

Hi,

I need to access my database tables in IC designer, is it possible, if yes then how can i do it, or there is another way to access IC database tables, i need raw data from those tables, please help.

It is impossible. If you use MS SQL or Postgre - you can use tools of these database.

I used MS SQL in my system then how i can access IC database tables. Please provide steps

Open "MS SQL Management studio" and you can modify all data of your 1C database.

!!!But don't forget it is an entail data corruption. It is recommended to change the 1C data only by 1C tools.

How can i attached IC database in MS SQL Management studio to access IC database tables, i have opened MS SQL Management studio .

If you have opened MS SQL SMS, and you connected MS SQL server, you have to see all bases on the server. Find your database.

Can you say what exactly do you want to modify?

i want to fetch raw data from the IC database tables and ins ert that data in to my SQl database, so that i can access that data from the SQL database and generate reports as per the requirement.

If i rightly understood.
Do you want:
1. to get data from 1C database
2. insert in other MS SQL database and get any reports from this database with help non-1C software?

Yes, exactly.

This is contrary to my beliefs. You can get perfect reports from 1C.

Can write 1C data to another database using ADO (ODBC) if you use 1C platform. What platform do you use?

We used 1C Enterprise 8.2 and Accounting Suite 1.1.24.0