Our main CRM application runs on a SQL Server 2016 database with about 500 tables. What is the most efficient way to import the largest 50-100 into Xcalar? Will we need to dump CSVs with BCP or can Xcalar connect over ODBC directly?
You can do it both ways. In general, ODBC is a bit slower.This video explains how to connect to an ODBC data source:How-to Series (UDFs) - How to import from external sources (e.g. SQL server)