Tableau 简明教程

Tableau - Data Sources

Tableau 可以连接到广泛使用的所有流行数据源。Tableau 的本机连接器可以连接到以下类型的数据源。

Tableau can connect to all the popular data sources which are widely used. Tableau’s native connectors can connect to the following types of data sources.

  1. File Systems such as CSV, Excel, etc.

  2. Relational Systems such as Oracle, Sql Server, DB2, etc.

  3. Cloud Systems such as Windows Azure, Google BigQuery, etc.

  4. Other Sources using ODBC

下图显示了 Tableau 的本机数据连接器可提供的多数数据源。

The following picture shows most of the data sources available through Tableau’s native data connectors.

data source 1

Connect Live

实时数据连接功能用于实时数据分析。在这种情况下，Tableau 会连接到实时数据源并不断读取数据。因此，分析结果是最新的，并且最新的更改会反映在结果中。但是，缺点是它会增加源系统负担，因为源系统必须不断向 Tableau 发送数据。

The Connect Live feature is used for real-time data analysis. In this case, Tableau connects to real-time data source and keeps reading the data. Thus, the result of the analysis is up to the second, and the latest changes are reflected in the result. However, on the downside, it burdens the source system as it has to keep sending the data to Tableau.

In-Memory

Tableau 还可以通过将数据缓存到内存中并不再连接到源来处理内存中的数据，同时分析数据。当然，缓存的数据量会有限制，取决于可用内存。

Tableau can also process data in-memory by caching them in memory and not being connected to the source anymore while analyzing the data. Of course, there will be a limit to the amount of data cached depending on the availability of memory.

Combine Data Sources

Tableau 可以同时连接到不同的数据源。例如，在单个工作簿中，您可以通过定义多个连接来连接到平面文件和关系源。这可用于数据混合，这是 Tableau 中一项非常独特的功能。

Tableau can connect to different data sources at the same time. For example, in a single workbook you can connect to a flat file and a relational source by defining multiple connections. This is used in data blending, which is a very unique feature in Tableau.