ODBC guide

Bulk create accounts using SQL Server data

Creates multiple Account records in bulk using data from a SQL Server database. This example demonstrates using the SOURCE clause to read data from an external ODBC/OLEDB source and insert it into Zoho CRM.

INSERT INTO Accounts
SOURCE(
  'MSSQL' --ODBC or OLEDB
  ,'Data Source=localhost;Initial Catalog=Test;Integrated Security=true'
  ,'select ''Test Account-A'' as Account_Name,''111-111-1111'' as Phone
    UNION
    select ''Test Account-B'' as Account_Name,''222-222-2222'' as Phone
   '
)