As Snowflake transitions to requiring Key Pair authentication, there is uncertainty regarding the compatibility of v2 generated key pairs with Sisense. Sisense documentation currently recommends usin...
16Views
0likes
0Comments
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 whitelis...
519Views
0likes
0Comments
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 conne...
1.1KViews
0likes
0Comments
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 popula...
640Views
0likes
0Comments
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...
935Views
0likes
0Comments
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 t...
1.3KViews
0likes
0Comments
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...
895Views
0likes
0Comments
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 encrypte...
1.2KViews
0likes
0Comments
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 fo...
1.1KViews
0likes
0Comments
Connecting to Quickbooks online.
Begin with downloading the connector.
Create an app in Quickbooks online environment
Creating an App You can follow the steps below to create an app and ob...
1.4KViews
0likes
0Comments
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...
11KViews
1like
0Comments
Download: RatesAPI Connector Introduction: This article will explain how to make a REST API connection to Rates a public currency conversion API Purpose/Benefits: Currency conversion may not...
814Views
0likes
0Comments
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 ...
5.2KViews
0likes
0Comments
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 Mic...
568Views
0likes
0Comments
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.sis...
1.1KViews
0likes
0Comments
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 ...
532Views
0likes
0Comments
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:\P...
845Views
0likes
0Comments
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.dremi...
2.6KViews
0likes
0Comments
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-requisites
Configure JIRA Server to allow O...
1.3KViews
0likes
0Comments
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...
1.7KViews
0likes
0Comments