Purpose of the different Data Warehouse users
I need a clarification about the function of the different users that must be provided when configuring the Data Warehouse.
In the jts/setup page for the DWH, I must provide 3 different users:
In particular, I need to know:
In the jts/setup page for the DWH, I must provide 3 different users:
- a JDBC (database) user;
-
a Custom Report Database user;
- a data collection user;
In particular, I need to know:
- which are LDAP users and which are not?
- which are CLM users and which are not?
- which users need a CLM license, and which license?
- is the Custom Report Database user needed only if I use RRDI)? If I use JRS, do I need it?
Accepted answer
Hi Luca,
Please let me know if that helped.
-
JDBC and Custom Report Database User are the users defined in your database. They are created during creating CLM databases. JDBC user is the user having more permissions. It is used during database creation and upgrades. Custom Report Database User has the one with less permissions and is used in reporting solutions to avoid, due to security reasons, using database administrator. You can use it in both RRDI and JRS.
-
Data Collection User is a functional user. It is created during a setup. He does not need to be in ldap and the license should be automatically generated during a setup.
Please let me know if that helped.
Comments
So, summarizing:
- JDBC is used during the initial setup of the DWH data source; it formats the DWH database and creates the tablespaces;
- Custom Reports Database User is used by RRDI and JRS to read and write in the DWH data source;
- Data collection users is used by ETL (and DCC also?) to collect data from the CLM databases and write them in the DWH data source
Thanks.
Hi Luca,
Yes, that is correct.
1 vote
Thanks for the information.