Connect to external data source ?

1C:Enterprise platform integration capabilities and techniques

#1
People who like this:0Yes/0No
Active user
Rating: 4
Joined: Feb 26, 2015
Company: Uguz Limited sirketi

:?:
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?

Edited: Erdogan Uguz - Jun 25, 2015 08:22 AM ((solved))
 
#2
People who like this:0Yes/0No
Timofey Bugaevsky
Guest

Joined:
Company:

Hello, Erdogan Uguz!

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

 
#3
People who like this:0Yes/0No
Active user
Rating: 4
Joined: Feb 26, 2015
Company: Uguz Limited sirketi

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.

 
#4
People who like this:0Yes/0No
Active user
Rating: 4
Joined: Feb 26, 2015
Company: Uguz Limited sirketi

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

 
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.