My team is trying to pull customer metrics from an Elastic Database either Kibana or Grafana to push over and sync into SFDC.
Do you know if we can do direct queries into sfdc or upload a csv?
We would like to track these metrics week over week and hopefully have an automated sync of the fields we are tracking.
Trying to figure out where to start with this project! Please let me know if anyone has done something similar!
Thank you!
1 answer
Hi Morgan,
I haven't worked directly with Kibana or Grafana, but there very well could be an integration that allows you to directly make the API calls needed to insert/update records directly in Salesforce. I would consider searching the AppExchange to see if these products have packages already available. You could also look into a solution like Mulesoft to integrate the databases.
You certainly can use a CSV to upload the data and make the appropriate updates. This could either be a manual process using Data Loader, or you could use a more advanced solution like Data Loader IO to grab a CSV file from a server and automatically upload it on a weekly basis if you don't want someone to have to do this manually.
Thanks,
Mikey
