Setting up Elastic Marts Builder to access different TD database
I'm installing Elastic Marts Builder (EMB) - but as per installation guide, it seems you can only assign it to one Teradata database. Is there a way I can set it up so users can create EMB objects to different databases, say accounting users have access to build their tables, views etc to DB-X and marketing use DB-Y ? Our Teradata system is v12.
This is my first time I'll be using EMB, so Im just following the installion guide.
Re: Setting up Elastic Marts Builder to access different TD database
No, each instance of EMB can support one "sandbox environment" on one Teradata database. Each sandbox environment can support multiple user sandboxes.
If you want your sandbox environments to be on different databases, then you would have to install a separate instance of EMB for each of those. The product out of the box was not designed to work that way, so you would need to modify it. Thanks.