search

patrickTingen / DataDigger

A dynamic dataviewer for your Progress / OpenEdge databases
https://datadigger.wordpress.com/
MIT License
50 stars 23 forks source link

Digging data of OpenEdge 11 multitenant databases #7

Open BernhardZuba opened 7 years ago

BernhardZuba commented 7 years ago

First of all: Thank you for this amazing helpful tool!

One thing that I am actually missing is the support of OpenEdge 11 multitenant databases. To access the shared and tenant dependent data. Is there a plan to support this?

At the moment I have written the following workaround before starting the "DataDigger.p": I have changed the DataDigger.pf from "-p DataDigger.p" to "-p tenantcheck.p"

The "tenantcheck.p" consists of following code:

define variable h-superUsrPwd-c as character no-undo.

if is-db-multi-tenant(ldbname(1)) = yes then do: h-superUsrPwd-c = string(base64-encode(message-digest("SHA-512", "ChooseASecurePWD"))). setuserid("SuperUserName@SuperUserDomain", h-superUsrPwd-c, "DBName"). set-effective-tenant("ChooseYourTenantHere"). end.

run DataDigger.p.

This solution is not that comfortable because I always have to adapt the tenantcheck.p to set the wanted effective-tenant. It would be cool if I could connect with a super user and choose the wanted tenant from the DataDigger itself.

patrickTingen commented 7 years ago

Hi Bernhard, thanks for using the DataDigger. With regard to the MT question: I have to admit that I have no experience with it. I would have to dive into this. So on the short term, there are no plans to implement this, but if you can come up with a good solution, I would love to include it with a next version :)