Resolving Missing Generic JDBC Connector in SisenseThis article addresses the issue where the Generic JDBC connector is not visible under available connectors for users logged in with a designer account in Sisense version 2023.6 or newer. This proble...
Mongo issue and their possible solutions The query translated from SQL to MQL is adding additional unnecessary parameter {"$not": {"$type": 2}} randomly. This leads to the following consequences: index is not included in the execution plan full tabl...
403 error in UI when trying to change the Excel connection to upload a new fileThis article describes what you should check when encountering a 403 error when trying to change an Excel connection to a new source file.Possible root causeThe error can ...
Resolving DBLink Issues in Sisense for Postgres Connections This article addresses the issue of using DBLink with Postgres connections in Sisense. DBLink is a feature in PostgreSQL that allows users to connect and query data across different database...
Resolving Missing Generic JDBC Connector in Sisense This article addresses the issue where the Generic JDBC connector is not visible under available connectors for users logged in with a designer account in Sisense version 2023.6 or newer. This probl...
Steps to do before contacting support regarding build failures What to do and which information about errors to gather before contacting support team to ensure faster resolution of the issue. 1st step for any build error: -Check error logs in UI. Ca...
How to record a .har file and identify if specific requests are present in logs How to record a .har file Open Chrome and go to the page to be recorded. Click the More Actions menu (...) to the right of the toolbar and select More tools > Developer t...
Resolving MongoDB Connector Performance Issues in Sisense Summary This article addresses performance issues caused by the MongoDB connector in Sisense, specifically related to the addition of an unnecessary parameter in queries and as a result, lead...
Resolving Limited Column Retrieval in Sisense API Connection to Jira Summary This article addresses the issue where a Sisense API connection to Jira only retrieves native columns and does not include custom column fields. It provides a step-by-step ...
Symptoms You need to connect to database, however connection is not going through. You have already check the hostname, username, password and everything seems to be correct. You have whitelisted the database address, hostname, etc. however not sur...
Restoring missing connector Introduction Sometimes connectors can go missing for some reason, leading to a breakdown in data connectivity. Restoring these connectors is crucial to maintaining a smooth data flow within your Sisense environment. This...
This article will cover two methods you can use to connect Python to the Elasticube. Method 1: Using ODBCMethod 2: Using the REST API Method 1: Connect to the EC with ODBC Download Sisense ODBC This method will require you to download the ODBC ...
Previously in Linux, Sisense were using so called "Old Framework" for connectors - this means connectors from Windows that were ported to Linux environment. However now Sisense developing the connector designed for Linux specifically. Some portion o...
To remove the connection from the Quick Access, please, use REST API.You need to do the following. For Windows: 1. Go to Admin - REST API - 1.0 2. Use 1.0 GET /users specifying username/first name/last name to get the _id parameter of the user 3. ...
Sisense lets you import data from multiple sources using built-in connectors or by a customized connector. Sisense custom REST connectors framework enable you to program your own connectors to popular data sources which support REST services, to impo...
Problem You want to determine if there are any problems with your dataset from the ElastiCube and whether the question you are asking for Sisense with R integration can be answered by the data that you have. Solution Installing the Sisense ODBC driv...
Introduction If attempting to connect to MongoDB with a user protected password, but you aren't able to connect to the database through the Simba DSN or the connection string and getting the following error: Unable to establish a connection with dat...
Problem There are many data sources (connectors), such as web service APIs where we not familiar with their tables/fields like Facebook, Twitter, Youtube etc. Before importing your data from a web service, you should know the data in advance. This l...
Question: The purpose of this post is to demonstrate how to connect to a Sisense Elasticube from Microsoft Excel. Solution: Begin by installing the Sisense ODBC driver. https://www.sisense.com/data-connectors/odbc/ Once it is installed, go to ODB...
In case you don't know already you can download the Dremio ODBC drivers here: https://www.dremio.com/drivers/odbc/Information for configuring the driver can be found here: https://docs.dremio.com/current/sonar/client-applications/drivers/arrow-fli...
