Question Re: SAP Data Warehouse Cloud connect to PostgreSQL in Technology Q&A

SAP Data Warehouse Cloud connect to PostgreSQL

Cristhian_Rios — Tue, 17 Aug 2021 21:33:05 GMT

Hi Everyone.

I have a PostgreSQL on a On premise database. I need to connect the DWC to the database.

I thing it can do it by Generic JDBC.

Can anyone tell how a I need to configure and prerrequisites?

Kind regards

Cristhian

kpsauer — Wed, 18 Aug 2021 08:39:00 GMT

Hello cristhianrios,

you can use the generic JDBC driver. How this is done is described in the documentation for the Generic JDBC connection. Make sure you have registered the adapter with SAP Data Warehouse Cloud. Hoiw you do that is described here.

The prerequisites for connections are also documented there.

In addition there is a 4 minute learning video showing all the steps using the generic JDBC Adapter.

Best regards
KP Sauer

Cristhian_Rios — Mon, 25 Oct 2021 14:02:54 GMT

Hello Klaus.

I used de the JDBC driver and the connection works.

Thanks.

Kind regards.

tejas_hatwalne — Wed, 17 Jul 2024 07:27:41 GMT

Hi kpsauer,

Can we do Pull and push data from PostgreSQL(MDO)(Cloud) to SAP Datasphere? with JDBC or any other way?

Kind regards

Tejas