I have an Elasticsearch/Kibana cluster set up in Azure using https://azure.microsoft.com/en-us/marketplace/partners/elastic/elasticsearchelasticsearch. I need to get already existing data in our SQL databases into our elastic cluster.
To do this, i'm trying to use https://github.com/jprante/elasticsearch-jdbc. Originally I was having issues getting this JDBC connector to work because I was failing to connect to the cluster. Now i THINK i solved this by configuring one of the master nodes to sit at "network.host: 0". Then attempting to connect to localhost:9300. Unfortunately, the JDBC connector fails because it is trying to pipe the data into an index that "doesn't exist." But when looking at the public external ip, it does exist.
I tested this by using the /_alias path at the public external IP. But, when running curl localhost:9200/_aliases from the master node, i get 503 master node not discovered.
Is this because I'm trying to do this FROM the master node itself, or am I missing something? If more information is needed to address this, let me know.