How to read the tables from 1C for external database access?



The 1C:Enterprise developers forum

#1
People who like this:0Yes/0No
Just came
Rating: 0
Joined: Jan 29, 2018
Company:

Hi!

Our subsidiary company in Russia is using the 1C:Enterprise platform.
I am working in Europe and we need the data from the 1C database for our reporting.

Currently we are using JDBC to connect our databases with Java.

Is it possible to use JDBC for the 1C database connection?

Is the 1C database a RDBMS?

 
#2
People who like this:0Yes/0No
Interested
Rating: 33
Joined: Oct 27, 2011
Company: Abaco Soluciones S.A.

You can not directy connect to 1C app database. It is better to use OData interface to collect info, but you will need to ask subsidiary company in Russia to make OData interface public (it is quite simple, please see manual)

 
#3
People who like this:0Yes/0No
Administrator
Rating: 14
Joined: Dec 4, 2017
Company:

Dear Tom,

In addition to Alexey's answer:

Alternatively, you can install your 1C:Enterprise infobase to an external RDBMS supported by 1C:Enterprise (Microsoft SQL Server, PostgreSQL, IBM DB2, Oracle Database) and then rely upon the chosen RDBMS's JDBC driver to establish JDBC connections to your infobase.

Best regards,
Vladimir Gurov

1C Company support team
 
Subscribe
Users browsing this topic (guests: 1, registered: 0, hidden: 0)