Elasticsearch Index Manager
Indexes
Create Index
Data Sync
Incremental Sync
SQL-to-SQL Sync
Search
API Docs
Swagger UI
ReDoc
Create Data Sync Configuration
Configuration Name
*
Batch Size
Number of records to process per batch
SQL Server Connection String
*
Test Connection
Schema
Source Table
*
Load Tables
Elasticsearch Index Name
*
Index names must be lowercase
WHERE Clause (Optional)
SQL WHERE clause to filter source data
Data Change Detection Column (Optional)
-- Select Change Detection Column --
Select a column (e.g., ModifiedDate, UpdatedAt, LastModified) to track data changes for incremental syncs. This column should be updated whenever a record is modified. If not specified, the system will attempt to auto-detect a suitable column.
Auto-increment / ID Column (Optional)
-- None (sync by offset) --
Select the identity/auto-increment column (e.g. Id, ProductId). When set, re-run sync will fetch only new rows where this column > last synced value. Click "Load Columns" to populate.
Field Mappings
Add Field
Load Columns
Source Column
Target Field
Field Type
Text
Keyword
Long
Integer
Date
Boolean
Dense Vector
Vector Configuration
Dimensions
*
Must match Ollama embedding model (e.g. 768)
Similarity
Cosine
Dot Product
L2 Norm
Click "Load Columns" to automatically populate field mappings from the source table. Leave empty to sync all columns.
Column Selection
Sync All Columns
Select Columns to Sync
Click "Load Columns" to select columns
Select specific columns to sync. Unselected columns will be excluded.
Ollama Embeddings & Vector Search
Enable Ollama Embeddings for Vector Fields
Ollama URL
Ollama server URL
Embedding Model
Ollama embedding model name
Vector Column Mappings
Add Mapping
Map SQL columns to vector fields. The source column text will be embedded using Ollama and stored in the target vector field.
Scheduling (Azure-style)
Enable Scheduled Sync
Schedule Type
Select...
Once (One-time)
Recurring (Interval)
Cron Expression
Interval (Minutes)
Sync will run every N minutes
Cron Expression
Cron format: second minute hour day month dayofweek
Start Time
Back to List
Create Configuration