Knowledge Base
cancel
Showing results for 
Search instead for 
Did you mean: 

Knowledge Base Articles

How to create JDBC connector on a new Framework

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...

intapiuser by Community Team Member
  • 475 Views
  • 0 comments
  • 0 kudos

How to delete connections from Quick Access

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. ...

intapiuser by Community Team Member
  • 582 Views
  • 0 comments
  • 0 kudos

Developing Custom REST Connectors

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...

intapiuser by Community Team Member
  • 402 Views
  • 0 comments
  • 0 kudos

Moving JSON data to the ElastiCube

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...

intapiuser by Community Team Member
  • 781 Views
  • 0 comments
  • 0 kudos

Quickbooks Online: Customizing Table Schemas

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...

intapiuser by Community Team Member
  • 857 Views
  • 0 comments
  • 0 kudos

WooCommerce Rest API Connector

PURPOSEWooCommerce provides a REST API for many different operations within their platform.  This API provides endpoints with data that can be pulled into the elasticube in order to analyze store performance.  (Sales, products, coupons, etc)  This po...

intapiuser by Community Team Member
  • 751 Views
  • 0 comments
  • 0 kudos

MediaMath REST API Connector

PURPOSEMediaMath provides a REST API for many different operations within their platform.  This includes a reports API for downloading data for analytics.  This post describes how to use Sisense's REST API Framework to authenticate & download data fr...

intapiuser by Community Team Member
  • 491 Views
  • 0 comments
  • 0 kudos

IP Lookup Data Connector

Download: IP Lookup ConnectorIntroduction:This article will explain how to make a REST API connection to IP Geolocation in order to retrieve information about IP addresses.This connector will select IP addresses from data in your ElastiCube and provi...

intapiuser by Community Team Member
  • 581 Views
  • 0 comments
  • 0 kudos

Currency Conversion Data Connector

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...

intapiuser by Community Team Member
  • 507 Views
  • 0 comments
  • 0 kudos

Getting Started With DbVisualizer

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...

intapiuser by Community Team Member
  • 3545 Views
  • 0 comments
  • 0 kudos

Connecting To Zoho Using The Zoho Reports API

Introduction This article will explain how to set up the Zoho Reports API and extract CSV data using an automated python script.   Purpose/Benefit Zoho is a cloud based CRM and HR tool.  It has many modules that help create better workflows for busi...

intapiuser by Community Team Member
  • 854 Views
  • 0 comments
  • 0 kudos

Set Up A Table In A REST Connector

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...

intapiuser by Community Team Member
  • 343 Views
  • 0 comments
  • 0 kudos

Connecting To SalesForce Marketing Data

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...

intapiuser by Community Team Member
  • 477 Views
  • 0 comments
  • 0 kudos

BambooHR Data Connector

The connector will work on Sisense version 7.1 and upHere are the steps for connecting to BambooHR data:Unzip this folder REST.Bamboo.Connector.zip and place it in the connector directory: C:\Program Files\Sisense\DataConnectors\DotNetContainer\Conne...

intapiuser by Community Team Member
  • 418 Views
  • 0 comments
  • 0 kudos

Dremio ODBC Connection

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...

intapiuser by Community Team Member
  • 1688 Views
  • 0 comments
  • 0 kudos

Connect To JIRA Server Using CData JDBC Driver

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 ...

intapiuser by Community Team Member
  • 748 Views
  • 0 comments
  • 0 kudos

Harvest REST API Connector

Harvest Rest API Connector   Harvest provides an API framewok to support valid applications connecting and in our case pulling data for analytics.   This Rest configuration will allow you to pull from the Harvest Rest API service.  Please refer to p...

intapiuser by Community Team Member
  • 466 Views
  • 0 comments
  • 0 kudos
Labels