The SQL Connector is nothing more than a FlexSearch plugin. It allows users to import data into a FlexSearch index from a SQL database by
POST-ing a request to a specific endpoint.
The connection string should be in a supported .NET format. Example:
data source=<server_name>;initial catalog=<db_name>;Integrated Security=True
The query is a
SQL SELECTstatement in which the names of the columns should match the names of the index fields. Also, a very important note is that the first column acts as a unique identifier for the document within the index.
Assuming you want to import data into the
contact index, you would need to
SqlIndexingRequest to the following endpoint:
Please have a look at the sample file from the SQL Connector repository. It shows how to create the client, instantiate a request, send the request to FlexSearch, then check the status of that request.