topic Re: Postgresql CDC Question in Eventstream

Postgresql CDC Question

KArthur — Mon, 14 Apr 2025 16:29:40 GMT

Hi everyone,

New here. Hoping to get some help.

I've established a connection to our servers successfully (at least it says successful)

However, when I go to use this connection as a Data source in Eventstream via PostgreSQL DB (CDC), Create EventStream is successful but Create EventStream Source gives an error message: "Property 'username's value '' is invalid Artifact ID: eb89e4f5-fbb6-4b10-b4f6-94947883a8ae Action: createEventStreamSource Type: AzurePostgreSql"

My connection to the sql server appears to have the right username and pw configured so I'm not quite sure what I'm doing wrong or how to fix it. Any help would be greatly appreciated!

Re: Postgresql CDC Question

KArthur — Mon, 14 Apr 2025 17:38:00 GMT

Come to think of it, can it be a local server's Postgresql or does it have to be one hosted in the cloud?

Re: Postgresql CDC Question

datacoffee — Mon, 14 Apr 2025 17:59:02 GMT

Right now you can only connect to a cloud hosted server. 😊

Re: Postgresql CDC Question

KArthur — Mon, 14 Apr 2025 18:26:15 GMT

Thank you! Any tips on getting around that other than moving into the cloud?

Re: Postgresql CDC Question

datacoffee — Tue, 15 Apr 2025 06:27:07 GMT

Unfortunately there is no getting around it. It is the connectivity from on-prem to cloud which is the problem for streaming.
I think you would be able to bulk load it with a on-prem data gateway and a pipeline or dataflow in Fabric. It will not give you the benefits of the faster load from the CDC proces, but you will get the data to Fabric and can begin to work with it from that point 😊