Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Digging data of OpenEdge 11 multitenant databases #7

Open
BernhardZuba opened this issue Jun 22, 2017 · 1 comment
Open

Digging data of OpenEdge 11 multitenant databases #7

BernhardZuba opened this issue Jun 22, 2017 · 1 comment

Comments

@BernhardZuba
Copy link

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
Copy link
Owner

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 :)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants