Tableau Integration

{{tableau}} is an interactive data visualization application designed to create charts and dashboards from various data sources prerequisites to use tableau with the {{ocient}} system, you must have these software prerequisites ocient system — use the latest version jdbc driver — download the latest version with dependencies from the https //mvnrepository com/artifact/com ocient/ocient jdbc4 installation download the latest version of tableau desktop for your respective operating system from the https //www tableau com/products/desktop/download website register and sign in to tableau desktop then, follow steps to complete the installation add necessary packages to connect to ocient, you must add these files to your tableau installation ocient jdbc driver ( jar ) — use the latest version with dependencies from the https //mvnrepository com/artifact/com ocient/ocient jdbc4 ocient tableau connector file ( taco ) — download the latest version from https //exchange tableau com/products/178 the taco connector file supports tableau desktop and tableau server contact tableau for support regarding tableau cloud add the ocient jdbc driver jar file move the downloaded jdbc driver jar file to the corresponding folder based on your operating system {{windows}} — c \users\[windows user]\documents\my tableau repository\connectors {{macos}} — /users/\[user]/documents/my tableau repository/connectors add the tableau connector file ( taco ) move the downloaded taco connector file to the corresponding folder based on your operating system windows — c \program files\tableau\drivers macos — /users/\[user]/library/tableau/drivers connect to ocient connect to your database by following these steps open tableau and find the connect to a server menu select ocient jdbc from the list of installed connectors if ocient jdbc does not appear as an option in tableau, ensure that the ocient tableau connector file ( taco ) is located in the correct folder in the connection window, enter your database parameters with this information field description host the hostname or ip address of the sql node of your ocient system for example databasehost sql0 port the port number for your connection the default ocient port is 4050 database the name of the database for connection for example my db user the username associated with your database password the password associated with your username select sign in after you enter all the information related links docid\ y ge7svqdmn 9yie2iuv6 docid\ rykk tzyxdmrqdpodtc79