How to load data or ETL into Elasticsearch from SQL while avoiding problems

Implementing low latency, updates and merging of SQL data into Elasticsearch Elasticsearch is a powerful text search engine that provides many features not found in typical SQL databases. Text search tends to be CPU and IO intensive as implemented in SQL databases. So there is a strong need for a SQL database to off load… Continue reading How to load data or ETL into Elasticsearch from SQL while avoiding problems

Top 15 reasons to use a Json ETL tool

Advantages of using declarative json ETL software Intelligent Integration is a powerful enterprise declarative ETL tool based on internal Json documents. Intelligent Integration can read or write to nearly any datasource including SQL, NoSQL , flat files or REST. When reading from non-Json sources, Intelligent Integration immediately converts the data into Json for processing. Being… Continue reading Top 15 reasons to use a Json ETL tool