Postgresql CDC Question

[KArthur]

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!

[datacoffee · Accepted solution]

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

[KArthur]

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

[datacoffee]

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 😊

[KArthur]

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