Whenever I work with customers code there is almost always a need to “run” their applications. That means I need data. To ensure that Synergex protects our customers data and that we conform to the various data security requirements of todays world there is usually a need to cleanse the data before I get access to it. This cleansing process is like redacting words or phrases in a document – to prevent the consumer (in this case me) from seeing the real data.
With Synergy today there are basically two ways to do this; write a program to clear or set the data fields within the records in the file to a specific value or configure Synergy xfODBC and use a database management tool. If you don’t want to write code, or license and configure xfODBC you can use the Synergy DBMS Manager.
The Synergy DBMS Manager is a simple utility that can be used to redact data in your Synergy DBMS files. Your can download and install the Synergy DBMS Manager utility by visiting the downloads page. The utility uses Symphony Data Objects to describe the data in your files – these are easy to code generate.
Code generating Symphony Data Objects for your files is a simple process. Ensure you have your Synergy Repository configured. You need to define the structure and associated file definition for each file you wish to be able to manage using the utility. There are full instructions which walk you through the few simple steps to building your data object assembly in Synergy .Net. Not sure how to build Synergy .Net assemblies – then send me your repository and I’ll do it for you!
Once you have the data object library built, you simple run the utility:
You’ll need to locate the “Data object assembly” that you have just built, and following that select the “Table mapping method”. Enter the password and you’ll be in the utility and ready to manage your Synergy DBMS data.
You can perform simple queries to locate and review the data in a file;
Now you can easily redact the data in the file – remember you are affecting the ACTUAL data in the file, so make sure this is a copy of the data file and NOT your LIVE data, there is no rollback functionality!
Simply issue an update command;
Notice the result count () at the bottom of the screen. Because we didn’t specify a where clause then all records in the file were affected by the requested update. Now you can perform a simple query and see the results;
This data is now cleaned. If you need to send data to Synergex Support to assist then to resolve an issue you have, this is a great way to redact and protect that data before sending it.
If you’d like more details, please visit the Symphony Framework page or contact me directly.