We are running Jive 5 and I'm trying to identity the purpose of the different databases. We setup DB backups which we can access via downloads in the Cloud Admin Console.
We are trying to establish a reporting strategy to pull information from BunchBall, Jive, Google Analytics, and some Internal databases. Our first step is to get all the data into one spot using a document database and daily syncs. We can then build a reporting model and move the data into a warehouse which we can build reports on.
What does each database contain? (Analytics vs System vs EAE)
Can we setup an automated process to download nightly backups of the Jive database?