Using Test Data Manager (TDM) with Saleforce

Products

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

Issue/Introduction

We have a need to mask PII/PHI data from Salesforce while being copied to sub production environments for testing.
Can CA TDM 4.9.x support SalesForce data masking?

We recently were tasked to answer an RFP from a customer who, besides wanting to perform TDM operations on their
Mainframe, Distributed, and noSQL databases, wanted to have consistency with their Salesforce.com sandbox data.  

Environment

TDM Portal 4.9.X
DataMaker 4.9.X

Cause

TDM doesn't have Salesforce on its support matrix,

Resolution

As TDM doesn't have Salesforce on its support matrix, we created a demo using the Salesforce DataLoader export/import utility.  

I've attached a runbook that details how to set up a demo of Synthetic Data Generation and Masking for a Salesforce "Contact" entity as an example.  
If you have Salesforce data requirements or wish to see how TDM might be configured with a DataSource that can only be accessed via an import/export utility, this document may be useful as an example.

Additional Information

Originally posted in the communities here:
https://community.broadcom.com/enterprisesoftware/communities/community-home/digestviewer/viewthread?GroupId=1825&MessageKey=7ba9c9ce-f020-4cbc-b43b-6d7f2c849bff&CommunityKey=909e0526-d8ad-455d-97eb-aa009df5d3aa&tab=digestviewer&ReturnUrl=%2fenterprisesoftware%2fcommunities%2fcommunity-home%2fdigestviewer%3fcommunitykey%3d909e0526-d8ad-455d-97eb-aa009df5d3aa%26tab%3ddigestviewer

 

Possible Error:
I have followed all the steps as mentioned but while connecting to Salesforce via dataloader, I am getting below error.
"Failed to send the request to https://login.salesforce.com/services/Soap/u/49.0"

Possible Solution:
a quick search seems to indicate the most common situation is that your organization uses a proxy server.   You must specify that information to connect.
ex:  https://trailblazers.salesforce.com/answers?id=90630000000Cy3iAAC