Web forum is in read-only mode. Login as active registered customer for write access
  Forum Search   New Posts New Posts

Database multi-tenancy

 Post Reply Post Reply
Author
DA CUNHA MARCO A View Drop Down
New Member
New Member
Avatar

Joined: 15 Dec 2011
Posts: 23
Post Options Post Options   Quote DA CUNHA MARCO A Quote  Post ReplyReply Direct Link To This Post Topic: Database multi-tenancy
    Posted: 05 Jun 2018 at 12:07am
   Reading the uses cases we have:
  • You might have a distributed system where you need a central database server with all data for static purposes, but each client will only have access to a subset of that data (multi-tenancy architecture)

    I will have a central database and each  customer  will see only their. own data. 

    Can Echo handle that ?

     Client A,  with a desktop application and 3 mobiles devices  replicating to the central database   

     Client B,  with a desktop application and 5 mobiles devices  replicating to the central database

     So,  I could have a multi-tenancy database using Echo.

     Is it ok ? If so how is the proper way to implement it ?

     Thanks
     
Back to Top
Wagner R. Landgraf View Drop Down
TMS Support
TMS Support
Avatar

Joined: 18 May 2010
Posts: 2022
Post Options Post Options   Quote Wagner R. Landgraf Quote  Post ReplyReply Direct Link To This Post Posted: 05 Jun 2018 at 1:28pm
Yes, it's possible. You have to add your own routing logic when calling Route:

The key is the anonymous method in the Route parameter:

Echo.Route(
    procedure(Log: TEchoLog; Node: TEchoNode; var Route: boolean)
    begin
      if SameText(Log.EntityClass, 'AppEntities.TEchoInvoice')
        and (Node.Id = 'Client1') then
        Route := false;
    end;
);  

You have to implement your own logic to tell Echo if that specific record should be routed to that specific node.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down