DataDigger icon indicating copy to clipboard operation
DataDigger copied to clipboard

Digging data of OpenEdge 11 multitenant databases

Open BernhardZuba opened this issue 7 years ago • 1 comments

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.

BernhardZuba avatar Jun 22 '17 12:06 BernhardZuba