Re: Inquiry: Using PostgreSQL as a Staging Database for SAP ERP Data Export

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Inquiry: Using PostgreSQL as a Staging Database for SAP ERP Data Export
Date: 2025-08-12 15:13:56
Message-ID: CANzqJaCw+M53Om-VyZjwAN0khqXmYoDbUvAe181XB=8yTfp_tw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

This link says that there's an ADBC driver for Postgresql:
https://arrow.apache.org/adbc/current/driver/status.html

You should probably research _IT_ and SAP as to why your SAP installation
does not have the PG driver.

On Tue, Aug 12, 2025 at 10:36 AM Ian Huang <iancl32ul3(at)gmail(dot)com> wrote:

> Hi Greg,
>
> Thanks for your feedback.
> I’ve tried connecting to PostgreSQL using the ADBC method, but
> unfortunately the SAP Kernel doesn’t have the corresponding .os (DBMS)
> file, so the connection could not be established.
> May I ask if connecting via ADBC is actually feasible in this case?
>
> Best regards,
> Ian
>
> Greg Sabino Mullane <htamfids(at)gmail(dot)com> 於 2025年8月12日 週二 上午12:50寫道:
>
>> That's a little too vague of a question, but yes, Postgres should be able
>> to handle things just fine. The amount of SAP tools and SAP-supporting ETL
>> tools that also support Postgres should be a strong encouragement. I'd
>> recommend looking at the specific tools you would use and confirming they
>> have Postgres support built in. Then try and find use cases / complaints
>> for those specific items.
>>
>> Cheers,
>> Greg
>>
>> --
>> Crunchy Data - https://www.crunchydata.com
>> Enterprise Postgres Software Products & Tech Support
>>
>>

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2025-08-12 16:04:16 Re: Inquiry: Using PostgreSQL as a Staging Database for SAP ERP Data Export
Previous Message Daniel Gustafsson 2025-08-12 10:34:36 Re: Bitnami deprecation