Hello Elastic,
I want to ask, can Microsoft SQL Connectors able to query directly to pull data from stored procedure?
The stored procedure will pull direct from the tables and in total we have 7 tables.
Thank you.
Hello @aisyaharifin,
You should be able to use advanced filtering rules and enter a stored procedure as an SQL command there: Elastic Microsoft SQL connector reference | Enterprise Search documentation [8.13] | Elastic
Note that I don't think we've ever tried to do that, but I don't see why this wouldn't work. We pass the SQL query to the SQL server, so if the SQL server allows you to execute a stored procedure through an SQL query, this should work.
Alternately you could always experiment with a view.
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.