Introduction to Data Sources

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:

  1. 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
  2. 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. For those that are not pre-installed in Sisense, click here to download them. 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: Connectors provided by certified partners: 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:

Vendor JDBC Connectors

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

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:

Contact your Account Executive or Customer Success Manager to discuss the full functionality 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:

General Limitations