Desktop version

Main > Forum > 1C:Enterprise Platform > 1C:Integration > Connect to external data source ?

Forum

Search UsersRules
Connect to external data source ?
#1
Active user
Points:: 0
Joined:: Feb 26, 2015

:?:
Hi.

I want to connect to a table in another database server. Inside there is another data outside 1C.

I opened in Designer mode. I opened the configuration. I opened to external data sources. Add said. I click the Data tab. I clicked on the table. I press the Add button. I chose the external data source table. Forward said. I chose the PostgreSQL database management system.

What should I write to the connecting line of the box?

Profile
#2
Guest
Points::
Joined::

Hello, Erdogan Uguz!

You will need PostgreSQL ODBC driver installed. Then you could select it from the driver list.

Profile
#3
Active user
Points:: 0
Joined:: Feb 26, 2015

Hello.
I have three server computers.
U1 server (Centos 7 / PostgreSQL Database www.postgresql.org)
U2 Server Windows Server 2008 R2 (1C Server / PostgreSQL Server 1C)
U3 Server Windows Server 2008 R2 (Microsoft SQL Server 2008)

UU my computer (Windows 8.1 / 1C client)

- 1C My client is running on my computer.
- UU -> making the connection. U1 / U2 - pgAdmin
- U3 -> making the connection. U1 / U2 - pgAdmin
- U2 -> unable to connect. U1 - pgAdmin

Firewall is turned off. U2 can not make a remote connection to another database. U2 also 1C PostgreSQL. U1 PostgreSQL (www.postgresql.org).

I want to U1 to U2's connection. I want to connect eat Table 1C.

Profile
#4
Active user
Points:: 0
Joined:: Feb 26, 2015

Hi.
i solved my problem.
Look network mask :) ;)

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.