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 MoranView original