DataDigger
DataDigger copied to clipboard
Digging data of OpenEdge 11 multitenant databases
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.
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 :)