VPN and Database alternative for GCP Clarity

book

Article ID: 197766

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

  • I used to have VPN access and Clarity database access.
  • Now the VPN service is no longer provided, I'm wondering if there is any other alternate to access the databases? 

Environment

Release : All Supported Releases

Component : CA PPM SAAS APPLICATION ACCESS

GCP SaaS

Resolution

  • We recommend customers explore the use of the OData REST API to connect to the data warehouse database for necessary reporting information.
  • In addition, the OData service will provide a WebSQL functionality that allows admins to write/test queries against the DWH schema.
    • Remember that WebSQL is for validating queries and viewing a small amount of data. WebSQL cannot be used for data extraction.
  • See the following where this information and more is referenced at: Clarity PPM SaaS Transition: Overview

Additional Information

See KB: 141061 for tips on how to optimize use of Self Service for Clarity