Obfuscation of Salesforce data sources

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

There's a requirement to obfuscate Salesforce data in non-production regions. Is it possible to connect Broadcom Fast Data Maker to Salesforce and obfuscate data? What is the recommended way to obfuscate Salesforce data using FDM?

Environment

Fast Data Manger 4.10+

Resolution

Unfortunately, Salesforce isn't a supported data source at this time. Please refer to the:

• TDM 4.10 Supported Data Sources
• TDM 4.11 Supported Data Sources

Please see TDM and Salesforce Community Post, which contains a PDF file discussing how to set up a demo between TDM and Salesforce.

Reviewing the PDF file, it seems the only solution available, at this time, is to export the Salesforce data to a CSV file, use FDM to mask the CSV file, and then import the data from the obfuscated CSV file back into Salesforce.