<div>
What are your requirements?<br />
<br />
When your source server is a SQL Server, then consider restoring the backup.
</div>


What are your requirements?

When your source server is a SQL Server, then consider restoring the backup.

<div>
Thanks for the reply @ste5an. SalesForce does not offer a .bak file download. From what I have found you can pull you entire tenant down as a bunch of .csv files. We have done this and created tables from the .csv files, but this is really ugly as it has a bunch of unicode characters in the files.
</div>


Thanks for the reply @ste5an. SalesForce does not offer a .bak file download. From what I have found you can pull you entire tenant down as a bunch of .csv files. We have done this and created tables from the .csv files, but this is really ugly as it has a bunch of unicode characters in the files.

<div>
<div class="content wysiwyg-content">
I need to perform an encrypted pull from SalesForce to an on prem SQL Server. I was reading some articles that SSIS can do this, I am just making sure that data does not come down as clear text.<br />
<br />
Is there a way to just get a single pull of all the sales force data into the on prem SQL Server and make sure the channel is encrypted?
</div>
</div>


I need to perform an encrypted pull from SalesForce to an on prem SQL Server. I was reading some articles that SSIS can do this, I am just making sure that data does not come down as clear text.

Is there a way to just get a single pull of all the sales force data into the on prem SQL Server and make sure the channel is encrypted?

How can I pull down all the salesForce objects to an on prem SQL Server over an encrypted or secure channel?

Salesforce is a Platform as a Service (PaaS) for cloud-based customer resource management that includes components for case and task management, data management and a help desk system. It also includes systems for add-on applications written in Apex, a proprietary Java-like language, and systems for human resources management, employee training and performance management.

Salesforce

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.