Questions tagged [sqlserver]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
6
votes
4answers
1k views

Is ETL/script the best way to create SQL database from SF?

At our organization we would like to set up a SQL copy of our Salesforce instance for two reasons: 1) the app we are using in Salesforce is shutting down (Common Ground) and we we want to keep a ...
1
vote
1answer
36 views

Sync without the middle layer

My company has uploaded data from the middle layer(SQL database) into salesforce. This is a one time upload. Now they have terminated the middle layer. Now they would like to keep sync between the ...
0
votes
1answer
472 views

Ampscript or SQL to limit the number of products shown per 2 distinct fields

I have a data extension with MemberKey, Location, ProductID The same MemberKey can appear multiple times, with the same Location (but with different ProductIDs). How do I restrict each each ...
4
votes
4answers
673 views

What are the best options for achieving SQL Server - SFDC integration in real time?

We have a need where we need to create a real time integration from SQL server to salesforce like a message queue. Whenever a record is inserted or updated on a sql server table, we want the data to ...
3
votes
3answers
19k views

how do i do integration between sql server to salesforce

unable to integration sql server to salesforce I want to integrate sql server to salesforce and update records in sfdc