NOTE: Direct VPN and Database access to the backend database will only be provided for Dev environments at this time. Recommendations for non-Dev environments are listed below.
Dev Environments:
to allow read-only access to Clarity data for non-production environments. No more than 5 concurrent accounts may be granted. Accounts unused for one year may be terminated, after which time a new request to reactivate accounts may be submitted.
To request VPN access on the support portal, select the Manage VPN Accounts option:
...
The Raise a Ticket screen will appear. Fill out the fields as follows:
Summary: Specify that a new access is required
Description: Be sure to include the following information:
- Email Address and Name of the User
Environment: The URL of the non-PROD environment you require Database database access toAfter the fields are filled out, click Send. A case will be create and a support agent will assist you in the process to obtain the key file necessary for VPN access to the database.
For further information about setting up a VPN, use this Article: How to Set up AWS VPN Access to Non-Prod Oracle Databases
NOTE: No more than 5 concurrent accounts may be granted. It is the responsibility of your organization to reach out to Rego to request the deactivation of any user no longer working with you.
...
Rego is not responsible under any conditions for the governance of the provided credentials.
Options to access data in PROD environments:
Recommendation #1:
http://xogbridge.com. Rego recorded an internal demo on this in 2019: https://web.microsoftstream.com/video/1c26e5af-d922-4db4-8af8-aebeeeaea927
Recommendation #2:
RegoXchange has a technical note named “Clarity PPM SaaS JDBC…” that details how to run queries via the Jaspersoft server using a Jaspersoft driver. The link to this is: http://regoxchange.com/show/1130/