jaspersoft DB tables name

Products

• CA Privileged Access Manager (PAM)
• CA Privileged Access Manager - Cloakware Password Authority (PA)
• CA Privileged Access Manager - Server Control (PAMSC)

Issue/Introduction

Kindly provide tables name detail where datas are stored in jaspersoft report server

In which tables users information going to be store?

 

Environment

Release : 14.0

Component : PAM SERVER CONTROL ENDPOINT WINDOWS

Resolution

"Jaspersoft haven't provided any information on those tables. It may be because they change schema between releases so they don't want users accessing them directly. Jaspersoft have provided REST APIs to do most operations so it's really not necessary to access database directly."

See:

https://community.jaspersoft.com/questions/977021/jasper-schema-information-jasperserver561

Broadcom does not support accessing the database directly.

For the rest api, see:

https://community.jaspersoft.com/documentation/tibco-jasperreports-server-rest-api-reference/v630/rest-api-overview

Here is an example of creating a user with the rest api:

https://community.jaspersoft.com/documentation/jasperreports-server-web-services-guide/v550/creating-user#:~:text=To%20create%20a%20user%20account,username)%20specified%20in%20the%20URL.&text=In%20the%20community%20edition%20of,first%20form%20of%20the%20URL.