Inquiry on Connectors to pull Stored Procedure

[aisyaharifin (Siti Nuraisyah)]

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.

[Sander_Philipse]

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.

[Kathleen_DeRusso]

Alternately you could always experiment with a view.