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 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...
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...
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...
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...
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...
Download: Coinbase Connector Introduction: This article will explain how to make a REST API connection to Coinbase's API Purpose/Benefits: This connector gives you the ability to pull in data about cryptocurrencies from Coinbase into your Sisense El...
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 ...
Connecting Sisense to Local SQL Server in Sisense version 7.4.4 and newer Open SQL server and initially connect using windows Authentication.Go to Security > Logins, right click and Create new user as seen in example below.3. Next go to “User Mapping...
Intro One may want to delete the connection credentials entered in ElastiCube Manager. This to prevent other users who have access to the server, being able to connect to the data source on their own - and getting access to sensitive data. steps: ...
Introduction: This post describes how to query your MSSQL, MySQL or Oracle DB to get the breakdown of the amount of rows in the DBs. Prerequisites: 1. MSSQL / MySQL / Oracle DB 2. SQL Client Access to the DB (including Username and Password) Procedu...
By default the MS SQL Server data connector will use the MS SQL Server default port 1443.To connect using a different port, use the portNumber parameter in the Additional Parameters field to specify the new port number.For example, to use port 5555 a...
Recommended Quick Links
Developers:
Product Feedback Forum:
Need additional support?:
The Legal Stuff
Have a question about the Sisense Community?
Email community@sisense.com
