I am looking at syncing data from an SQL table to Zendesk. I want all current info synced initially and then i will create a subsequent Sync for any changes of new info.
Is the initial full sync possible?
I am looking at syncing data from an SQL table to Zendesk. I want all current info synced initially and then i will create a subsequent Sync for any changes of new info.
Is the initial full sync possible?
Welcome to the Community,
It sounds like you’re wanting to do a bulk transfer of data from SQL Server to Zendesk, am I right?
If so, you could try using our Transfer feature to do a bulk import of the data from the SQL table into Zendesk. The SQL Server app is on the list of supported source apps for transfer so it should work: Which apps does Transfer support?
You can find out more about how to use Transfer here:
Hope that helps. Keen to make sure you’re all set here so please keep us updated on how you get on!
I am trying to set a transfer up. When it asks for my SQL query it input the below:
SELECT TOP (5000) [Customer No]
,[Customer Name]
,[Full Address]
,[Phone No_]
,[Shipping Agent Code]
,[Shipping Agent Service Code 2]
,[Service Code]
,[Channel 1 Code]
,[Channel 2 Code]
,[Salesperson Code]
,[Name]
,[Customer Alert]
,[E-Mail]
,[Domain]
FROM [dbo].[zendesk_customer_data]
I get this error:
Error during execution: (pyodbc.ProgrammingError) ('42S22', "[42S22] [FreeTDS][SQL Server]Invalid column name 'id'. (207) (SQLExecDirectW)") [SQL: SELECT TOP (100) "Customer No", "Customer Name", "Full Address", "Phone No_", "Shipping Agent Code", "Shipping Agent Service Code 2", "Service Code", "Channel 1 Code", "Channel 2 Code", "Salesperson Code", Name, "Customer Alert", "E-Mail", Domain FROM dbo.zendesk_customer_data ORDER BY dbo.zendesk_customer_data.id ASC] (Background on this error at: https://sqlalche.me/e/14/f405)
Any help would be appreciated
Hi there
I noticed that you've already got a ticket open with one of our Support Specialists. That's great! I suggest you continue the conversation there, so they can take a closer look at the backend of the logs and get to the root of the error.
Thanks for your cooperation and understanding. 😊
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.