-
1. Re: What is the size of Tableau server repository ?
Toby ErksonSep 28, 2017 6:46 AM (in response to Babu N)
My guess would be: As big as your hard drive can handle.
Why do you ask?
-
2. Re: What is the size of Tableau server repository ?
Babu N Sep 28, 2017 6:54 AM (in response to Toby Erkson)Thanks Erkson
Want to know how much data it can able to store.
-
3. Re: What is the size of Tableau server repository ?
Toby ErksonSep 28, 2017 6:59 AM (in response to Babu N)
Babu N wrote:
Want to know how much data it can able to store.
Why? What is your reason? Do you think you will have a deployment that will have hundreds of thousands of Projects? Millions of Users? Hundreds of Sites? What is the reason behind your question.
-
4. Re: What is the size of Tableau server repository ?
Jeff StraussSep 28, 2017 7:03 AM (in response to Babu N)
I also am curious as to why. I've never seen a limit besides the size of your hard drive. And, I've run across instances of 20,000 workbooks.
-
5. Re: What is the size of Tableau server repository ?
satish.parvathaneni Sep 28, 2017 10:27 AM (in response to Jeff Strauss)wow ..that sounds a lot ....
-
6. Re: What is the size of Tableau server repository ?
Babu N Sep 28, 2017 11:06 PM (in response to Babu N)Hi Erkson and Strauss,
Here is the explanation why I want to know this information.
Suppose my data source has millions of records and thousands of columns and I'm not going to filter any of the data while exacting
and there are hundreds of such data sources want to publish
then in this case will it be store all the data in repository with out any space constraints ? Are the RAM and hard drive size depends on repository size ?
The above case is my assumption only.
-
7. Re: What is the size of Tableau server repository ?
Donna ColesSep 29, 2017 12:46 AM (in response to Babu N)
2 of 2 people found this helpfulHi there
The repository is the term Tableau use to refer to the postgres database which gets installed with the server and stores all the info you mention. While the repository will store information about your data sources - what they're called, the connection info etc, it doesn't store your actual data. If the data source is a 'live connection' then the data is stored wherever that data resides eg a SQL Server, an excel file, an Oracle database etc. If the data source is extracted, then the data is pulled from wherever the data is located and stored in Tableau's columnar data store on the server. This is separate from the repository. So if you have incredibly large data sources (lots of rows & columns) you want to extract, then your main concerns are ensuring you have enough space on the server itself to store these extracts and you've got enough resources to process the extracts which will take some time if they are very wide as well as very deep.
Donna
-
8. Re: What is the size of Tableau server repository ?
Babu N Sep 29, 2017 3:34 AM (in response to Donna Coles)Thanks Donna...
your explanation clear all my doubts, one more thing I want to know where this extracted data file will be stored in Tableau server (Location in Tableau server).
-
9. Re: What is the size of Tableau server repository ?
Donna ColesSep 29, 2017 7:04 AM (in response to Babu N)
Hi Babu
There isn't a specific location. Can I suggest you have a read of this article which will hopefully explain things a bit better - it was written with v8 but I believe the principals still hold
Understanding Tableau Data Extracts | Tableau Software
Thanks
Donna
-
10. Re: What is the size of Tableau server repository ?
Jeff StraussSep 29, 2017 7:13 AM (in response to Donna Coles)
3 of 3 people found this helpfulHi Donna. Generally, I find the data extracts are buried deep in sub-folders of the data engine parent within the Tableau installation directory (i.e. G:\Tableau\Tableau Server\data\tabsvc\dataengine). I hope this clarifies some....
-
11. Re: What is the size of Tableau server repository ?
Donna ColesSep 29, 2017 7:15 AM (in response to Jeff Strauss)
Thanks Jeff.... never had to look for them personally :-)
-
12. Re: What is the size of Tableau server repository ?
satish.parvathaneni Oct 2, 2017 4:03 PM (in response to Babu N)4 of 4 people found this helpfulTo know your postgres DB Size
select pg_database_size('workgroup')
Then convert to 'GB'.