Tableau是一款优秀的数据可视化分析软件,这几天安装之后,感觉它不仅可以实现对各种数据的可视化绘制操作,并支持多个视图按照故事进行组织,同时具有强大的数据连接操作。支持各种数据源。当然最强大的肯定还是它的server版,可以实现与desktop版的无缝对接。
Tableau支持多种数据源的对接,从其官方文档上可以看出,它几乎支持当前主流的各种工具。
Excel on page 1226 Text File on page 1231 Access on page 1234 Statistical File on page 1235 Other Files on page 1237 (such as Tableau .tde, .tds, .twbx) Tableau Server on page 1238 Actian Matrix on page 1240 Actian Vectorwise on page 1242 Amazon Aurora on page 1245 Amazon EMR on page 1248 Amazon Redshift on page 1250 Aster Database on page 1253 Cloudera Hadoop on page 1256 DataStax Enterprise on page 1259 EXASolution on page 1262 Firebird on page 1264 Google Analytics on page 1267 Google BigQuery on page 1271 Google Cloud SQL on page 1274 Hortonworks Hadoop Hive on page 1277 HP Vertica on page 1280 IBM BigInsights on page 1283 IBM DB2 on page 1286 IBM PDA (Netezza) on page 1288 MapR Hadoop Hive on page 1290 MarkLogic on page 1293 Microsoft Analysis Services on page 1295 Microsoft PowerPivot on page 1297 Microsoft SQL Server on page 1298 MonetDB on page 1302 MySQL on page 1304 - 329 - OData on page 1306 Oracle on page 1308 Oracle Essbase on page 1311 Pivotal Greenplum Database on page 1314 PostgreSQL on page 1317 Progress OpenEdge on page 1319 Salesforce on page 1321 SAP HANA on page 1325 SAP NetWeaver Business Warehouse on page 1328 SAP Sybase ASE on page 1331 SAP Sybase IQ on page 1334 Snowflake on page 1336 Spark SQL on page 1339 Splunk on page 1342 Teradata on page 1343 Teradata OLAP Connector on page 1349 Web Data Connector on page 1351 Other Databases (ODBC) on page 1354
由于在该文档上看到它支持对spark sql的对接,于是从其官网上找到相应的spark sql插件,安装,并进行连接,果然可以实现。(分析下其技术原理,它主要采用hive server2的方式来实现)