1 of 1 people found this helpful
We use the Jive Analytics data base for tracking our community activity. We also have it in a Postgres database. We currently have it set up so that the data is refreshed once a day in the early morning. I've created a couple of vizzes where I connect directly to Postgres itself, but find it easier to create an extract (or incremental extract) to add all the new data. Check out Crow's Nest to see one of our views using Jive data.
Thanks Tracey. In your experience setting up the reports in Tableau, what was the average number of table joins you did and did you have to use alot of SQL and even Java Data Objects to execute within Tableau? Also, I noticed some samples on the Jive community that posters also added Java Data Objects within their SQL scripts? Do I need to worry about getting a Java developer or knowing JDO to execute within Tableau?
As I was trying to map the number of Jive Analytics Database tables, I discovered that I had an average of 17 tables per report. I included:
Am I over estimating it?