We want to extract data out of Adobe and store it in Elastic search and considering Adobe Datawarehouse API for the same purpose. There could be 2 options:
1. We schedule data & push it to FTP and then create a job to pull data from FTP to elastic search.
2. We remove FTP in the pipeline and start pushing data in elastic search as soon as we recieve API response from Adobe.
My question is what's more feasible and recommended approach?
It totally depends on your requirement. If you want to schedule datawarehouse report and automate it to be pulled in elasticSearch than use FTP. If you want to push data one time to elasticSearch than you can directly use API response.
I will suggest to check the below links :-