Search code examples
symmetricds

How to let SymmetricDS filter data load by externalId of target engine

I'm using SymmetricDS 3.7.

What I want to do is, make SymmetricDS only send data to the client engine, if the external Id of the target node equals a column in the table (multi tenancy). This means, that on server I want to have all rows, but on client side only those ones that belong to the client.

I found out, that I have the engine object in my beanshell script. But it seems as if this is the server (sender) node and not the client engine instance.

How can I achieve this?

Solution

  • use the column match router as explained in the user guide: http://www.symmetricds.org/doc/3.7/html/user-guide.html#_router_types

    have a column in the table that is synced to target machines with value which matches the externalId of the target machine