SQL Figleaf: the future version of data masking

• 
  Is this public?

  paulo_morgado June 20, 2018 21:32

  - 0 +
• 
  Hi Paulo,
  
  it's not public just yet. However, we're currently doing a private beta and If you'd to participate in our beta programme please register your interest at https://www.red-gate.com/projectfigleaf
  
  Thank you,
  Sai
  
  

  sai.mohan June 27, 2018 07:29

  - 0 +
• 
  We've just released Figleaf 7.0.17.3290! This release enables the feature flag for "build your own" template masks by default, which allows creating data with a custom pattern in a straightforward manner. It can be downloaded via https://www.red-gate.com/projectfigleaf or through the autoupdate inside the product.

  Mark J June 27, 2018 17:02

  - 0 +
• 
  We are not currently in a data masking project, But one will be coming down the pike.  In the meantime I'm happy to help beta test using our DBA test shard here at the office.

  BrandonLeach July 02, 2018 20:59

  - 0 +
• 
  Just tried figleaf - really nice interface and really easy to use.  the only problem is that when I went to apply the mask it pointed out that the devs who created the database I've inherited didn't concern themselves with adding primary keys!

  ben_b July 03, 2018 09:10

  - 0 +
• 
  Hi Brandon & Ben, 
  
  Thanks for your input guys, we'll be in touch with you individually on this in due course.
  
  Kindest regards,
  
  Mick
  

  michaelwhittaker July 10, 2018 11:07

  - 0 +
• 

  ben_b said:

  Just tried figleaf - really nice interface and really easy to use.  the only problem is that when I went to apply the mask it pointed out that the devs who created the database I've inherited didn't concern themselves with adding primary keys!

  Well, the first problem is that developers created the database schema!!  LOL
  
  After that are you saying that FigLeaf requires primary keys to function or just that it helpfully points out the lack of them?
  

  TheSQLGuru July 13, 2018 20:16

  - 0 +
• 
  yep I think primary keys are required. 
  
  sometimes with data compare I run into this problem although in those situations i'm trying to compare rows on a like-for-like basis so I can add a new column and populate it using a hash function or by using a composite key.
  
  i'm guessing for figleaf a simple identity column would be fine??
  
  I think there are profiling tools / scripts out there that will suggest primary keys.  may be a nice feature to have in data compare, figleaf and prompt etc one day. 

  ben_b July 16, 2018 09:15

  - 0 +
• 
  Hi Ben. We have something in our beta that may actually address your situation. Would you be interested in having a chat with us and trying it out?
  
  

  sai.mohan July 17, 2018 08:54

  - 0 +
• 
  We've just released Figleaf 7.0.20.3670! For the past few weeks we've been looking into defining custom relationships to preserve in the database (for the cases where foreign keys don't exist) but in the meantime we've been pushing out a few releases with various bugfixes. In particular this release fixes a few quality-of-life issues with the column selection scrolling behavior

  Mark J July 23, 2018 13:54

  - 0 +
• 
  We've just released Figleaf 7.0.26.4264  You can now build up an email address based on masked values of other columns in the same table along with custom domain names

  
  

  Here's what's included in this release: 

  • Clicking on the column name in the selected column tags scrolls you to the column

  • You can now build up an email address based on masked values of other columns in the same table along with custom domain names.

  • Added a guide to running masking plans through the command-line.

  • Added confirmation checkbox to ask user if the database is in production

  • Added reassurance message when all reference columns are masked for column reference email mask

  • Added warning message for multiple selection of column reference email mask.

  • Disabled computed column selection with explanation text

  • Changed to clearer mask names

  • Added more context to SQL errors in some cases

  • The 'Save masking plan' button will now default to the existing mask plan filename if available

  Onat_M September 14, 2018 10:27

  - 0 +
• 
  We've just released Figleaf 7.0.29 You can now build conditions to skip rows within a mask.

  
  

  You can get your hands on a copy here https://download.red-gate.com//checkforupdates/Figleaf/Figleaf_7.0.29.4610.exe

  lawrence_liu October 09, 2018 15:05

  - 0 +
• 
   We've just released Figleaf 7.0.30   
  
  

   We fixed an issue where masks may not be fully applied when using constant or null masks with the 'Maintain relationships' option enabled 

  
  

  You can get your hands on a copy here https://download.red-gate.com//checkforupdates/Figleaf/Figleaf_7.0.30.4686.exe
  
  
  

  If you'd like a demo, ask a member of the Masketeers team masketeers@red-gate.com

  
  

  k_biggs October 16, 2018 13:11

  - 0 +
• 
  Is Figleaf safe to mix with other Redgate tools in my demo/test environment?

  BrianRandell October 23, 2018 04:17

  - 0 +
• 
  Hi Brian,
  Figleaf installs alongside other Redgate tools, and won't impact their operation.
  Is there a particular scenario that you are concerned about?
  

  toby.smyth October 24, 2018 08:01

  - 0 +
• 
  Thanks. No specific concern, just always worry about adding pre-release bits to my demo and ev environments.

  BrianRandell October 26, 2018 21:06

  - 0 +
• 
  We've just released Figleaf 7.0.32! We've expanded the mask conditions feature in a couple of ways - you can now switch between different mask types based on the conditions (rather than just skipping rows) and we've added a new condition type where you can specify a list of values to match.
  
  You can download the latest version at http://download.red-gate.com/Figleaf.exe

  Mark J November 02, 2018 12:14

  - 0 +
• 
  *We've just released Figleaf 7.0.33* 

  We made some changes to the command line to assist with our upcoming integration with SQL Clone

  You can get your hands on a copy here http://download.red-gate.com/Figleaf.exe

  
  

  k_biggs November 09, 2018 09:38

  - 0 +
• 
  We've just released Figleaf  7.0.35
  
  You can get a copy at http://download.red-gate.com/Figleaf.exe

  joshcrang January 22, 2019 11:21

  - 0 +
• 
  Hey @joshcrang, do you have any (even short) release notes?
  I'm curious what's new is in this version.

  KamilN January 22, 2019 21:30

  - 0 +
• 
  Hi Kamil, no user visible changes this time. We've made some back-end changes and updated some third-party libraries we use. Everything should work exactly as the previous version, so let us know if you have any problems!

  joshcrang January 23, 2019 10:28

  - 0 +

Add comment

Please sign in to leave a comment.