Excel Data Manager
Actionable Insights to Boost Performance
Edit, validate, extract, and send large data sets to CA PPM (Clarity PPM) with Microsoft Excel.
Stand alone and Enterprise Editions Available. The Enterprise edition includes the Integration Manager for enhanced auditing and administration capabilities.
Manage Data for 20+ Objects Out-of-the-Box
Applications
Assets
Change Requests
Companies
Ideas
Incidents
Issues
Locations
Others
Products
Programs
Rate Matrix
Release Plans
Releases
Requirements
Project Teams
Resources
Risks
Roles
Services
Skills
Tasks
Users
Resources
Update Records in Bulk – with Full Lookup Support
Standard versus Enterprise
| Feature | Enterprise | Standard |
|---|---|---|
| Works completely stand-alone, connects directly to CA PPM (Clarity). | X | |
| Works without the need to provision additional infrastructure. | X | |
| Extract data from CA PPM (Clarity) and process it using Microsoft Excel. Edit, validate, and send the data to CA PPM (Clarity). | X | X |
| Includes sample interfaces for often used objects and attributes. More than 800 out-of-the-box CA PPM (Clarity) attributes. | X | X |
| Audit engine to trace and keep track of all data requests and the related user information. | X | |
| Ability to re-run a request immediately in case something went wrong with the previous attempt, without the need of rework. | X | |
| Requests queue to avoid major performance impact on the target CA PPM (Clarity) environment. | X | |
| Administration of different environments (e.g. Dev, Test, Prod) configuration. | X | |
| Integration with Keycloak for an enhanced user and roles administration and access control. | X | |
| Rollback functionality available for implementation. | X | |
| Managed Excel Workbook versions and distribution. | X | |
| Ability to backup the system configuration, easier portability of integrations, and Excel workbook version control. | X | |
| Integration dashboard to monitor statistics of usage, execution history, last run per integration, and data requests queue. | X |
We’ve worked with 40% of Fortune 100 companies and 60% of Fortune 20 companies, and we’d love to help you.
