Skip to main content
Solved

Installing Dbamp Remotely

  • October 11, 2023
  • 2 replies
  • 253 views
S
Forum|alt.badge.img

Hi Everyone,

I have a scenario to use Azure Managed SQL Instances and these 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 - DBAmp - Running DBAmp Remotely (cdata.com)

Client have created 2 servers one where data will be stored - dbSever

Two where dbamp will be configured as linked server - dbampServer

Data Scenario - Data will be storing in Ddrive so I am using SSIS to push the data into SQL server I have created package and deploying that package to both dbserver and dbamp Server

So my question is in the article it says to create remote database  “Salesforce Backups” in remote server instance to hold the salesforce data but can’t we store the same data in dbamp server? Is there any security concern or limitation if we store Salesforce data in dbamp server?

 

Best answer by Dani Moran

You certainly can store the data in the dbampServer without issues (unless you have your own internal issues with that!). What you are describing doesn’t actually make use of the DBAmp remote feature however, though it is a perfectly viable way to get the data to the system you want!

 

The page you linked https://cdn.cdata.com/help/AFH/dbampd/SF_RunRemotely.html is specifically for those situation where someone does not want the data to ever live in the server local to DBAmp (the one you call dbampServer). If you are fine with it sitting there as well, you can certainly use SSIS to push it to an Azure Managed SQL Instance, but that doesn’t require DBAmp’s remote feature.

    This topic has been closed for replies.

    2 replies

    S
    Forum|alt.badge.img
    • Srilatha
    • Author
    • Apprentice
    • October 11, 2023

    If anyone of you already installed dbamp remotely please feel free to reach out to me here -- [email protected]m we can discuss clearly 

      D
      Forum|alt.badge.img
      • Dani Moran
      • Employee
      • Answer
      • November 10, 2023

      You certainly can store the data in the dbampServer without issues (unless you have your own internal issues with that!). What you are describing doesn’t actually make use of the DBAmp remote feature however, though it is a perfectly viable way to get the data to the system you want!

       

      The page you linked https://cdn.cdata.com/help/AFH/dbampd/SF_RunRemotely.html is specifically for those situation where someone does not want the data to ever live in the server local to DBAmp (the one you call dbampServer). If you are fine with it sitting there as well, you can certainly use SSIS to push it to an Azure Managed SQL Instance, but that doesn’t require DBAmp’s remote feature.

        State of AI Data Connectivity Report: 2026 Outlook
        Terms and ConditionsCookie settingsAccessibility statement