{"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":"heading","attrs":{"level":2},"content":[{"text":"Overview","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Specify required imports","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Prepare the request","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Call the method executeOlapQuery","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Use the response","type":"text"}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Example","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Specify required imports.","type":"text"}]},{"type":"codeBlock","content":[{"text":"import org.olap4j.Cell;\nimport org.olap4j.CellSet;\nimport org.olap4j.OlapConnection;\nimport org.olap4j.OlapStatement;\nimport org.olap4j.Position;","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Prepare the request.","type":"text"}]},{"type":"codeBlock","content":[{"text":"Class.forName(\"org.olap4j.driver.xmla.XmlaOlap4jDriver\");\n/* Append “xmlaKyvos” to your Kyvos URL in below statement.\nCatalog is the folder name where the semantic model is saved to run MDX query else give [Root] here.\nSpecify “KYVOS” under DataSource.*/\n Connection connection =\nDriverManager.getConnection(“jdbc:xmla:Server=http://localhost:8080/kyvos/xmlaKyvos;User=Admin;Password=Admin;Catalog=FlightShopDetails;DataSource=KYVOS\");\nOlapConnection olapConnection = connection.unwrap(OlapConnection.class);\nOlapStatement statement = olapConnection.createStatement();\nString mdx = \"SELECT [Measures].[Miles Traveled] DIMENSION PROPERTIES [MEMBER_UNIQUE_NAME],[MEMBER_CAPTION] ON COLUMNS,NON EMPTY CROSSJOIN( [Travel Agent].[Hierarchy].[Travel Agent].AllMembers, [Departure Airport].[Hierarchy].[Departure Country].AllMembers) DIMENSION PROPERTIES [MEMBER_UNIQUE_NAME],[MEMBER_CAPTION] ON ROWS FROM [Flight Shop Analysis]\";","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Call the method to execute OlapQuery.","type":"text"}]},{"type":"codeBlock","content":[{"text":"CellSet cellSet = statement.executeOlapQuery(String mdx, boolean getMemberDetails);\n/*Pass getMemberDetails as false to avoid sending further request for each member to fetch extra information like member’s parent, child count, etc. This would ensure a faster response.*/","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":" Method to execute MDX and return generate response in a file. ","type":"text"}]},{"type":"codeBlock","attrs":{"language":"java"},"content":[{"text":"/** \nMethod to execute mdx and return generate response in a file. \n@param query MDX Query \n@param localProp fileLocation, fileLocation \n@param queryProperties \n@throws OlapException \n*/ \npublic void executeOlapTabularQuery(String mdx, Map localProp, Map queryProperties) throws OlapException ","type":"text"}]},{"type":"paragraph","content":[{"type":"hardBreak"},{"text":"Sample ","type":"text"}]},{"type":"codeBlock","attrs":{"language":"java"},"content":[{"text":"package org.olap4j;\n \nimport java.sql.Connection;\nimport java.sql.DriverManager;\nimport java.sql.SQLException;\nimport java.util.HashMap;\n \npublic class Olap4jExecutor {\n \n\t//Location where user want to generate their query response file\n static String outputFileLocation = \"\";\n //Name of file in which query response will be writte. Ex: \n static String outputFileName = \"\";\n //true/false if user requires the response in zipped format\n static String zipped = \"\";\n //CSV/JSON format in which query response needs to be generated\n static String outputFormat = \"\";\n //Below parameters can be used for defining custom separator for response\n static String fieldSeparator = \"\";\n static String lineSeparator = \"\";\n static String enclosure = \"\";\n static String columnHeaderSeparator = \"\";\n //true/false if following details are required in response\n static String includeHeader = \"\";\n static String keepMeasureFormatting = \"\";\n //HIERARCHICAL/CLASSICAL type of response user want to be generated. Default response is of Hierarchical type\n static String tabularViewType = \"\";\n //Integer value, If user want the the limited records in the response file\n static String maxRow = \"\";\n static String maxColumn = \"\";\n static HashMap localProps = new HashMap<>();\n static HashMap serverProps = new HashMap<>();\n static String connectionURL = \"jdbc:xmla:Server=\" + \"http://:/kyvos/xmlaKyvos\" + \";User=\" + \"Admin\" + \";Password=\" + \"Admin\" + \";Catalog=\" + \"\" + \";DataSource=Kyvos\";\n \n\tpublic static void main(String[] args) throws ClassNotFoundException, SQLException {\n\t\ttry {\n Class.forName(\"org.olap4j.driver.xmla.XmlaOlap4jDriver\");\n String connectionURL = \"jdbc:xmla:Server=\" + \"http://:/kyvos/xmlaKyvos\"\n + \";User=\" + \"Admin\" + \";Password=\" + \"Admin\" + \";Catalog=\" + \"\" + \";DataSource=Kyvos\"; \n try (Connection connection = DriverManager.getConnection(connectionURL);\n OlapConnection olapConnection = connection.unwrap(OlapConnection.class);\n OlapStatement statement = olapConnection.createStatement()) {\n \n queryParam();\n String mdxQuery = \"\";\n queryExecutor(mdxQuery, statement);\n \n } catch (Exception e) {\n // Handle the exception appropriately, log or display a user-friendly message\n e.printStackTrace();\n }\n } catch (ClassNotFoundException e) {\n // Handle class not found exception\n e.printStackTrace();\n }\n\t}\n \n private static void queryExecutor(String query, OlapStatement statement) throws OlapException {\n statement.executeOlapTabularQuery(query, localProps, serverProps);\n System.out.println(\"Query Execution completed!!! Please find result at following location: \" + outputFileLocation);\n }\n \n private static void queryParam() {\n \tserverProps.put(Enums.RequestType.RequestProperties.OUTPUT_FORMAT, outputFormat);\n serverProps.put(Enums.RequestType.RequestProperties.ZIPPED, zipped);\n serverProps.put(Enums.RequestType.RequestProperties.INCLUDE_HEADER, includeHeader);\n serverProps.put(Enums.RequestType.RequestProperties.KEEP_MEASURE_FORMATTING, keepMeasureFormatting);\n serverProps.put(Enums.RequestType.RequestProperties.ENCLOSURE, enclosure);\n serverProps.put(Enums.RequestType.RequestProperties.OUTPUT_FILE_NAME, outputFileName);\n serverProps.put(Enums.RequestType.RequestProperties.COLUMN_HEADER_SEPARATOR, columnHeaderSeparator);\n serverProps.put(Enums.RequestType.RequestProperties.FIELD_SEPARATOR, fieldSeparator);\n serverProps.put(Enums.RequestType.RequestProperties.LINE_SEPARATOR, lineSeparator);\n serverProps.put(Enums.RequestType.RequestProperties.MAX_COLUMN, maxColumn);\n serverProps.put(Enums.RequestType.RequestProperties.MAX_ROW, maxRow);\n serverProps.put(Enums.RequestType.RequestProperties.TABULAR_VIEW_TYPE, tabularViewType);\n outputFileName = outputFileName + (zipped.equalsIgnoreCase(\"true\") ? \".zip\" : outputFormat);\n localProps.put(Enums.RequestType.RequestProperties.OUTPUT_FILE_LOCATION, outputFileLocation);\n localProps.put(Enums.RequestType.RequestProperties.OUTPUT_FILE_NAME, outputFileName);\n }\n}","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Use the response.","type":"text"}]},{"type":"codeBlock","content":[{"text":"private static void getResponse(CellSet cellSet){\n List cellSetAxes = cellSet.getAxes();\n for (Position row : cellSetAxes.get(0))\n {\n if(cellSetAxes.size() > 1)\n {\n for (Position column : cellSetAxes.get(1))\n {\n for (Member member : row.getMembers())\n {\n System.out.print(member.getName() + \":\" + \" \");\n }\n for (Member member : column.getMembers())\n {\n System.out.println(member.getName() + \"=\" + \" \");\n }\n final Cell cell = cellSet.getCell(row, column);\n System.out.println(cell.getValue());\n }\n }\n else\n {\n for (Member member : row.getMembers())\n {\n System.out.println(member.getName());\n }\n final Cell cell = cellSet.getCell(row);\n System.out.println(cell.getValue());\n System.out.println();\n }\n }","type":"text"}]}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Token based SSO","type":"text"}]},{"type":"paragraph","content":[{"text":"In the above example, basic authentication is used with a connection URL. But sometimes, users do not want to use their credentials in some scenarios. To deal with such scenarios, Kyvos provides another authentication mechanism which is token-based SSO. Users can invoke Kyvos Login REST API to get a token and then use that token with a connection URL. Users will have to perform the following steps to use token-based SSO.","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Get a token using passwordless authentication in login REST API.","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":"To get the token using passwordless authentication, make the following configuration changes:","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":" ","type":"text","marks":[{"type":"strong"}]},{"text":"Set the value for the authentication ","type":"text"},{"text":"provider","type":"text","marks":[{"type":"strong"}]},{"text":" as ","type":"text"},{"text":"HOST_APP ","type":"text","marks":[{"type":"strong"}]},{"text":"in the ","type":"text"},{"text":"config.json","type":"text","marks":[{"type":"strong"}]},{"text":" file. ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":" ","type":"text","marks":[{"type":"strong"}]},{"text":"Provide the value for the ","type":"text"},{"text":"userAuthenticationVerificationUrl","type":"text","marks":[{"type":"strong"}]},{"text":" property in the ","type":"text"},{"text":"config.json","type":"text","marks":[{"type":"strong"}]},{"text":". This property is used for password less SSO, details are mentioned in below section.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":" ","type":"text","marks":[{"type":"strong"}]},{"text":"Provide value for EXT_AUTH_HEADER_ID property in the ","type":"text"},{"text":"properties","type":"text","marks":[{"type":"strong"}]},{"text":" file. ","type":"text"},{"text":"EXT_AUTH_HEADER_ID","type":"text","marks":[{"type":"strong"}]},{"text":" defines parameter name(request parameter name) against which user token would be provided.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":" Get token with username and token (password less authentication)","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"In this authentication mode (password less), Kyvos relies on the verification server for user authentication. Below is the flow diagram and its description: ","type":"text"},{"type":"hardBreak"},{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.migration","extensionKey":"inline-media-image","parameters":{"width":"750","id":"c9134bb2-b8a9-439a-b18f-5bd356f57b9a","collection":"contentId-45191305","height":""}}},{"type":"hardBreak"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"To get a session ID from Kyvos, the client application will have to call Kyvos login REST API by passing the following parameters:","type":"text"},{"type":"hardBreak"},{"text":"username, bearer token (GUID), mode=INTEGRATION, and optional custom data.","type":"text"},{"type":"hardBreak"},{"text":"http::/kyvos/rest/login?username=&token=&mode=INTEGRATION&customData=","type":"text","marks":[{"type":"strong"}]},{"text":" ","type":"text"},{"type":"hardBreak"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Kyvos validates parameter values received in the login REST by making the REST call to the verification server on ","type":"text"},{"text":"userAuthenticationVerificationUrl","type":"text","marks":[{"type":"strong"}]},{"text":" with username, token, and custom data.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The verification server validates the data, ensures that given parameters are valid, and returns true or false based on successful validation or failure.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":" If this verification REST call returns true as the HTTP response, then the SSO is successful, and the user session is created in Kyvos. Kyvos login REST call would return the successful response for this user session. For example, on successful authentication, REST API produces the response as:","type":"text"},{"type":"hardBreak"}]},{"type":"codeBlock","content":[{"text":"{ \n\"RESPONSE\": { \n\"SUCCESS\": \"90DB354A-EE34-6827-B3E2-2BAAECE5C2E2\" \n} \n} ","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"In the above response, the value of the SUCCESS key is the token. Users can use this token for authentication with the connection URL as mentioned in the below example.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"If the verification REST call returns a false response, the Kyvos login REST call will not issue any success response and SSO will fail.","type":"text"},{"type":"hardBreak"}]}]}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Using Olap4j API with a token-based authentication (password less authentication)","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"paragraph","content":[{"text":"Users can obtain a token from login REST API and can use the same for the authentication in Olap4j API. The user has to pass this token as a query parameter in the connection URL.","type":"text"},{"type":"hardBreak"},{"text":"The parameter name should be the value of EXT_AUTH_HEADER_ID provided in the kyvosclient.properties file.","type":"text"},{"type":"hardBreak"},{"text":"The connection URL should be in the below-mentioned format:","type":"text"},{"type":"hardBreak"},{"text":"http://www.kyvosinsights.com:8081/kyvos/xmlaKyvos","type":"text","marks":[{"type":"link","attrs":{"href":"http://www.kyvosinsights.com:8081/kyvos/xmlaKyvos"}}]},{"text":"?","type":"text"},{"text":"=","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"Example: ","type":"text"},{"type":"hardBreak"},{"text":"If ","type":"text"},{"text":"EXT_AUTH_HEADER_ID=username ","type":"text","marks":[{"type":"strong"}]},{"text":"and ","type":"text"},{"text":"token=4EB72FAD-B899-D331-BB86-A8895883A870","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":"then XMLA connection URL will be: ","type":"text"},{"text":"http://www.kyvosinsights.com:8081/kyvos/xmlaKyvos?username=4EB72FAD-B899-D331-BB86-A8895883A870","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"You can use this connection URL in the code provided in the examples while using the token, do not provide any username and password.","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Examples","type":"text"}]},{"type":"paragraph","content":[{"text":"Code to get the token from REST API.","type":"text"}]},{"type":"codeBlock","content":[{"text":"String userName = \nString password = \nString kyvos_url = +\"rest/login\";\nURL obj = new URL(kyvos_url);\nHttpURLConnection con = (HttpURLConnection) obj.openConnection();\ncon.setRequestProperty(\"Accept\", \"application/json\");\ncon.setRequestMethod(\"POST\");\nString urlParameters = \"username=\"+userName+\"&token=&mode=INTEGRATION&customData={\\\"HOST_NAME\\\":\\\"localhost.kyvosinsights.com\\\"}\";\ncon.setDoOutput(true);\nDataOutputStream wr = new DataOutputStream(con.getOutputStream());\nwr.writeBytes(urlParameters);\nwr.flush();\nwr.close(); \nint responseCode = con.getResponseCode();\nInputStream in = null.\nif (responseCode! =200) {\nin = con.getErrorStream();\n} else {\n in = con.getInputStream();\n}\nBufferedReader br = new BufferedReader(new InputStreamReader(in));\nString inputLine;\nStringBuffer responseStr = new StringBuffer();\nwhile ((inputLine = br.readLine()) != null) {\n responseStr.append(inputLine);\n}\nbr.close();\n//extract token from the response.\nString responseString = responseStr.toString();\nSystem.out.println(\"responseString = \"+responseString);\n// response = {\"RESPONSE\": {\"SUCCESS\":\"49CD3E8C-1D9F-1025-5B5D-19393E8DEBA3\"}}","type":"text"}]},{"type":"paragraph","content":[{"text":"Use the value of the ","type":"text"},{"text":"SUCCESS","type":"text","marks":[{"type":"strong"}]},{"text":" key from the response as a token in the connection URL.","type":"text"}]},{"type":"paragraph","content":[{"text":"Using token in connection URL.","type":"text"}]},{"type":"paragraph","content":[{"text":"if ","type":"text"},{"text":"EXT_AUTH_HEADER_ID_VALUE=username ","type":"text","marks":[{"type":"strong"}]},{"text":"and ","type":"text"},{"text":"token=49CD3E8C-1D9F-1025-5B5D-19393E8DEBA3","type":"text","marks":[{"type":"strong"}]},{"type":"hardBreak"},{"text":"then XMLA connection URL will be:","type":"text"},{"type":"hardBreak"},{"text":"/xmlaKyvos?username=49CD3E8C-1D9F-1025-5B5D-19393E8DEBA3","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"This connection URL can be used with the sample code (Prepare the request) provided in the above example, and there is no need to provide ","type":"text"},{"text":"User=Admin;Password=Admin;","type":"text","marks":[{"type":"strong"}]},{"text":" in this case.","type":"text"}]}],"version":1}

Browser not supported