2171592 - What's the process to set up REPORT_DEVELOPER Role and VJDBC Setup to enable the use of Plateau Report Designer?

SAP Knowledge Base Article - Public

2171592 - What's the process to set up REPORT_DEVELOPER Role and VJDBC Setup to enable the use of Plateau Report Designer?

Symptom

This KBA covers how to connect to data via the Plateau Report Designer (PRD)

Environment

  • SuccessFactors Learning Management System (LMS) - All Supported Versions
  • Plateau Report Designer (PRD)

Cause

  • In order to create reports using the Plateau Report Designer (PRD) Read Only access to the database is needed
  • To connect to the data source via Plateau Report Designer, the VJDBC connection (Virtual Java Database Connection) needs to be deployed
  • The output of the VJDBC connection in LMS UI is an admin role called REPORT_DEVELOPER deployed by SuccessFactors during the VJDBC connection set up process
  • This role REPORT_DEVELOPER can be requested by creating a Customer support Incident with the Success factors LOD-SF-LMS-PRD component. Don't forget to provide the LMS STAGE URL
  • This role is different from the roles created through the LMS UI since it requires certain database connections open for it which can only be completed by SuccessFactors

Resolution

Important Notes:

  • Only one VJDBC connection per customer will be deployed
  • This connection is only deployed for non-production instances to mitigate negative impact to Production Performance

To request the VJDBC connection set up:

  1. Open a support incident with SAP Cloud Product Support and include the following detail:
    • Environment the request is for (non-production such as test or stage)
    • Timeframe needed by (please note the request may take 1-2 weeks to complete)
    • Reference this KBA
  2. Once the VJDBC connection is set up, the REPORT_DEVELOPER role is added to your SuccessFactors Learning staging environment
    • Important:  Before accessing the data source, the REPORT_DEVELOPER role must be assigned to the admin account
    • Please review the "Setting up a Plateau Report Designer Account" User Assistance Documentation on assigning the REPORT_DEVELOPER role
  3. Use parameters similar to below to build the data source connection:
    • Review Downloading Learning Report Designer Documentation for accessing the PRD
    • Driver Class:  de.simplicit.vjdbc.VirtualDriverBirtWrapper (v1.6)
    • Database URL: jdbc:vjdbc:servlet:https://CUSTOMERNAME-stage.plateau.com/vjdbc/vjdbc,db10g (look this up in the Operations Customer Support information page)
    • User Name:  Staging Admin ID (in this case, HOSTING) with REPORT_DEVELOPER role
    • Password:  Associated password
    • JNDI URL:  <LEAVE BLANK>

      prd connection.JPG

  4. Click "Test Connection" to ensure connection is working

See Also

How to configure PRD to connect to the Hosted Staging database through a Proxy

Setting up a Plateau Report Designer Account

Downloading Learning Report Designer

Keywords

SF Success Factors, SuccessFactors, LMS, Learning Management System, PRD, VJDBC, REPORT_DEVELOPER, plateau report developer, develop, connect, data source, datasource, design, designer, create, connection, database, db JDBC , KBA , LOD-SF-LMS-PRD , Plateau Report Designer , LOD-SF-LMS-REP , Reporting Data , How To

Product

SAP SuccessFactors Learning all versions