# What are your thoughts on data virtualization and how does it apply to elastic search?

**URL:** <https://discuss.elastic.co/t/what-are-your-thoughts-on-data-virtualization-and-how-does-it-apply-to-elastic-search/184831>\
**Category:** Elasticsearch\
**Tags:** elastic-stack-sql\
**Created:** [June 8, 2019, 9:08am UTC](https://discuss.elastic.co/t/what-are-your-thoughts-on-data-virtualization-and-how-does-it-apply-to-elastic-search/184831 "2019-06-08T09:08:52Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![barriersbill](https://avatars.discourse-cdn.com/v4/letter/b/c68b51/32.png) [@barriersbill](https://discuss.elastic.co/u/barriersbill)\
**Post date:** [June 8, 2019, 9:08am UTC](https://discuss.elastic.co/t/what-are-your-thoughts-on-data-virtualization-and-how-does-it-apply-to-elastic-search/184831/1 "2019-06-08T09:08:53Z")

</div>

Ive been looking at data virtualization technologies, is it really possible to use such type of solutions to connect to Elastic using SQL or even to join Elastic data with Splunk, RDBMS and other data solutions without ever moving the data ?

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [June 8, 2019, 9:47am UTC](https://discuss.elastic.co/t/what-are-your-thoughts-on-data-virtualization-and-how-does-it-apply-to-elastic-search/184831/2 "2019-06-08T09:47:26Z")

</div>

For the former look at [https://www.elastic.co/guide/en/elasticsearch/reference/7.1/sql-getting-started.html](https://www.elastic.co/guide/en/elasticsearch/reference/7.1/sql-getting-started.html)

For the later, elastic does not have such a thing. You most likely need to enrich data and make joins at index time. You can use logstash for example or other ETL tools or your own code.

---

<div class="post-metadata">

**Author:** ![barriersbill](https://avatars.discourse-cdn.com/v4/letter/b/c68b51/32.png) [@barriersbill](https://discuss.elastic.co/u/barriersbill)\
**Post date:** [June 8, 2019, 10:05am UTC](https://discuss.elastic.co/t/what-are-your-thoughts-on-data-virtualization-and-how-does-it-apply-to-elastic-search/184831/3 "2019-06-08T10:05:31Z")

</div>

does that mean I can use that sql connector to link into all other data lakes ? I also have and hdfs and was thinking maybe like elastic and hdfs.. any idea how to do that ?

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [June 8, 2019, 10:20am UTC](https://discuss.elastic.co/t/what-are-your-thoughts-on-data-virtualization-and-how-does-it-apply-to-elastic-search/184831/4 "2019-06-08T10:20:15Z")

</div>

May be. I don't know what are the tools you are thinking about to make those connections between sources.  
I meant doing the links at index time not search time.

---

<div class="post-metadata">

**Author:** ![barriersbill](https://avatars.discourse-cdn.com/v4/letter/b/c68b51/32.png) [@barriersbill](https://discuss.elastic.co/u/barriersbill)\
**Post date:** [June 9, 2019, 5:10am UTC](https://discuss.elastic.co/t/what-are-your-thoughts-on-data-virtualization-and-how-does-it-apply-to-elastic-search/184831/5 "2019-06-09T05:10:43Z")

</div>

oh ! yeah I meant search time 🙂 but not sure if that's possible 🙂 probably scripting would be required 🙂

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [June 9, 2019, 6:37am UTC](https://discuss.elastic.co/t/what-are-your-thoughts-on-data-virtualization-and-how-does-it-apply-to-elastic-search/184831/6 "2019-06-09T06:37:18Z")

</div>

Scripting in elasticsearch won't support this.

---

<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:** [July 7, 2019, 6:37am UTC](https://discuss.elastic.co/t/what-are-your-thoughts-on-data-virtualization-and-how-does-it-apply-to-elastic-search/184831/7 "2019-07-07T06:37:23Z")

</div>

Closed on July 7, 2019, 6:37am UTC

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