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: 32
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
Interested
Rating: 16
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
 
#4
People who like this:0Yes/0No
Just came
Rating: 0
Joined: Jan 29, 2018
Company:

Thank you very much!

 
#5
People who like this:0Yes/0No
Active user
Rating: 3
Joined: Mar 10, 2017
Company: Rufinor

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

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

Thank you Alex.
I will have a look.

 
Subscribe
Users browsing this topic (guests: 1, registered: 0, hidden: 0)
Be the first to know tips & tricks on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.