Skip to Content
Author's profile photo Dimitri Vorobiev

How to connect Tableau 10.4 to Vora 2.0

Please note that Vora is not yet certified by Tableau and that the instructions below are not officially supported by SAP.

Pre-requisites:

  • The Kubernetes cluster has already been deployed and configured
  • Vora 2.0 is ready to be installed or has already been deployed
  • You are using Tableau 10.4 or greater

 

Assuming you’ve downloaded and extracted the SAP Vora installer, go to the root directory of the Vora installer e.g. /SAPVora-DistributedRuntime/

Modify line 16 of the file:

/<root_install_dir>/deployments/helm/vora-thriftserver/values.yaml 

11 thriftserver:
12     docker:
13         image: vora/thriftserver
14         imageTag: 2.0.14
15     service:
16         expose: true

 

Add the following three lines of code after line 131 in file

/<root_install_dir/deployment/helm/vora-thriftserver/templates/deployment.yaml

131 "--hiveconf", "hive.server2.transport.mode={{$mode}}",
132 {{- if eq $mode "http" }}
133 "--conf", "spark.sql.dialect=hiveql",
134 {{- end }} 

 

If you’ve already installed Vora 2.0 then you can simply update the deployment with the new settings using below command. Only Vora Tools and the Thriftserver will experience a momentary downtime during this execution:

/<root_install_dir>/install.sh -ui --limit-service=vora-thriftserver

 

If you have not yet installed Vora 2.0 then proceed to install as you would normally. Refer to the SAP Vora Install guide for details.

 

Regardless of whether you updated your existing Vora installation or installed from scratch you should verify that you have now two Thriftserver services running, one in binary mode and another in http mode which has an exposed service port. This exposed port is dynamically assigned and changes with each deployment.

kubectl get svc --all-namespaces | grep vora-thriftserver

 

Proceed to launch Tableau 10.4 on your workstation. Look under the section “Connection” and choose “Spark SQL”

 

Hostname:                    Kubernetes master host
Port:                               vora-thriftserver-http exposed port
Authentication mode:  HTTP
Username/password:  lumira/lumira
HTTP path:                    /cliservice

 

When selecting a schema choose default and submit the entry by clicking on the blue cross icon

 

To search and view a list of available tables in Tableau click on the magnifying glass icon

 

Note: In order for Vora tables to be visible in Tableau, they must first be registered in the Vora HTTP Thriftserver by issuing a REGISTER TABLE command from a tool like beeline. This has to be done each time the Thriftserver is restarted.

To connect to the Vora HTTP thriftserver using beeline use the following beeline command:

!connect jdbc:hive://<kubernetesMaster_host>:<exposedPort>/default;transportMode=http;httpPath=/cliservice; lumira lumira

For details on how to use the REGISTER TABLE commands, please refer to the SAP Vora Developer Guide.

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Douglas Maltby
      Douglas Maltby

      Thank you Dimitri.

      I was able to successfully expose the Vora thriftserver and use your instructions to modify the deployment.yaml and update my test Vora 2.0 installation on GCP (based on SAP HANA Academy Vora 2.0 playlist videos and the GitHub script). I cannot get Tableau 10.3 to connect to the thriftserver, presumably with the slightly different Spark SQL connection parameters for transport and HTTP path.

      I did have to export the NAMESPACE and DOCKER_REGISTRY first, and then use a more complete installation update command for it to work, as shown below:

      export NAMESPACE=vora
      export DOCKER_REGISTRY=localhost:5000
      
      ./install.sh -ui -dt=cloud -ls=vora-thriftserver --enable-rbac=no --configure-hdfs=no --configure-hana=no --enable-security-operator=yes --enable-authentication=yes --vora-admin-username=vora --vora-admin-password=SHALive1 -a
      

       

      Is there any way to connect Vora 2.0 with Tableau 10.3, or is 10.4 a technical requirement?

      Doug