About EasyMorph Tutorials & Examples Web-help

Connection as parameter [DONE]


I have a project that reads from a database table and then writes back into that same database table. So I have multiple (3) transformations in one project referring to the same connection.

The thing is: with multiple clients, I sometimes need to run the transformation against one database, and another day against another database (each for a separate client, and each with the same schema). So for example if I mess up and don’t change all three transformations’ connections above then I am hosed (for example perhaps reading from one clients’ database but writing back into another client’s database).

I also have multiple EasyMorph projects that I need to run for any client. Around five total, and they aren’t just run in serial but in a fairly ad hoc manner to explore the data.

So I have lots of moving parts that I really don’t want to mess up when switching between clients.

The bottom line: I need to have a text parameter that can then be used for an input from database where the connection be a parameter. This would allow me to set the parameter once (per project — so still I would need to do it in five places and switching between clients would be error-prone) and then I can switch between clients more effectively.

One way of handling this would be to have a multi-tenant database (with every single table having a column for tenant id, and then every single time I read/write from the database I only select rows with that tenant id). Then the tenant id can be the parameter that is common across projects.

EasyMorph session with global default parameters

We’re getting many requests for this and will be addressing this soon.