Introduction to Data Sources
  • 08 May 2022
  • 3 Minutes to read
  • Contributors
  • Dark
    Light
  • PDF

Introduction to Data Sources

  • Dark
    Light
  • PDF

Connecting to your data is the first step in analyzing your business information. Sisense has native connectors to many SQL databases, NoSQL sources, and popular web applications.

For a short video overview of connecting to data, see below.

Data Source Connection Types

There are two ways you can connect to your data sources. The connection type you choose depends on your use-case and the data source:

  • Live - Live connections connect directly to the data source. Use a Live connection if your data changes frequently and your dashboard must reflect this.
    Learn more about Live Connect.
  • Elasticube - Import your data into the ElastiCube to take advantage of Sisense’s high performance database.
    Learn more about ElastiCubes.

Live Data Source Connectors

The following is a list of supported Live data source connectors, all of which are pre-installed in Sisense. Click a connector to view documentation about it.

ElastiCube Data Source Connectors

The following is a list of supported ElastiCube data source connectors. ElastiCube data source connectors that are not pre-installed in Sisense can be downloaded from here. Click a connector to view documentation about it.

Connector

Provide by a Certified Partner*

Supported on Linux

Supported on Windows

Access

Yes

Yes

Yes

Airtable

Yes

Yes

Yes

Asana

Yes

Yes

Yes

Athena

No

Yes

Yes

Azure Data Management

Yes

Yes

Yes

Azure Synapse

No

Yes

Yes

Azure Table Storage

Yes

Yes

Yes

Bing Ads

Yes

Yes

Yes

Bing Search

Yes

Yes

Yes

Box

Yes

Yes

Yes

Cassandra

Yes

Yes

Yes

CosmosDB

Yes

Yes

Yes

CouchBase

Yes

Yes

Yes

CSV

No

Yes

Yes

Custom REST

No

Yes

Yes

DataRobot

Yes

Yes

Yes

Dropbox

Yes

Yes

Yes

DynamoDB

Yes

Yes

Yes

Elasticsearch

Yes

Yes

Yes

ElastiCube

Yes

Yes

Yes

Email

Yes

Yes

Yes

Exact Online

Yes

Yes

Yes

Excel Services

No

Yes

Yes

Excel

No

Yes

Yes

Exchange

Yes

Yes

Yes

Facebook

Yes

Yes

Yes

FTP

Yes

Yes

Yes

Generic JDBC Driver

No

Yes

Yes

Generic ODBC Driver

No

No

Yes

Generic OLE DB Driver

No

No

Yes

Gmail

Yes

Yes

Yes

Google AdWords

No

Yes

Yes

Google Analytics

Yes

Yes

Yes

Google BigQuery

No

Yes

Yes

Google Cloud Spanner

Yes

Yes

Yes

Google Drive

Yes

Yes

Yes

Google Sheets

No

Yes

Yes

GreenPlum

Yes

Yes

Yes

HBase

Yes

Yes

Yes

Heroku Postgres

No

Yes

Yes

Hive

Yes

Yes

Yes

HubSpot

Yes

Yes

Yes

IBM Cloud SQL Query

Yes

Yes

Yes

IBM Cloudant

Yes

Yes

Yes

Impala

Yes

Yes

Yes

Instagram

Yes

Yes

Yes

Intacct

Yes

Yes

Yes

JDBC-ODBC Bridge Driver

Yes

Yes

Yes

Jira

Yes

Yes

Yes

JSON

Yes

Yes

Yes

LDAP

Yes

Yes

Yes

LinkedIn

Yes

Yes

Yes

MailChimp

Yes

Yes

Yes

MariaDB

Yes

Yes

Yes

MarkLogic

Yes

Yes

Yes

SingleStore

 

Yes

Yes

Microsoft Active Directory

Yes

Yes

Yes

Microsoft Dynamics CRM

Yes

Yes

Yes

Microsoft Dynamics Nav

Yes

Yes

Yes

MongoDB

No

Yes

Yes

MySQL

No

Yes

Yes

OData

Yes

Yes

Yes

Oracle

No

Yes

Yes

Parquet

Yes

Yes

Yes

Phoenix

Yes

Yes

Yes

PostgreSQL

No

Yes

Yes

Presto

Yes

Yes

Yes

Quickbooks Desktop

Yes

Yes

Yes

Quickbooks Online

Yes

Yes

Yes

Redis

Yes

Yes

Yes

