# Inquiry on Connectors to pull Stored Procedure

**URL:** <https://discuss.elastic.co/t/inquiry-on-connectors-to-pull-stored-procedure/358465>\
**Category:** Elastic Search\
**Created:** [April 30, 2024, 7:46am UTC](https://discuss.elastic.co/t/inquiry-on-connectors-to-pull-stored-procedure/358465 "2024-04-30T07:46:36Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![aisyaharifin](https://avatars.discourse-cdn.com/v4/letter/a/b9e5f3/32.png) [@aisyaharifin](https://discuss.elastic.co/u/aisyaharifin)\
**Post date:** [April 30, 2024, 7:46am UTC](https://discuss.elastic.co/t/inquiry-on-connectors-to-pull-stored-procedure/358465/1 "2024-04-30T07:46:36Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Sander\_Philipse](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sander_philipse/32/101890_2.png) [@Sander\_Philipse](https://discuss.elastic.co/u/Sander_Philipse)\
**Post date:** [April 30, 2024, 1:09pm UTC](https://discuss.elastic.co/t/inquiry-on-connectors-to-pull-stored-procedure/358465/2 "2024-04-30T13:09:41Z")

</div>

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](https://www.elastic.co/guide/en/enterprise-search/current/connectors-ms-sql.html#connectors-ms-sql-sync-rules-advanced)

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.

---

<div class="post-metadata">

**Author:** ![Kathleen\_DeRusso](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kathleen_derusso/32/132039_2.png) [@Kathleen\_DeRusso](https://discuss.elastic.co/u/Kathleen_DeRusso)\
**Post date:** [April 30, 2024, 1:10pm UTC](https://discuss.elastic.co/t/inquiry-on-connectors-to-pull-stored-procedure/358465/3 "2024-04-30T13:10:48Z")

</div>

Alternately you could always experiment with a view.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [May 28, 2024, 1:11pm UTC](https://discuss.elastic.co/t/inquiry-on-connectors-to-pull-stored-procedure/358465/4 "2024-05-28T13:11:39Z")

</div>

Closed on May 28, 2024, 1:11pm UTC

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.