Skip to main content
Topics#IntegrationScott Trick の質問
Scott Trick が「#Integration」で質問
2023年7月31日 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 件の回答
  1. Julia Sanders (Digital Nexus)
    2024年11月4日 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.

回答を記入...
0/9000