public inbox for [email protected]  

help / color / mirror / Atom feed

From: Ron Johnson <[email protected]>
To: pgsql-generallists.postgresql.org <[email protected]>
Subject: Re: Inquiry: Using PostgreSQL as a Staging Database for SAP ERP Data Export
Date: Tue, 12 Aug 2025 11:13:56 -0400
Message-ID: <CANzqJaCw+M53Om-VyZjwAN0khqXmYoDbUvAe181XB=8yTfp_tw@mail.gmail.com> (raw)
In-Reply-To: <CADAzcMz9vR_SgsUt3GdkSdwiOtMHsfhWXx+Tp89CQO5tMoMCqw@mail.gmail.com>
References: <CADAzcMw06C88PiB=OGnCeeTAP0-YgZP5HwyUA7QwFbaMLJeDAQ@mail.gmail.com>
	<CAKAnmmL3vzzXBkpwv1Y=mwnbDb-WJeRYEQNDTUuWuz7o=4vEqQ@mail.gmail.com>
	<CADAzcMz9vR_SgsUt3GdkSdwiOtMHsfhWXx+Tp89CQO5tMoMCqw@mail.gmail.com>

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 <[email protected]> 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 <[email protected]> 於 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!

view thread (4+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Inquiry: Using PostgreSQL as a Staging Database for SAP ERP Data Export
  In-Reply-To: <CANzqJaCw+M53Om-VyZjwAN0khqXmYoDbUvAe181XB=8yTfp_tw@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox