I received a request to compare data between a SingleStore database and a SQL Server database. The QA analyst would like to use SQL Server Management Studio (SSMS), connect to the SQL Server, and query SingleStore as a linked server. While I am no longer a SQL Server DBA, I was asked to help create the link but have had no success.
Has anyone created a SQL Server linked server with SingleStore as the target? If so, what was required to do so?