ODBC guide

Bulk create tickets using SQL Server data

Creates multiple tickets in bulk using data from a SQL Server database. This example demonstrates using the SOURCE clause with the Tickets_BULK table to read data from an external ODBC/OLEDB source and insert it into Zendesk.

INSERT INTO Tickets_BULK 
SOURCE(
  'MSSQL' --ODBC or OLEDB
  ,'Data Source=localhost;Initial Catalog=Test;Integrated Security=true'
  ,'select ''Test Subject#1'' as subject,''new'' as status,''this is description#1'' as comment_body from Projects'
)