Our company is a mobile game publisher, we need analyze our published games data from their database and we needs use elasticsearch and kibana for some analysis but the game developers who work with us only give us SELECT access to certain database tables and refuse to give more access (such as setting sql trigger on tables).
we need to design ingest-pipeline for index their tables on our elasticsearch only with SELECT access and nothing more.
Can you suggest a method for indexing data from their databases given the limitations mentioned?
but the Logstash needs set trigger on the database tables but we don't access to set trigger on database because the developer (who own the game database) just give us the SELECT access on their sql database.
can you suggest me for any alternative way to push data from databases to Elasticsearch without setting trigger?
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.