PKWARE has given us the confidence we need to rapidly innovate while maintaining compliance.
During ARI’s proof of concept (POC), PKWARE ran data discovery tasks across ARI’s databases to ensure the tool was capable of identifying the sensitive data to mask. Data discovery identified over 2,000 columns within each database, for a total of 8,000+ columns across all three (3), that would potentially require data masking.
Once data discovery was complete, the next step was to review the tool’s findings from a business context and further refine the list of fields to those that required masking according to ARI’s masking standards. The tool was then configured to mask the existing data within ARI’s databases. This process was completed over an agreed-upon timeline of two (2) months. Upon completion, the masking implementation was tested and verified by the ARI team to ensure execution met their functional requirements and operational time windows. For the next, and final step, PKWARE helped automate the process by constructing scripts, which the ARI team then used to integrate the custom masking tasks into their normal operations as new data gets added to their databases.
For Custom Functions
PKWARE Professional Services team built custom functions in Oracle PL/SQL, conforming to PKWARE standards for solving custom masking use cases. The custom masking provides ARI with the ability to accomplish masking without negatively impacting the efficiency of existing development and testing activities. The speed of customization allowed ARI to maintain forward progress toward its masking goals in a very aggressive timeframe.
For Building Tasks
PKWARE Professional Services team built a custom Python script, which reads an ARI-prepared file containing details of the data columns requiring masking, such as data type, length and sensitivity classification, then generates JSON task definitions. The custom script then picks up the JSON outputs file and creates tasks from them via DGCL using a custom command.
For Automated Execution
PKWARE Professional Services team also assisted ARI with scripts for a fully automated, hands-off solution. Below are some of the automated solutions provided:
- Custom Invocation: Configurable listing to invoke PKWARE for tasks associated with JSONs and names/IDs
- Automatic Execution: Tasks start sequentially from the given listing
- Automatic Polling: PKWARE polling to check the status of running tasks(s)
- Graceful failure handling: Automatically fetch logs, read target PKWARE tables, compile, and notify via email alert
- Notifications: Email notification with detailed results of execution and log file
PKWARE’s solution provided tremendous value to the ARI team, especially when contrasting them against building an in-house solution and other available options on the market.
PKWARE provided more sophisticated functionality, monitoring, and consistency across systems in less time when compared to in-house development options. In turn, going with PKWARE also allowed ARI to avoid diverting precious development resources from client-facing project work.
Compared to other solutions on the market, PKWARE’s implementation time, flexibility, and cost helped ARI conclude their decision. Here is more specific detail on each of these areas:
PKWARE handled the initial product implementation time in a couple of months. The tool required minimal training and infrastructure resources. Combined with its runtime efficiency, this product imple-mentation was a quick success in ARI’s environment.
PKWARE easily supported customizations and works across disparate databases. While the project was initially envisioned to scan and run masking tasks on three (3) databases separately, PKWARE’s in-house custom solutions surpassed expectations by providing ARI with an automated solution, which is now fully integrated into their operational workflow.
Compared to ARI’s other options, in-house development or competing vendors, PKWARE provided the best economic choice. PKWARE’s cost value allowed ARI to focus on its core business without massive investments in time and resources, while still accomplishing the critical objectives of protecting sensitive data.
In addition to implementation time, flexibility and cost, team members, including DBAs, development and operations team members, can leverage the PKWARE-ARI Fleet implementation as it continues to develop its applications, enabling them to efficiently utilize the data while ensuring proper data privacy measurements are in place. PKWARE’s cost value allowed ARI to focus on its core business without massive investments in time and resources while still accomplishing the critical objectives of protecting sensitive data.