Can I connect SQL Server to Manticore from an SP to load the data directly?
Assuming you mean Microsoft SQL, there is a mssql database driver
If that doesnt work maybe the more generic odbc might work.
(although dont know what SP means)
SP is a storing procedure, I want to index but incrementally on my flat table, but it doesn’t work, how can I do this
I’m not sure there’s a way to integrate Manticore with a MS SQL stored procedure, but If you are looking for incremental indexing, take this course Manticore Search - Main+delta schema and read the corresponding docs section Manticore Search Manual: Data creation and modification > Adding data from external storages > Main delta