Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uiwW7-000Vy5-49 for pgsql-general@arkaria.postgresql.org; Mon, 04 Aug 2025 14:50:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uiwW4-001pyj-IE for pgsql-general@arkaria.postgresql.org; Mon, 04 Aug 2025 14:50:20 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uikIs-00Etms-3L for pgsql-general@lists.postgresql.org; Mon, 04 Aug 2025 01:47:54 +0000 Received: from mail-pf1-x42e.google.com ([2607:f8b0:4864:20::42e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uikIp-000c8Y-3B for pgsql-general@lists.postgresql.org; Mon, 04 Aug 2025 01:47:53 +0000 Received: by mail-pf1-x42e.google.com with SMTP id d2e1a72fcca58-76bd041c431so3088827b3a.2 for ; Sun, 03 Aug 2025 18:47:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1754272070; x=1754876870; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=oTBmVJo2cxLoZf6ttZXmQ35jp1BjoP/NnnoeSLl5grQ=; b=VwxI8lFIAMQUgOwogC0BVlio0jHrLqowimue6uuAS0N+MyMQKwAMAdIngS+Jxwt0hw 1xJ7oORxaN4y3NeBo7GxEB6HDUJqH+PUUKdOQBac5KtWZ7eIsubTvU1eRoT+ChlaUdI4 vLeval9NUcU5CJ5qUbQn5nshHIjV/IKHVH5sGVgD2UgLImg81MIdNHDKllI5ZPAx+lNW hImcjwJZmpZ8AozA0dkO1OFiIgxOeWx46LvNfVIQatN4RCqyoqs17M5oHHl6ox/jaif4 CV9XUsmNUuOVXo40vGzBfSMwxKKUB5W3XCMDLfSx2IvGkmQlhKdGNbGoH/SDAXbwVnZs On4A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1754272070; x=1754876870; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=oTBmVJo2cxLoZf6ttZXmQ35jp1BjoP/NnnoeSLl5grQ=; b=ByK9yAa1wabUGsHbNgVCZdjjDhdcGx6jDNt0W9pnK6vbGuzK7aK38yQ87xSPcuf+3a kj/M5Rg3kelU/jCAUm4TUyhvwIOJwqX4aLZL3ONnUimo2mQJo/74T0Cwn/g8C3U3fdJq qXV/wSIPPZyaFVN8YOChhqw+PXt6ElcQ4bB/8L+U/2CpH9WO0WlbPXRYfRcZJwM2z5Vp EG4zC4YX/xvElPKkgj0tl80gIJ8URv30boLFJ2qO5h5HATujbSsuJ81GYFiA9g+oSt+V W6Fpr8IYjyQ488ES1/HXKGErsWVVNrmDA3msH8f8WF0r62KN27u2J2fHl0rYDSt7sdci tjOg== X-Gm-Message-State: AOJu0Yy0xZpKSLyGtTC7zuil6IuDoBnxMUg1Jdr89hYA8e1ATNhIPBiL j45UcVv66MJ/PTNKl13K4sX7Io6/jQBhqkG+hKCAyupbo6JPIliK+ETpvKNdq7AUk4qYUjo5JJC h1MoTNb3vVDHRd+LTXyb+LLXZj79dMNapizEc X-Gm-Gg: ASbGnctqjugP5AukdGrUbldajob9J8fzguPPkRbIvHZwcDNeJ1HXRGk2LHTClYY2945 c0SNi5hbJXCO4PUqIkHHDez7Pkw8AsMPMcrukhx1Ho6cKL9mEswtFjkj1oRJr/Ar9HpapBA4Q97 ja1pk501kqFgdDgZVQWD/48D/pfHuXNwfGZ7LC9rwr5CAHmzeei4RarRCQQYBAVkI7DuTouise+ PQ/14Pj X-Google-Smtp-Source: AGHT+IFNqqwgFy5c0elXusEU1gl+672ywfbbc3GJK/YoEK1KsIoLTARFRrWo6A5Xor/WYEzCG8M3kBdYamkH1/GLDwk= X-Received: by 2002:a05:6a20:5493:b0:238:3f54:78f1 with SMTP id adf61e73a8af0-23df9193155mr12716432637.43.1754272069956; Sun, 03 Aug 2025 18:47:49 -0700 (PDT) MIME-Version: 1.0 From: Ian Huang Date: Mon, 4 Aug 2025 09:47:39 +0800 X-Gm-Features: Ac12FXzT7YWEkvnX4wi1GoLGjOY6MEfqj-rDzyTLSn63YGSPgbmIiEdLwhHwnRE Message-ID: Subject: Inquiry: Using PostgreSQL as a Staging Database for SAP ERP Data Export To: pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="00000000000091bf61063b804be5" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000091bf61063b804be5 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Dear PostgreSQL Community Team, I hope this message finds you well. I=E2=80=99m currently exploring options for implementing a staging (interme= diate) database to handle outbound data exports from an SAP ERP system. I would like to inquire whether PostgreSQL is considered a suitable and stable solution for this purpose, particularly in terms of performance, data integrity, and compatibility with SAP or third-party middleware. Specifically, I=E2=80=99m interested in the following: - Any known use cases or best practices of using PostgreSQL in SAP ERP data pipelines. - Recommendations or considerations for integrating PostgreSQL in such a scenario. - Whether there are any limitations or concerns regarding this architecture. I would greatly appreciate it if you could direct me to any relevant documentation, user groups, or case studies that could help. Thank you for your time and support. Best regards, Ian Huang. --00000000000091bf61063b804be5 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

Dear PostgreSQL Community Team,

I hope this messa= ge finds you well.

I=E2=80=99m currently exploring options for implem= enting a staging (intermediate) database to handle outbound data exports fr= om an SAP ERP system. I would like to inquire whether PostgreSQL is conside= red a suitable and stable solution for this purpose, particularly in terms = of performance, data integrity, and compatibility with SAP or third-party m= iddleware.

Specifically, I=E2=80=99m interested in the following:

=

  • Any known use cases or best practices= of using PostgreSQL in SAP ERP data pipelines.

  • Recommendations or considerations for integrating PostgreSQL= in such a scenario.

  • Whether ther= e are any limitations or concerns regarding this architecture.

    • I would greatly appreciate it if you could direct me to any relevant do= cumentation, user groups, or case studies that could help.

    Thank you = for your time and support.

    Best regards,

    Ian Huang.

--00000000000091bf61063b804be5--