Skip to main content
Topics#IntegrationPregunta de Scott Trick
Scott Trick preguntó en #Integration
31 jul 2023, 20:59

Import Data From SQL Server Into Salesforce

Every day I want to use Salesforce API and send about 5000 records from our existing SQL Server database to Salesforce using API.

I am new to Salesforce but have experience working with API's.

What I want to know is do I use the BULK API for this?

Everything I have read says that to use the BULK API I have to upload the data using CSV.  Is it possible to upload directly from SQL Server to Salesforce using a .net app?

TIA!
3 respuestas
  1. Julia Sanders (Digital Nexus)
    4 nov 2024, 12:47

    Hi @Scott Trick,

     

    Salesforce BULK API is the most appropriate for this task. One way is to use CSV as an intermediate format for data loading, another option is to use third-party tools, like Skyvia that support direct data integration between Salesforce and SQL Server and can automate this process.

     

    I hope it helps you to solve your task.

Escribir una respuesta...
0/9000