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...
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...
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...
This document describes how to use a linked SQL Server to execute commands to external data sources (in this case - Netsuite), and create accumulated Transactions Tables with SQL JOBS. Before you Begin Make sure to install the ODBC for your databas...
This post describes methods of importing JSON data into Sisense ElastiCubes. JSON is a file format consisting of arrays of key-value pairs wrapped in braces ("{}"). It is increasingly common with the popularity of NoSQL databases, and it is the typic...
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...
A Secure Shell (SSH) tunnel consists of an encrypted tunnel created through an SSH protocol connection. Users may set up SSH tunnels to transfer unencrypted traffic over a network through an encrypted channel. The purpose of the document is to specif...
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...
Connecting to Quickbooks online.Begin with downloading the connector.Create an app in Quickbooks online environmentCreating an AppYou can follow the steps below to create an app and obtain the OAuth client credentials, the consumer key and consumer s...
Analytical Need I have historical transactional data starting from 2012. Some are recorded in USD, others in EUR. I need to convert these values to USD based on the exchange rate on the date of the transaction. My Elasticube is built on a daily bas...
Download: RatesAPI ConnectorIntroduction:This article will explain how to make a REST API connection to Rates a public currency conversion APIPurpose/Benefits:Currency conversion may not be available in your data.With this connector you can convert c...
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...
When trying to connect to a fixed length file you will need to go through a few steps to bring it into the ElastiCube.2. After installing, Create a System DSN in the ODBC Data Sources using the Microsoft Access Text Driver that you just installed.3. ...
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...
This article explains how to set up a table in a REST Connector when the response to the API Endpoint is an array. Sisense expects the results returned in the format of JSON documents. If an array is returned, Sisense converts the array into a docume...
This connector uses cdata jdbc driver found here: https://www.cdata.com/drivers/salesforcemarketing/jdbc/After you run the installer, the files you are going to want to copy is found here:C:\Program Files\CData\CData JDBC Driver for Salesforce Market...
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...
Please note, these instructions are to connect with the JDBC CData driver to JIRA Server. These steps will not work for JIRA Cloud at this time.Pre-requisitesConfigure JIRA Server to allow OAuth connections, as described in the following link, under ...
Introduction This forum post will demonstrate how to add data located in a shared network folder to your desired ElastiCube. Purpose In many cases we wish to import data located in a shared network folder to the ElastiCube. To do so, we need to execu...
When using one of the file hosting sites (HTTP or HTTPS, Amazon S3, Azure Blob Storage, Google Drive, Box, Dropbox, Sharepoint, AzureDataLakeStoreGen2, AzureDataLakeStoreGen2 with SSL, FTP or FTPS, SFTP) you are able to connect to that DB by using ou...
