Main > Forum > 1C:Enterprise Platform > 1C:Enterprise – Business applications platform > How to read the tables from 1C for external database access?

Forum

Search UsersRules
How to read the tables from 1C for external database access?
#1
Just came
Points:: 0
Joined:: Jan 29, 2018

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?

Profile
#2
Interested
Points:: 15
Joined:: Oct 27, 2011

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)

Profile
#3
Interested
Points:: 0
Joined:: Dec 4, 2017

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

Profile
#4
Just came
Points:: 0
Joined:: Jan 29, 2018

Thank you very much!

Profile
#5
Active user
Points:: 0
Joined:: Mar 10, 2017

Dear Tom, there is a link to page where you can find number of integrations methods with 1C . In addition to above recommendations you can also use COM technology if you are using windows platform.

Kind regards,
Alex

Profile
#6
Just came
Points:: 0
Joined:: Jan 29, 2018

Thank you Alex.
I will have a look.

Profile
Subscribe
Users browsing this topic (guests: 1, registered: 0, hidden: 0)



© 1C LLC. All rights reserved
1C Company respects the privacy of our customers and visitors
to our Web-site.