# Question on running DBAmp remotely

**URL:** <https://community.cdata.com/t/question-on-running-dbamp-remotely/1097>\
**Category:** CData DBAmp\
**Tags:** azure-sql, question, salesforce, dbamp\
**Created:** [May 23, 2025, 1:47pm UTC](https://community.cdata.com/t/question-on-running-dbamp-remotely/1097 "2025-05-23T13:47:12Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![arijit1001](https://avatars.discourse-cdn.com/v4/letter/a/e36b37/32.png) [@arijit1001](https://community.cdata.com/u/arijit1001)\
**Post date:** [May 23, 2025, 1:47pm UTC](https://community.cdata.com/t/question-on-running-dbamp-remotely/1097/1 "2025-05-23T13:47:14Z")

</div>

Hi Everyone,

I have a scenario to use&nbsp;Azure Managed SQL Instances and these&nbsp;are not supported for DBAmp because they do not allow the installation of 3rd-party linked servers on the Instance. So I am trying to install dbamp remotely -&nbsp;to a on-prem SQL server virtual machine.

We will create a Azure SQL managed instance where data will be stored. - DBInstance

DbAmp will be configured as linked server&nbsp; in a on premise virtual machine with SQL server installed. - DBAmpServer

I have two questions:

1. Can we run DBAmp from&nbsp;DBAmpServer to move the data from&nbsp;DBInstance to&nbsp;Salesforce? The article&nbsp;[DBAmp - Running DBAmp Remotely (cdata.com)](https://cdn.cdata.com/help/AFH/dbampd/SF_RunRemotely.html)&nbsp;mentions the other way around, but we need a bi-direction data transfer between&nbsp;DBInstance and Salesforce.
2. The article mentions that a subset of stored procedures will be available. Can you confirm if that subset includes all SPs needed to transfer data between SQL tables and Salesforce standard &&nbsp;custom objects as well as extracting error logs to DBInstance from Salesforce Bulk API logs.

---

<div class="post-metadata">

**Author:** ![Dani\_Moran](https://avatars.discourse-cdn.com/v4/letter/d/2acd7d/32.png) [@Dani\_Moran](https://community.cdata.com/u/Dani_Moran)\
**Post date:** [June 13, 2025, 1:18pm UTC](https://community.cdata.com/t/question-on-running-dbamp-remotely/1097/2 "2025-06-13T13:18:03Z")

</div>

1. Absolutely! SF\_TableLoader is one of that subset of stored procedures that are supported for remote usage, and SF\_TableLoader takes a staging table in the remote instance, and pushes it up to Salesforce. You can read more about that one here:&nbsp;[DBAmp - SF\_TableLoader](https://cdn.cdata.com/help/AFH/dbampd/SF_TableLoader_remote.html)
2. You can see the list of supported stored procedures here:&nbsp;[DBAmp - Remote Stored Procedures Reference](https://cdn.cdata.com/help/AFH/dbampd/SF_RemoteStoredProcReference.html)&nbsp;That does include SPs for moving data from Salesforce (no difference between standard and custom objects as far as DBAmp is concerned!) and as I mentioned above, moving data to Salesforce.
  1. As for the Salesforce Bulk API logs, regardless of API you use, DBAmp stores the response from Salesforce when running SF\_TableLoader in the \<staging table\>\_Results table, which will be written in DBInstance.

Note that all commands/queries will be run on the DBAmpServer, as they will need to use the DBAmp application! The data is getting moved to/from the DBInstance, but DBAmp is always interacted with on the DBAmpServer.