XOG & Query Bridge

CA Clarity PPM Tools  - XOG & Query Bridge

Business Challenge

Mass data inserts, updates or extractions with CA Clarity PPM is a challenging task for those that are not programmers or PPM developers with the right tools. Even those who are technically inclined must be XOG and NSQL query experts to be able to perform these tasks.  

Running large numbers of XML files is also very time consuming as they can only be done one at a time, making the process very  resource intensive. 

CA's XOG API and Query API are robust and comprehensive tools to perform mass volume data operations with CA PPM.  However, they are typically "command line" operations with no GUI and other useful XOG tools and functionalities that help the user avoid and reduce time-consuming cumbersome tasks.

Solution Details

XOG & Query Bridge (XQ) is a free to use CA PPM toolset that provides a GUI built on top of the XOG API and Query API. XQ makes your XOG and Query related tasks vastly simpler and quicker to perform, eliminating the need to tackle command line type operations.

By leveraging this GUI, a wider audience of PPM users are now able to take advantage of CA's XOG API and Query API, giving them the ability to perform all their PPM related tasks in a more controlled, intuitive environment that wasn't previously available.

XQ is the leading XOG and Query CA PPM tool with numerous features and highlights: 

  • An user-friendly GUI that enhances the user experience and shortens the learning curve for non-savvy XOG users.
  • Perform XOG webservice operations and run SQL queries on CA PPM environments.
  • XSLT Data Loader tool to transform XML documents.
  • Support to execute data requests for both on-demand and on-premise CA PPM implementations.
  • Web-based and desktop versions available.
  • Ability to create mass data requests based in a datasource file.
  • Ability to run single and bulk XOG requests.
  • Execute existing queries so data extractions / exports to Excel have no size limitations.
  • Historical execution reports of the status of each run.
  • Optional notifications by email that alerts users once their requests have been processed.
  • Maintained and supported by IT-ROI Solutions.
  • Integrated with the IT-ROI integrations framework.

Business Roles and Challenges

ca-ppm-admin.pngCA PPM Administrator


> Mass Changes

Due to to a recent aqusition, all email addresses in CA PPM needed to be updated to meet the new naming standard. This task was very easy to get done. We used the Query bridge to extract the information into Excel so it could be modified by another department, then it was uploaded to CA PPM using the data loader XQ provides.

> Data Loads

Your organization just acquired a company who uses MS Project Server and you need to move your project data from MSP to CA PPM. The steps that were performed were the following, the data was extracted from the source system to MS Excel then the XOG & Query Bridge Data Loader tool was used to map the values to XOG and load to CA PPM.

> Migrations

During implementation, moving information from the development environment to the test environment has never been an easy task for our team, we had to deal with a command line client and file paths/names, a manual process to say the least. With XOG & Query Bridge, we are now able to submit one bulk request to retrieve the data, and since you get the result in a ZIP file, we just need to re-upload it and switch the environment, and done, all in a few clicks.

To see how this multi-step process is done, please contact us for a free and personalized demo.

Get a Demo now

ca-ppm-project-manager.pngPower User

> Data Extracts / Reporting to Excel

Constantly and desperately looking for access to the CA PPM database days are over for me. When the CA PPM lists don't give me the information I need, I use XOG & Query Bridge to retrieve the required data for my reporting. I can even use it to build a pivot table in Excel to aggregate, slice and dice, and present the data. In fact, I don't need to build the same query twice, I can go to the existing queries tab and run it as many times as I need.

Contact us for a personalized demo for Power Users who want to take their skills to the next level.

Get a Demo now



XQ Overview

MP4 version

PPM Excel Interface Webinar Replay Video


Contact Us