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
Wagner R. Landgraf View Drop Down
TMS Support
TMS Support
Avatar

Joined: 18 May 2010
Posts: 2365
Post Options Post Options   Quote Wagner R. Landgraf Quote  Post ReplyReply Direct Link To This Post Topic: Database multi-tenancy
    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
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 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
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down