Replica

, ,

Easily pull full replication of Salesforce data into your SQL Server Database by running a simple T-SQL command.

Examples of use

exec ss_Replica 'DEMO', 'Account'
exec ss_Replica 'DEMO', 'Case(25)'
exec test.ss_Replica 'DEMO', 'TestObject__c'

Features

  • Full unlimited schema support within the same Database (not reliant on having to use dbo)
  • Specify Batchsize
  • Optionally include Soft Deleted (isDeleted = 1/True) records and Archived (isArchived = 1/True) records
  • Specify subset of Columns
  • Specify subset of Records / spot check preview (top) feature
  • Optional SOQL filters possible
  • Define custom replication tables
  • Special support for ContentDocumentLink
  • Base64 fields and Content Model support
  • Choose Boolean fields as string, varchar(5) (True/False) or bit (1/0)
  • Standard, History, Custom (__c) Historical Data (__hd) & MetaDataType (__mdt) object and field support
  • Failover from ss_Delta (Delta Replication) option
  • Default SQL-Sales BULK or ODBC connection options from client SSMS to SQL Server
help article