# what is the best way to sync data with elastic search from SQL server

?

##### Post Metadata
- Posted at: almost 7 years ago
- Author title: Software Developer 
- Net upvotes: 1


## Comments
### Comment 1

PGSync is one way to sync data from Postgres to ES

##### Comment Metadata
- Posted at: almost 4 years ago



### Comment 2

You can use logstash to pull in data from a jdbc connection.

https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html

Alternatively you can fairly easily write a sync job that fires periodically that pushes data into your sql db using the elasticsearch api.

Depending on how you are hosting your sql server there maybe other options you can take advantage of.  For example if you are using AWS you can use tools like Lambda and Kineses to run sync jobs that automatically scale and deal with high volume.

##### Comment Metadata
- Posted at: over 6 years ago
- Author title: Application Architect at AVIA



### Comment 3

Write a process that convert each line into Json format and load it into ElasticSearch

##### Comment Metadata
- Posted at: almost 7 years ago
- Author title: Senior Java Developer at Kenshoo Inc.




## Related Product
[Elastic Observability](https://www.g2.com/products/elastic-observability/reviews)

## Related Category
[AIOps Platforms](https://www.g2.com/categories/aiops-platforms)

## Related discussions
- [How well does Trello scale into a larger team?](https://www.g2.com/discussions/1-how-well-does-trello-scale-into-a-larger-team)
  - Posted at: about 13 years ago
  - Comments: 6
- [Can we please add a new section](https://www.g2.com/discussions/2-can-we-please-add-a-new-section)
  - Posted at: about 13 years ago
  - Comments: 0
- [Quantifiable benefits from implementing your CRM](https://www.g2.com/discussions/quantifiable-benefits-from-implementing-your-crm)
  - Posted at: about 13 years ago
  - Comments: 4