Connecting alteryx to transfer data from SQL Server 2022 to Singlestore

[Swapnilpkulkarni]

Hi,

We have a requirement wherein we want to transfer data from SQL Server 2022 to Singlestore on an incremental basis. This is kind of a Pseudo-CDC wherein up-serts will be involved.

Our destination is Singlestore where we want to write data on an incremental basis.

Does singlestore necessarily require ODBC driver. or any other mechanism can be used to connect.

Please note that we are on-premise setup due to country and governing body regulatory requirements.

Currently I'm trying out things via Alteryx designer Version: 2024.2.1.41.

Any help via email and/or call can be of great help

Please mark dwsupport@ccilindia.co.in also in your reply.

Thanks and Regards
Name - Swapnil Kulkarni
Department - Information Technology
Email ID - skulkarni@ccilindia.co.in
Company Name - The Clearing Corporation of India Limited

[Swapnilpkulkarni]

Just to add one more point here i tried using MYSQL ODBC connector its giving error Audit logging with binary protocol' is not supported by SingleStore

[Swapnilpkulkarni]

Team any update here?. Also please enlist if audit logging is mandatory for Singlestore as a destination