Redshift

No

Yes

Yes

REST

Yes

Yes

Yes

Salesforce

No

Yes

Yes

SAP Fieldglass

Yes

Yes

Yes

SAP HANA

Yes

Yes

Yes

SAP Hybris C4C

Yes

Yes

Yes

SendGrid

Yes

Yes

Yes

ServiceNow

Yes

Yes

Yes

SFTP

Yes

Yes

Yes

SharePoint

Yes

Yes

Yes

SharePoint Excel Services

Yes

Yes

Yes

Sisense ElastiCube

No

Yes

Yes

Shopify

Yes

Yes

Yes

Snowflake

No

Yes

Yes

SparkSQL

Yes

Yes

Yes

Splunk

Yes

Yes

Yes

Stripe

Yes

Yes

Yes

SQL Analysis Services

Yes

Yes

Yes

SQL Server

No

Yes

Yes

SugarCRM

Yes

Yes

Yes

SurveyMonkey

Yes

Yes

Yes

Sybase

Yes

Yes

Yes

Sybase IQ

Yes

Yes

Yes

Teradata

Yes

Yes

Yes

Twilio

Yes

Yes

Yes

Twitter

Yes

Yes

Yes

Xero

Yes

Yes

Yes

XML

Yes

Yes

Yes

YouTube

Yes

Yes

Yes

YouTube Analytics

Yes

Yes

Yes

Zendesk

Yes

Yes

Yes

Other Connectors

Yes

Yes

Yes

Note:

This connector is provided by a certified partner. Sisense carefully evaluates and certifies each external connector to work with Sisense. This helps ensure that external connectors are always up-to-date and fully supported.

Notes for the certified connectors:

  • All certified CData connectors are supported in all versions of Sisense for Linux.
  • The connector drivers are certified for Sisense v7.2 and above.
  • Sisense prior to v8.0: Download a 30-day free-trail of the connector driver. Contact Sisense for the full license version.
  • Sisense v8.0 and above: Download a ready-to-use connector driver.
  • For connecting to certified connectors not included in the above list, see Connecting to JDBC Connectors Using CData Drivers.

Vendor JDBC Connectors

With Sisense's generic JDBC driver you can leverage native JDBC connectors to connect to the following additional data sources:

  • Azure Data Explorer
  • ClickHouse
  • Denodo
  • Dremio
  • IBM DB2
  • Impala
  • Neo4j
  • PrestoDB
  • Vertica
  • Yellowbrick

For more information, see Connecting to Vendor JDBC Connectors.

Technology Partner Connectors

Technology partners enable connections to data sources via the data pipeline . They also manage API changes and limits, and deliver comprehensive support as part of their service. Import your data into a data warehouse (such as, Redshift, Google BigQuery, Snowflake, SQL Server, MySQL, and PostgreSQL) to access your data with either ElastiCube or Live data models.
Sisense technology partner connectors include:

  • Adobe Analytics
  • Apple Search Ads
  • AppsFlyer
  • DoubleClick
  • Facebook
  • Facebook Ads
  • Freshdesk
  • LinkedIn Ads
  • Magento
  • Marketo
  • Netsuite
  • Pardot

Contact your Account Executive or Customer Success Manager to discuss the full functionality that Sisense technology partners provide, and to start your free trial.

Learn more about connecting to data sources via the Stitch data pipeline.

Connecting to More Data Sources and Frameworks

You can connect to many additional data sources by leveraging Sisense’s generic frameworks such as the Connecting via ODBC Drivers, JDBC driver, JDBC Federator, Custom REST Framework. and the New Connectors Framework.

Sisense supports these frameworks with frequent upgrades and new functionality. However, full connectors to specific data sources created through these frameworks are not supported.

Dashboard Examples for Selected Connectors

Sisense has created dashboard examples for a number of connectors to help and inspire you when creating dashboards from the data set of these and other connectors. Click on the links to learn more:

A dashboard example for Facebook Page Insights:
8-6facebook-dash-example.png

General Limitations

  • Sisense for Windows handles Boolean field types differently from Sisense for Linux. If you use the Boolean field type, when migrating to Sisense for Linux, enable the boolToTextCapitalized feature so that Sisense for Linux correctly resolves lower-case Boolean values as upper-case.
  • Generic ODBC and OLE DB drivers are not supported in Sisense for Linux. Instead, use JDBC connectors. For more information, see Connecting to JDBC.

Was this article helpful?