topic Re: PostgreSQL connection from ABAP in Application Development and Automation Discussions

PostgreSQL connection from ABAP

alejandro_gmez — Wed, 25 Jan 2017 11:46:39 GMT

Hi all:

(I apologize for my poor English)

I need to connect to a PostgreSQL database from my ABAP code. I have been reviewing some links related to this problem, but I have not achieved anything useful for me.

My SAP system is: EHP4 for ERP 6.0 with Netweaver 7.01.

Any help on this?

Thanks in advance. Regards,

Alejandro Gómez.

Re: PostgreSQL connection from ABAP

Sandra_Rossi — Wed, 25 Jan 2017 21:57:47 GMT

You probably found ADBC. Why doesn't it work for you?

Re: PostgreSQL connection from ABAP

alejandro_gmez — Thu, 26 Jan 2017 12:18:50 GMT

Hello Sandra Rossi:

I think ADBC is based on previously established connections in the DBCON transaction. DBCON only allows connections to external database databases such as Oracle Database, Microsoft SQL Server, ... but not ODBC type connections (MySQL, PostgreSQL, ...).

Thanks. Regards,

Alejandro Gómez.

Re: PostgreSQL connection from ABAP

Sandra_Rossi — Thu, 26 Jan 2017 18:54:01 GMT

Sorry, my bad.

Re: PostgreSQL connection from ABAP

RaymondGiuseppi — Wed, 02 May 2018 11:21:06 GMT

For reference, read OSS note 2459738 - Missing option for some databases in DBCON.