{"type":"doc","content":[{"type":"paragraph","content":[{"text":"Applies to:","type":"text","marks":[{"type":"strong"}]},{"text":" ","type":"text"},{"type":"emoji","attrs":{"id":"atlassian-check_mark","text":":check_mark:","shortName":":check_mark:"}},{"text":" Kyvos Enterprise ","type":"text"},{"type":"emoji","attrs":{"id":"atlassian-check_mark","text":":check_mark:","shortName":":check_mark:"}},{"text":" Kyvos Cloud (SaaS on AWS) ","type":"text"},{"type":"emoji","attrs":{"id":"atlassian-check_mark","text":":check_mark:","shortName":":check_mark:"}},{"text":" Kyvos AWS Marketplace","type":"text"}]},{"type":"paragraph","content":[{"type":"emoji","attrs":{"id":"atlassian-check_mark","text":":check_mark:","shortName":":check_mark:"}},{"text":" Kyvos Azure Marketplace ","type":"text"},{"type":"emoji","attrs":{"id":"atlassian-check_mark","text":":check_mark:","shortName":":check_mark:"}},{"text":" Kyvos GCP Marketplace ","type":"text"},{"type":"emoji","attrs":{"id":"atlassian-check_mark","text":":check_mark:","shortName":":check_mark:"}},{"text":" Kyvos Single Node Installation (Kyvos SNI)","type":"text"}]},{"type":"rule"},{"type":"paragraph","content":[{"text":"To connect Tableau Server (On-prem) to Kyvos semantic models, you can use any of the following methods:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Publish data source to Tableau Server","type":"text","marks":[{"type":"link","attrs":{"href":"#PublishDSonTableauServer"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Publish workbook on Tableau Server","type":"text","marks":[{"type":"link","attrs":{"href":"#PublishWBonTableauServer"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Tableau Server (On-prem) on Kyvos","type":"text","marks":[{"type":"link","attrs":{"href":"#TableauServerInterfaceConnection"}}]}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Publish data source on Tableau Server ","type":"text"},{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"anchor","parameters":{"macroParams":{"":{"value":"PublishDSonTableauServer"},"legacyAnchorId":{"value":"TableauServer(On-prem)onKyvos-PublishDSonTableauServer"}},"macroMetadata":{"macroId":{"value":"dead2e20b42de57f3ff97edba7e82e58"},"schemaVersion":{"value":"1"},"title":"Anchor"}},"localId":"b3e59fe2-3f37-4c00-b95e-ff88778e07af"}}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Open Tableau desktop.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Connect to the Kyvos data source using the ","type":"text"},{"text":"Tableau Server (On-prem) on Kyvos","type":"text","marks":[{"type":"link","attrs":{"href":"#Tableauinterface"}}]},{"text":" or ","type":"text"},{"text":"TDS metadata file","type":"text","marks":[{"type":"link","attrs":{"href":"#"}}]},{"text":".","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"From the ","type":"text"},{"text":"Server ","type":"text","marks":[{"type":"strong"}]},{"text":"menu and select the ","type":"text"},{"text":"Publish Data Source","type":"text","marks":[{"type":"strong"}]},{"text":" option, and select your data source (Kyvos semantic model).","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":650,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1255,"id":"b993dce9-5247-4455-97e8-17afb1499da4","collection":"contentId-69341882","type":"file","height":646},"marks":[{"type":"border","attrs":{"size":2,"color":"#091e4224"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"On the displayed ","type":"text"},{"text":"Tableau Server Sign in","type":"text","marks":[{"type":"strong"}]},{"text":" dialog, provide the Tableau Server URL and click the ","type":"text"},{"text":"Connect ","type":"text","marks":[{"type":"strong"}]},{"text":"button.","type":"text"},{"type":"hardBreak"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":450,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":532,"id":"4bf1756a-487f-4299-a115-730ffdd1beb0","collection":"contentId-69341882","type":"file","height":157},"marks":[{"type":"border","attrs":{"size":2,"color":"#091e4224"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enter details in the ","type":"text"},{"text":"Publish Data Source to Tableau Server","type":"text","marks":[{"type":"strong"}]},{"text":" dialog box.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":450,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":453,"id":"5ba0d001-e7c8-4664-8374-38ef2508eed7","collection":"contentId-69341882","type":"file","height":684},"marks":[{"type":"border","attrs":{"size":2,"color":"#091e4224"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click the ","type":"text"},{"text":"Publish ","type":"text","marks":[{"type":"strong"}]},{"text":"button. Your workbook will be published on the Tableau Server.","type":"text"}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Publish Workbook on Tableau Server","type":"text"},{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"anchor","parameters":{"macroParams":{"":{"value":"PublishWBonTableauServer"},"legacyAnchorId":{"value":"TableauServer(On-prem)onKyvos-PublishWBonTableauServer"}},"macroMetadata":{"macroId":{"value":"57fbee902fc998408eb11186acca4e9b"},"schemaVersion":{"value":"1"},"title":"Anchor"}},"localId":"a7d35edc-ccdc-47e4-9dab-e3f50c37ee47"}},{"text":" ","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Create a worksheet/visualization as per your business requirement on the Tableau desktop.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"From the ","type":"text"},{"text":"Server ","type":"text","marks":[{"type":"strong"}]},{"text":"menu, select the ","type":"text"},{"text":"Publish Workbook","type":"text","marks":[{"type":"strong"}]},{"text":" option.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":650,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1165,"id":"360f6d80-d322-415b-a6b6-bcc7a3e1c3d3","collection":"contentId-69341882","type":"file","height":560},"marks":[{"type":"border","attrs":{"size":2,"color":"#091e4224"}}]}]},{"type":"paragraph","content":[{"type":"hardBreak"},{"text":"The ","type":"text"},{"text":"Publish Workbook to Tableau Server","type":"text","marks":[{"type":"strong"}]},{"text":" dialog box is displayed.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":450,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":545,"id":"876a7efb-71be-4945-bf24-5d167badbea6","collection":"contentId-69341882","type":"file","height":773},"marks":[{"type":"border","attrs":{"size":2,"color":"#091e4224"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enter details as:","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select the ","type":"text"},{"text":"Project ","type":"text","marks":[{"type":"strong"}]},{"text":"to which the workbook belongs.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"From the ","type":"text"},{"text":"Name ","type":"text","marks":[{"type":"strong"}]},{"text":"drop-down, select the workbook that you want to publish.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Optionally, provide a ","type":"text"},{"text":"Description ","type":"text","marks":[{"type":"strong"}]},{"text":"and ","type":"text"},{"text":"Tags","type":"text","marks":[{"type":"strong"}]},{"text":".","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"To select specific sheets or dashboards to publish, click the ","type":"text"},{"text":"Edit ","type":"text","marks":[{"type":"strong"}]},{"text":"link under ","type":"text"},{"text":"Sheets","type":"text","marks":[{"type":"strong"}]},{"text":", and select the requisite sheets. To publish only Dashboard, click the ","type":"text"},{"text":"Only Dashboards","type":"text","marks":[{"type":"strong"}]},{"text":" button. To publish all sheets and dashboards, click the ","type":"text"},{"text":"All","type":"text","marks":[{"type":"strong"}]},{"text":" button. ","type":"text"},{"type":"hardBreak"},{"text":"NOTE: ","type":"text","marks":[{"type":"strong"}]},{"text":"By default, all sheets and dashboards present in the workbook are published. ","type":"text"},{"type":"hardBreak"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":450,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":641,"id":"271006a7-bb23-4a29-8fb7-740abc62db4f","collection":"contentId-69341882","type":"file","height":292},"marks":[{"type":"border","attrs":{"size":2,"color":"#091e4224"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click the ","type":"text"},{"text":"Edit ","type":"text","marks":[{"type":"strong"}]},{"text":"link under ","type":"text"},{"text":"Permission ","type":"text","marks":[{"type":"strong"}]},{"text":"to specify data source authentication. You can select the ","type":"text"},{"text":"Embedded Password","type":"text","marks":[{"type":"strong"}]},{"text":" or ","type":"text"},{"text":"Prompt User","type":"text","marks":[{"type":"strong"}]},{"text":" option as needed.","type":"text"},{"type":"hardBreak"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":450,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":757,"id":"6c541269-7bd8-4bc5-8541-00e5ca366479","collection":"contentId-69341882","type":"file","height":212},"marks":[{"type":"border","attrs":{"size":2,"color":"#091e4224"}}]}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click the ","type":"text"},{"text":"Publish ","type":"text","marks":[{"type":"strong"}]},{"text":"button. The workbook will be published on the Tableau server and can be accessed from the Tableau Server as well.","type":"text"}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Connect to Kyvos semantic model through Tableau Server interface ","type":"text"},{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"anchor","parameters":{"macroParams":{"":{"value":"TableauServerInterfaceConnection"},"legacyAnchorId":{"value":"TableauServer(On-prem)onKyvos-TableauServerInterfaceConnection"}},"macroMetadata":{"macroId":{"value":"61e14545bc95089199e684f2233b793e"},"schemaVersion":{"value":"1"},"title":"Anchor"}},"localId":"6369d5da-64b3-4728-b4d0-9de781a12159"}}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Login to Tableau Server.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click ","type":"text"},{"text":"New ","type":"text","marks":[{"type":"strong"}]},{"text":"and select the ","type":"text"},{"text":"Workbook ","type":"text","marks":[{"type":"strong"}]},{"text":"option.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":650,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1280,"id":"2a66f9a4-c671-4c07-a1b3-1d14da7eb30f","collection":"contentId-69341882","type":"file","height":630},"marks":[{"type":"border","attrs":{"size":2,"color":"#091e4224"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"On the New Workbook screen, go to the ","type":"text"},{"text":"Connectors","type":"text","marks":[{"type":"strong"}]},{"text":" tab and select ","type":"text"},{"text":"Kyvos ","type":"text","marks":[{"type":"strong"}]},{"text":"or ","type":"text"},{"text":"Spark SQL ","type":"text","marks":[{"type":"strong"}]},{"text":"option.","type":"text"},{"type":"hardBreak"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":650,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1280,"id":"fad004ed-993d-4c60-865b-eee1c8e2c4f6","collection":"contentId-69341882","type":"file","height":624},"marks":[{"type":"border","attrs":{"size":2,"color":"#091e4224"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"On the displayed ","type":"text"},{"text":"Kyvos ","type":"text","marks":[{"type":"strong"}]},{"text":"dialog box, enter your connection information as:","type":"text"}]},{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"__confluenceADFMigrationUnsupportedContentInternalExtension__","text":"","parameters":{"cxhtml":"

Parameter	Description
Server	IP address or hostname of your Kyvos Web App Server.
HTTP Path	Client path for Kyvos Web portal.
Port	TCP port that the Kyvos Web App server uses to listen to client requests.
Username	Kyvos Web App Server Username.
Password	Kyvos Web App Server Password.
Require SSL	Select the checkbox if connecting to an SSL Server.

","block-inline":true,"nestedContent":{"type":"doc","content":[{"type":"table","attrs":{"layout":"wide"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[160.6]},"content":[{"type":"paragraph","content":[{"text":"Parameter","type":"text"}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[651.77]},"content":[{"type":"paragraph","content":[{"text":"Description","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[160.6]},"content":[{"type":"paragraph","content":[{"text":"Server ","type":"text","marks":[{"type":"strong"},{"type":"textColor","attrs":{"color":"#000000"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[651.77]},"content":[{"type":"paragraph","content":[{"text":"IP address or hostname of your Kyvos Web App Server.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[160.6]},"content":[{"type":"paragraph","content":[{"text":"HTTP Path","type":"text","marks":[{"type":"strong"},{"type":"textColor","attrs":{"color":"#000000"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[651.77]},"content":[{"type":"paragraph","content":[{"text":"Client path for Kyvos Web portal.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[160.6]},"content":[{"type":"paragraph","content":[{"text":"Port ","type":"text","marks":[{"type":"strong"},{"type":"textColor","attrs":{"color":"#000000"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[651.77]},"content":[{"type":"paragraph","content":[{"text":"TCP port that the Kyvos Web App server uses to listen to client requests.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[160.6]},"content":[{"type":"paragraph","content":[{"text":"Username ","type":"text","marks":[{"type":"strong"},{"type":"textColor","attrs":{"color":"#000000"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[651.77]},"content":[{"type":"paragraph","content":[{"text":"Kyvos Web App Server Username.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[160.6]},"content":[{"type":"paragraph","content":[{"text":"Password ","type":"text","marks":[{"type":"strong"},{"type":"textColor","attrs":{"color":"#000000"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[651.77]},"content":[{"type":"paragraph","content":[{"text":"Kyvos Web App Server Password.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[160.6]},"content":[{"type":"paragraph","content":[{"text":"Require SSL","type":"text","marks":[{"type":"strong"},{"type":"textColor","attrs":{"color":"#000000"}}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[651.77]},"content":[{"type":"paragraph","content":[{"text":"Select the checkbox if connecting to an SSL Server.","type":"text","marks":[{"type":"textColor","attrs":{"color":"#000000"}}]}]}]}]}]}],"version":1},"reason":"A table in list item can't be created or edited in the new editor."}}}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click ","type":"text"},{"text":"Sign In","type":"text","marks":[{"type":"strong"}]},{"text":".","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":450,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":622,"id":"87c882af-00c7-4db5-b561-bc01b3720c92","collection":"contentId-69341882","type":"file","height":577},"marks":[{"type":"border","attrs":{"size":2,"color":"#091e4224"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"On the ","type":"text"},{"text":"Data Source ","type":"text","marks":[{"type":"strong"}]},{"text":"page, select your ","type":"text"},{"text":"Schema","type":"text","marks":[{"type":"strong"}]},{"text":",","type":"text"},{"text":" ","type":"text","marks":[{"type":"strong"}]},{"text":"then select the ","type":"text"},{"text":"Table","type":"text","marks":[{"type":"strong"}]},{"text":" that you want to browse in Tableau. The Kyvos data store is loaded in Tableau. You can now use your data to create reports.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"center","width":650,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1280,"id":"5eec0b1d-3a44-4a4f-8bde-e2ffff36ade3","collection":"contentId-69341882","type":"file","height":687},"marks":[{"type":"border","attrs":{"size":2,"color":"#091e4224"}}]}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Connecting to Kyvos semantic models through Tableau interface","type":"text"}]},{"type":"paragraph","content":[{"text":"Tableau Software released a new custom Kyvos connector with its latest version, Tableau 2019.4. Here are the steps that can help you get productive right away using the Kyvos Tableau Connector.","type":"text"}]},{"type":"paragraph","content":[{"text":"To connect Tableau to a Kyvos semantic model and set up the data source, you must first have this connection information:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Name of the server that hosts the database you want to connect","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Port number for client requests","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"HTTP path to the server","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"User name and password","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Are you connecting to an SSL server?","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"(Optional) Initial SQL statement to run every time Tableau connects","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"On the Tableau window, select the ","type":"text"},{"text":"Kyvos","type":"text","marks":[{"type":"strong"}]},{"text":" option from the ","type":"text"},{"text":"To a Server","type":"text","marks":[{"type":"strong"}]},{"text":" list on the navigation pane.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":650,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":626,"id":"aa2cd31f-9646-4f1a-a8da-05f3ca36359e","collection":"contentId-69341882","type":"file","height":477}}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":" ","type":"text","marks":[{"type":"strong"}]},{"text":"In the displayed Kyvos dialog box, enter your connection information as:","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":" ","type":"text","marks":[{"type":"strong"}]},{"text":"In the ","type":"text"},{"text":"Server ","type":"text","marks":[{"type":"strong"}]},{"text":"field, type the IP address or hostname of your Kyvos Web App server.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":" ","type":"text","marks":[{"type":"strong"}]},{"text":"In the ","type":"text"},{"text":"Port ","type":"text","marks":[{"type":"strong"}]},{"text":"field, type the number of the TCP port that the Kyvos Web App server uses to listen for client requests.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":" ","type":"text","marks":[{"type":"strong"}]},{"text":"In the ","type":"text"},{"text":"HTTP Path ","type":"text","marks":[{"type":"strong"}]},{"text":"field, type your client path.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":" ","type":"text","marks":[{"type":"strong"}]},{"text":"In the ","type":"text"},{"text":"Username ","type":"text","marks":[{"type":"strong"}]},{"text":"field, type your Kyvos Web App Server Username.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":" ","type":"text","marks":[{"type":"strong"}]},{"text":"In the ","type":"text"},{"text":"Password ","type":"text","marks":[{"type":"strong"}]},{"text":"field, type your Kyvos Web App Server Password","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":" ","type":"text","marks":[{"type":"strong"}]},{"text":"Select the ","type":"text"},{"text":"Require SSL ","type":"text","marks":[{"type":"strong"}]},{"text":"checkbox if connecting to an SSL Server.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":" ","type":"text","marks":[{"type":"strong"}]},{"text":"(Optional) Select ","type":"text"},{"text":"Initial SQL ","type":"text","marks":[{"type":"strong"}]},{"text":"to specify a SQL command to run at the beginning of every connection, such as when you open the workbook, refresh an extract, sign in to Tableau Server, or publish to Tableau Server. For more information, see ","type":"text"},{"text":"Run Initial SQL","type":"text","marks":[{"type":"link","attrs":{"href":"https://help.tableau.com/current/pro/desktop/en-us/connect_basic_initialsql.htm"}}]},{"text":".","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":" ","type":"text","marks":[{"type":"strong"}]},{"text":"Click ","type":"text"},{"text":"Sign In","type":"text","marks":[{"type":"strong"}]},{"text":". On the ","type":"text"},{"text":"Data Source ","type":"text","marks":[{"type":"strong"}]},{"text":"page, select your ","type":"text"},{"text":"Schema, ","type":"text","marks":[{"type":"strong"}]},{"text":"then select ","type":"text"},{"text":"Table","type":"text","marks":[{"type":"strong"}]},{"text":" that you want to browse in Tableau.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":" ","type":"text","marks":[{"type":"strong"}]},{"text":"The Kyvos data store is loaded in Tableau. You can now use your data to create reports.","type":"text"}]}]}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":650,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1280,"id":"2fb70b3d-fed4-4c66-ab33-baa52916e5d3","collection":"contentId-69341882","type":"file","height":687},"marks":[{"type":"border","attrs":{"size":2,"color":"#091e4224"}}]}]},{"type":"paragraph","content":[{"text":"Here’s a sample Tableau worksheet with the Kyvos connection.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":650,"widthType":"pixel"},"content":[{"type":"media","attrs":{"width":1280,"id":"fe5fbc1c-a75c-46a0-af2c-3392afe13af0","collection":"contentId-69341882","type":"file","height":687},"marks":[{"type":"border","attrs":{"size":2,"color":"#091e4224"}}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Connecting Kyvos semantic models using Tableau Data Source connection","type":"text"}]},{"type":"paragraph","content":[{"text":"When you use a TDS file, you will see the dimensions, hierarchies, measures, levels, and attributes as they are configured in the Kyvos semantic model. If you generate a TDS file from the Kyvos web portal and publish it to the Tableau Server, you don’t need to provide the connection details to your users. A TDS file contains the metadata of the semantic model and connection information.","type":"text"}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Create a TDS File in Kyvos","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"From the Kyvos Web portal, click ","type":"text"},{"text":"Toolbox > Utilities","type":"text","marks":[{"type":"strong"}]},{"text":".","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select the ","type":"text"},{"text":"Export Semantic Model Metadata","type":"text","marks":[{"type":"strong"}]},{"text":" option from the list.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Select the semantic model you want to browse and click ","type":"text"},{"text":"Download Selected","type":"text","marks":[{"type":"strong"}]},{"text":".","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"In the ","type":"text"},{"text":"Download Selected Semantic Model Metadata","type":"text","marks":[{"type":"strong"}]},{"text":" dialog box, select the","type":"text"},{"text":" Tableau Data Source (Spark SQL)","type":"text","marks":[{"type":"strong"}]},{"text":" option from the ","type":"text"},{"text":"Format","type":"text","marks":[{"type":"strong"}]},{"text":" drop-down.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Enter the details in ","type":"text"},{"text":"Tableau Version","type":"text","marks":[{"type":"strong"}]},{"text":", ","type":"text"},{"text":"Server IP/Hostname","type":"text","marks":[{"type":"strong"}]},{"text":", ","type":"text"},{"text":"Server","type":"text","marks":[{"type":"strong"}]},{"text":" ","type":"text"},{"text":"Port","type":"text","marks":[{"type":"strong"}]},{"text":", and optionally the username used to connect.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Click ","type":"text"},{"text":"Download","type":"text","marks":[{"type":"strong"}]},{"text":".","type":"text"}]}]}]},{"type":"heading","attrs":{"level":4},"content":[{"text":"Connecting to Kyvos semantic models using TDS File on Tableau Server or Tableau Desktop","type":"text"}]},{"type":"paragraph","content":[{"text":"Once you have downloaded the TDS file, you can connect Kyvos semantic models using this TDS file on Tableau Server and Tableau Desktop. For this, open the TDS file in Tableau, enter your credentials, and click ","type":"text"},{"text":"Sign In","type":"text","marks":[{"type":"strong"}]},{"text":".","type":"text"}]},{"type":"paragraph","content":[{"text":"Optionally, edit the connection details by using the ","type":"text"},{"text":"Edit Connection ","type":"text","marks":[{"type":"strong"}]},{"text":"option.","type":"text"}]},{"type":"paragraph","content":[{"text":"Publish the TDS file and allow Tableau to pre-load the semantic model metadata. Your semantic model is now ready for your users.","type":"text"}]}],"version":1}

Browser not supported