SQL-Sales: Salesforce ETL for SQL Server. All with one simple SQL line
Salesforce ETL. Simply SQL.
Overview
SQL-Sales brings Salesforce ETL directly into SQL Server. Replicate and load data and files, and extract metadata using simple T-SQL. No middleware or complex pipelines – just the SQL skills you already have.
See How SQL-Sales: Salesforce ETL for SQL Server. All with one simple SQL line Works
Full & Delta Replication (BulkAPI Supported too) Replicate Salesforce objects directly into SQL Server with one T-SQL command. EXEC ss_Replica 'Prod', 'Account' Use Delta replication to retrieve incremental changes. EXEC ss_Delta 'Prod', 'Account'
Insert, Update, Upsert, Delete & Undelete (Harddelete fully supported via the BulkAPI load operations) Load SQL Server data directly into Salesforce with one T-SQL command. EXEC ss_Loader 'update', 'Production', 'Account_INC123456_Update'
Salesforce Files, Content, Notes & Attachments Go beyond Salesforce records. Replicate and load Files, Content Documents, Notes & Attachments between Salesforce and SQL Server using the same simple T-SQL approach.
Salesforce Metadata Extraction Bring Salesforce metadata directly into SQL Server. Extract fields, picklists, relationships, picklist dependencies; Country-State definitions and much more into SQL tables, ready to query and use with familiar T-SQL.
Flexible Field & Record Subsets Replicate exactly what you need. Select Salesforce fields and filter records to create focused SQL Server replicas — reducing unnecessary data movement while staying entirely within T-SQL.
T-SQL Driven Salesforce ETL Salesforce → SQL Server: EXEC ss_Replica 'Production', 'Account' SQL Server → Salesforce: EXEC ss_Loader 'update', 'Production', 'Account_INC123456_Update' No middleware. Simply SQL.
Secure OAuth 2.0 Authentication Connect securely to Salesforce using OAuth 2.0 JWT authentication. SQL-Sales handles authentication behind your T-SQL commands — no Salesforce passwords stored.
Unlimited SQL Server Installations Licence SQL-Sales per Salesforce Production Org, not per SQL Server. Install across unlimited SQL Servers & CPUs with unlimited usage — all included within the same Production licence.
Salesforce Sandboxes Always Free Install, develop, test and evaluate SQL-Sales against Salesforce Sandboxes completely free — even without a paid Production licence. Licence SQL-Sales only when you're ready for Production.
SQL Server ↔ SQL-Sales ↔ Salesforce No middleware. No complex pipelines. Use the T-SQL skills you already have. EXEC ss_Replica 'Production', 'Account' EXEC ss_Loader 'update', 'Production', 'Account_INC123456_Update' SQL-Sales provides direct Salesforce ETL from SQL Server using familiar T-SQL. Replicate complete objects or incremental changes, load data and files back to Salesforce, and extract Salesforce metadata — without building or maintaining separate integration pipelines. Use SQL-Sales for data migration, ongoing integration, reporting databases, archiving and development projects. Salesforce Sandboxes are always free, making it easy to install, test and evaluate before licensing a Production org.
Categories
- Business Needs
- AnalyticsData MigrationIntegration
- Personas
- ConsultantData AnalystData Professional
- FeaturesNo LimitsThis product's apps, tabs, and objects don't count against your Salesforce org limits. Learn More in HelpLightning ReadyOptimized for Salesforce orgs that use Lightning Ready.Multiple CurrenciesSupports Salesforce orgs that use Multiple Currencies.Person AccountsSupports Salesforce orgs that use Person Accounts.Salesforce ShieldSupports Salesforce orgs that use Shield.Managed PackageThis product is installed in your Salesforce org as a managed package and receives automatic upgrades.
- No LimitsLightning ReadyMultiple CurrenciesPerson AccountsSalesforce ShieldManaged Package