function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Hartley WaggenerHartley Waggener 

PULLING data from Salesforce to HIPAA compliant MS SQL DB

Looking for recommendations on the best way to set up a secure interface to PULL data from Salesforce into a MS SQL database.  Most of the solutions available seem to be regarding pulling data INTO Salesforce from outside SQL databases.  Because we are operating under HIPAA laws, we would prefer to have the PULL on the database side, has anyone setup a connection like this previously? 
We use Pragmatic Works Task Factory to extract SF Data into SQL. Nice tool because it can be used for more than just pulling data from one system to another and the cost is reasonable.
Adrian KunzleAdrian Kunzle
DBAmp is hands down the most popular (from a volume perspective) software for taking backups of Salesforce and putting them into SQLServer. Dataloader can also do the job, but is not necessarily the most modern of tools.
Many other integration tools that you may already have can also do the job; like Mulesoft, Jitterbit, Informatica, SoftwareAG, Dell Boomi etc.
Andrew Mills 8Andrew Mills 8
Hartley, Did you find a HIPAA compliant solution? I have the same requirements.