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...
Question: When trying to connect to Google Adwords via the Elasticube Manager, you may run into the issue of not getting any email accounts you can choose from, or receiving an error saying there is no email account. Solution: Follow the below inst...
If you organization has Excel documents stored within Sharepoint that you would like to bring into the ElastiCube Manager, you may chose to use a CDATA driver to bring this data in using an ODBC connection. Below are some lessons learned in setting ...
In order to generate a profit and loss report from the QuickBooks Desktop Connector, you will need the following tables. AccountCustom Profit & Loss Detail The Account table is a standard table available with the CData connector, while the custom ta...
Connecting to Oracle DB with Service Name (instead of Service ID - SID) When a customer tries to connect to an Oracle DB using a Direct Connection option, there's no option in the GUI in the ElastiCube Manager to use a Service Name, only a Service ...
Determine Driver's Class Name for JDBC Connector Question How do you determine the Driver’s Class Name from the JDBC driver file that is installed with the Sisense JDBC Connector? Prerequisites: Sisense Data Administrator may require a separate JDB...
Question How to change the connection strings in an easy way? Answer Using the REST API you can update the data connection strings directly. Returns a list of all your connections: GET http://localhost:8081/api/v1/connection Updates a connection: ...
