One SyncAgent, multiple clients, is this possible?

[badsyntax]

Hi. I'm evaluating using this library for data sync.

We have a multi-tenant application, where each tenant/client has their own database. We have one API service that serves all tenants.

We have some common data that we'd like to sync into each tenant database.

I've had a read through the Multiple Client overview but it seems those docs are targeted towards clients having their own servers. Conceptually we only have 1 server. The docs mention And each client will have a sync agent, responsible of the sync process. We can have N tenant databases, so we need to be able to dynamically configure the sync.

Ideally we'd only like one sync agent, that can sync to multiple clientProviders. Is this possible? If not, do you have any advice on how to sync to a non-static list of multiple clients? Thanks in advance.

[Mimetis]

Conceptually we only have 1 server

That's good. 1 server and multiple clients. Classic scenario I guess

We can have N tenant databases

On the client side ?

Ideally we'd only like one sync agent, that can sync to multiple clientProviders

A sync agent ist just an object who knows the server and the client.
You can create as many SyncAgent as you want, on your local client.

[badsyntax]

We can have N tenant databases

On the client side ?

Yes. There's only one "server" db that holds "common data". Each client/tenant has their own database. We want to sync the common data to each client/tenant database.

Ideally we'd only like one sync agent, that can sync to multiple clientProviders

A sync agent ist just an object who knows the server and the client.
You can create as many SyncAgent as you want, on your local client.

Great, thank you. I'll create a POC and let you know if I have any difficulties.

[badsyntax]

Just want to say everything is working out great, and thanks for the useful library, it's solved some problems we had.

[VagueGit]

We use the token in the HttpClient header to identify the user. Then configure the connection string to the server database in SyncController.Post

[badsyntax]

Thanks, I'll explore using the web proxy to see if i'll make this easier.

[AndyVu2311]

I got the same requirement and i'm working on it. Can you show more detail of the solution @VagueGit.

[VagueGit]

On the client we use this overload where the headers of httpClient carry some token that identifies the user
WebRemoteOrchestrator webRemoteOrchestrator = new WebRemoteOrchestrator(serviceUri, client: httpClient, maxDownladingDegreeOfParallelism: 4); Refer Http Mode

The SyncController reads the headers to identify the user and configures the connection string for that user like this
webServerAgent.Provider.ConnectionString = ...; Refer Server Side