bi的tableau
参考:
官网:
https://help.tableau.com/current/server-linux/zh-cn/get_started_server.htm
可视化分析最佳做法: 实用指南
https://www.tableau.com/zh-cn/learn/whitepapers/tableau-visual-guidebook
tsm常用命令:
https://help.tableau.com/current/server-linux/zh-cn/tsm.htm
备份:
https://help.tableau.com/current/guides/everybody-install-linux/zh-cn/everybody_admin_backup.htm
ODBC对hive和impala的驱动下载,选cloudrea:
https://www.tableau.com/zh-cn/support/drivers?_ga=2.246892032.548458320.1568617147-1271379475.1564207357
配置初始节点:
https://help.tableau.com/current/server-linux/zh-cn/config_general.htm
安装附加节点:
https://help.tableau.com/current/server-linux/zh-cn/install_additional_nodes.htm
https://help.tableau.com/current/server-linux/zh-cn/install_additional_nodes.htm
移除:
https://help.tableau.com/current/server-linux/zh-cn/remove_tableau.htm
各进程说明:
https://help.tableau.com/current/server-linux/zh-cn/processes.htm
#tableau接es展示
https://community.tableau.com/thread/189835?_ga=2.133077069.275887119.1571033564-1247594844.1562902575
这个不是tableau官方支持的数据库,所以只能自己找驱动来连接,可参考链接中论坛中的提示
安装:
单机版安装,参考:
https://www.cnblogs.com/hongfeng2019/p/11460789.html
安装mysql的ODBC连接器连接:
从 MySQL 网站下载并安装驱动程序。(操作系统存储库中的驱动程序可能不是最新版本。)
重要:在某些情况下,MySQL 驱动程序 8.0.x 无法连接到 MySQL 5.x 数据库。因此,我们强烈建议您使用最新的驱动程序版本。该版本也应最接近您需要连接到的数据库的版本。例如,如果您需要连接到 5.x 数据库,请使用最新的 5.x 驱动程序。
转到 MySQL 网站:
https://dev.mysql.com/downloads/connector/odbc/
从下拉列表中选择您的操作系统。选择 64 位版本的驱动程序。
在 CentOS 和 RHEL 上,下载 .rpm 文件,然后运行以下命令:
sudo yum install mysql-connector-odbc-[version].[archictecture].rpm
具体安装步骤:
ODBC rpm:
wget https://dev.mysql.com/get/Downloads/Connector-ODBC/5.3/mysql-connector-odbc-5.3.13-1.el7.x86_64.rpm
在admin下:
sudo yum install mysql-connector-odbc-5.3.13-1.el7.x86_64.rpm
安装mariadb的ODBC
tableau驱动说明:
https://www.tableau.com/zh-cn/support/drivers?_ga=2.105174016.249888899.1569156795-1271379475.1564207357
https://help.tableau.com/current/pro/desktop/zh-cn/examples_mariadb.htm
安装
https://mariadb.com/kb/en/library/about-mariadb-connector-odbc/
mkdir odbc_package
cd odbc_package
wget https://downloads.mariadb.com/Connectors/odbc/connector-odbc-3.1.4/mariadb-connector-odbc-3.1.4-ga-rhel7-x86_64.tar.gz
tar -xvzf mariadb-connector-odbc-3.0.8-ga-rhel7-x86_64.tar.gz
sudo install lib64/libmaodbc.so /usr/lib64/
安装postgresql驱动
https://www.tableau.com/zh-cn/support/drivers?_ga=2.105174016.249888899.1569156795-1271379475.1564207357
wget https://downloads.tableau.com/drivers/linux/yum/tableau-driver/tableau-postgresql-odbc-09.06.0500-1.x86_64.rpm
sudo yum install tableau-postgresql-odbc-09.06.0500-1.x86_64.rpm
centos7安装hive的odbc:
安装ODBC:
sudo yum -y install unixODBC unixODBC-devel
rpm -qa |grep unixODBC
命令查看unixODBC配置文件路径
odbcinst -j
下载rpm包
https://www.cloudera.com/downloads/connectors/hive/odbc/2-6-4.html
安装文档:
https://www.cloudera.com/documentation/other/connectors/hive-odbc/latest.html
sudo yum --nogpgcheck localinstall ClouderaHiveODBC-2.6.1.1001-1.x86_64.rpm
[admin@10-52-135-178 hiveodbc]$ ls /opt/cloudera/
hiveodbc
centos7安装 impala的ODBC
下载:
https://www.cloudera.com/downloads/connectors/impala/odbc/2-6-2.html
安装文档:
https://www.cloudera.com/documentation/other/connectors/impala-odbc/2-6-2/Cloudera-ODBC-Driver-for-Impala-Install-Guide.pdf
wget https://downloads.cloudera.com/connectors/impala_odbc_2.5.41.1029/Linux/EL7/ClouderaImpalaODBC-2.5.41.1029-1.el7.x86_64.rpm
或者下ClouderaImpalaODBC-2.6.2.1002-1.x86_64.rpm
sudo yum -y localinstall ClouderaImpalaODBC-2.5.41.1029-1.el7.x86_64.rpm
[admin@10-52-135-178 cloudera]$ ls /opt/cloudera/impalaodbc/
Cloudera-ODBC-Driver-for-Impala-Install-Guide.pdf EULA.txt Release-Notes-Impala-ODBC.txt
ErrorMessages lib Setup
环境变量设置: (包括安装)
参考:
上面:cloudera的安装文档
下面这个大部分对:
https://cloud.tencent.com/developer/article/1078527
/etc/odbc.ini 配置对:
http://muse.logdown.com/posts/2015/11/06/impala-test-odbc-function
github:
https://stackoverflow.com/questions/26273752/hive-odbc-connector-settings
vim /etc/profile
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/cloudera/impalaodbc/lib/64
vim /etc/odbcinst.ini
[ImpalaODBC]
Description=Cloudera ODBC Driver for Impala (64-bit)
Driver=/opt/cloudera/impalaodbc/lib/64/libclouderaimpalaodbc64.so
[HiveODBC]
Description=Cloudera ODBC Driver for Hive(64-bit)
Driver=/opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
[admin@10-52-135-178 ~]$ vim /etc/odbc.ini
[ODBC Data Sources]
Sample_Cloudera_Impala_DSN_64=Cloudera ODBC Driver for Impala 64-bit
[Sample_Cloudera_Impala_DSN_64]
Driver=/opt/cloudera/impalaodbc/lib/64/libclouderaimpalaodbc64.so
HOST=10.52.172.232
PORT=21050
[ODBC Data Sources]
Sample_Cloudera_hive_DSN_64=Cloudera ODBC Driver for hive 64-bit
[Sample_Cloudera_hive_DSN_64]
Driver=/opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
HOST=10.52.172.232
PORT=10000
检测:
[admin@10-52-135-178 ~]$ isql -v Sample_Cloudera_Impala_DSN_64
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL>
[admin@10-52-135-178 64]$ isql -v Sample_Cloudera_hive_DSN_64
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL>