Skip to main content
Solved

Connecting to PostgreSQL database with ODBC

  • November 19, 2024
  • 2 replies
  • 75 views

avanrijn
Contributor
Forum|alt.badge.img+2

Dear Sir,

I want to connect to a PostgreSQL database via ODBC.

So I found these posts how to fix this.
 



But I am using TX version 6766.1.

Can someone please point me the way how to fix this with the latest and the greatest version of TimeXtender.

See Word document in the attachment with my setup.

https://legacysupport.timextender.com/hc/en-us/articles/4410466782621-Create-a-ODBC-data-source-in-a-ODX-or-with-a-Any-Source-ADO-Net-provider-in-a-Business-Unit

Thanxs in advance.

Regards,

Arthur

Best answer by Christian Hauggaard

Hi ​@avanrijn Can you please try to use the ODBC provider and then enter the DSN name that has been specified in ODBC Administrator

Then you can edit the data source in TimeXtender Data Integration and click advanced settings to change schema properties

 

2 replies

Christian Hauggaard
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • 1198 replies
  • Answer
  • November 20, 2024

Hi ​@avanrijn Can you please try to use the ODBC provider and then enter the DSN name that has been specified in ODBC Administrator

Then you can edit the data source in TimeXtender Data Integration and click advanced settings to change schema properties

 


avanrijn
Contributor
Forum|alt.badge.img+2
  • Author
  • Contributor
  • 36 replies
  • November 20, 2024

Hi Christian,

Yes, it worked !

Thank you very much.

Regards,

Arthur