Hey Dan -
It is indeed correct, although potentially confusing. Think of the Data Extract as a high-performance data cache.
How do we fill it? SQL Server, Oracle, a text file, Excel, whatever. The extract is telling you "where it comes from" - that the data in the extract began it's life in SQL Server (and will potentially be refreshed from there as well).
Hope this sorta makes sense? A little?
Russell, on a somewhat related note, I feel that Refresh from the data menu (same as f5) should be labelled differently when using extracts - it only refreshes metadata I think (I still need to use it if the source changes columns), but it confuses my users - they think they are updating the extract.
Hi, Daniel. Yes. It is normal that the data source type column will display "Microsoft SQL Server." Whether the data source is refreshed periodically or not, it will continue to display "Microsoft SQL Server."
I have Oracle data sources, too, that are both on scheduled refresh and not refreshed at all. The Oracle data sources that are not refreshed continue to say "Oracle."
If I use a flat, text file as a data source and publish it, the type is "Tableau Data Extract."
I think the labeling is on the Data menu is ok. The benefit is that Tableau tries to abstract away the source of the data. This is a good thing. When you refresh, you are refreshing an extract. It doesn't matter what the source is.
Thank you everybody. That does make sense. I just wanted to make sure it wasn't still being a "live connection".