Versions (relevant - OpenSearch/Dashboard/Server OS/Browser):
Windows, OpenSearch/OpenSearch Dashboard
Describe the issue:
Hi All!
I was hoping someone could point me to the most straightforward approach to ingesting data as a batch (e.g., all records from the last ingestion) via a SQL server to OpenSearch indexes such that it’s available for use by OpenSearch Dashboards? (e.g., all records from table X with an update date since the last ingestion.
DataPrepper doesn’t seem to have an ODBC/JDBC source
Logstash seems like it might support batch ingestion but that’s a separate product I’d need to install.
Write something custom that creates a JSON file and run it in batch and then have logstash load the file?
Is there some more straightforward way to do this?
Configuration:
N/A
Relevant Logs or Screenshots:
N/A