# Sql server on elastic Search cloud
**URL:** https://discuss.elastic.co/t/sql-server-on-elastic-search-cloud/191289
**Category:** Elasticsearch
**Created:** [July 18, 2019, 11:49pm UTC](https://discuss.elastic.co/t/sql-server-on-elastic-search-cloud/191289 "2019-07-18T23:49:30Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@Farouk6072](https://discuss.elastic.co/u/Farouk6072)
#### Post date: [July 18, 2019, 11:49pm UTC](https://discuss.elastic.co/t/sql-server-on-elastic-search-cloud/191289/1 "2019-07-18T23:49:30Z")
I have a question :
I have an account on cloud version of elastic search and i have sql server database
So how i can get info from my sql server database and show logs and query on kibana?? Please help me
---
### Author:  [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [July 19, 2019, 6:45am UTC](https://discuss.elastic.co/t/sql-server-on-elastic-search-cloud/191289/2 "2019-07-19T06:45:42Z")
Welcome!
What kind of data you want to have in elasticsearch? The data you stored in the DB or metrics and logs from your DB?
---
### Author:  [@Farouk6072](https://discuss.elastic.co/u/Farouk6072)
#### Post date: [July 19, 2019, 12:31pm UTC](https://discuss.elastic.co/t/sql-server-on-elastic-search-cloud/191289/3 "2019-07-19T12:31:14Z")
Yes i want show the data stored in the database like how many user, user sex
My data base i like :
jdbc:sqlserver://mysit.database.windows.net:2222;database=user1
user = user1
pwd = mypassword
My elasticsearch :
host : hosts: ["[https://xxxxxxxxxxxxxxxxxxxxxxxx.us-east-1.aws.found.io:9243](https://xxxxxxxxxxxxxxxxxxxxxxxx.us-east-1.aws.found.io:9243)"]
username: "elastic"
password: "XXXXXXXXXXXXXXXXXX"
thanks
---
### Author:  [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [July 19, 2019, 2:11pm UTC](https://discuss.elastic.co/t/sql-server-on-elastic-search-cloud/191289/4 "2019-07-19T14:11:48Z")
I shared most of my thoughts there: [http://david.pilato.fr/blog/2015/05/09/advanced-search-for-your-legacy-application/](http://david.pilato.fr/blog/2015/05/09/advanced-search-for-your-legacy-application/)
Basically, I'd recommend modifying the application layer if possible and send data to elasticsearch in the same "transaction" as you are sending your data to the database.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [August 16, 2019, 2:11pm UTC](https://discuss.elastic.co/t/sql-server-on-elastic-search-cloud/191289/5 "2019-08-16T14:11:54Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.