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:

  • 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 Introducing Live Models.
  • Elasticube - Import your data into the ElastiCube to take advantage of Sisense's high performance database.
    Learn more about Introducing 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

Connecting to Access

Yes

Yes

Yes

Airtable

Yes

Yes

Yes

Asana

Yes

Yes

Yes

Connecting to Amazon Athena

No

Yes

Yes

Connecting to Azure Data Management

Yes

Yes

Yes

Connecting to Azure Synapse

No

Yes

Yes

Connecting to Azure Table Storage

Yes

Yes

Yes

Connecting to Bing Ads

Yes

Yes

Yes

Connecting to Bing Search

Yes

Yes

Yes

Connecting to Box

Yes

Yes

Yes

Connecting to Apache Cassandra

Yes

Yes

Yes

Connecting to CosmosDB

Yes

Yes

Yes

Connecting to Couchbase

Yes

Yes

Yes

Connecting to CSV

No

Yes

Yes

Custom REST

No

Yes

Yes

Connecting to Custom Connectors with JDBC Drivers

Yes

Yes

Yes

Connecting to Dropbox

Yes

Yes

Yes

Connecting to DynamoDB

Yes

Yes

Yes

Elasticsearch

Yes

Yes

Yes

Connecting to Elasticsearch

Yes

Yes

Yes

Email

Yes

Yes

Yes

Connecting to Exact Online

Yes

Yes

Yes

Excel Services

No

Yes

Yes

Connecting to Excel

No

Yes

Yes

Exchange

Yes

Yes

Yes

Introduction to Data Sources

Yes

Yes

Yes

Connecting to FTP

Yes

Yes

Yes

Deploying a Custom Connector

No

Yes

Yes

Connecting via ODBC Drivers

No

No

Yes

Connecting via OLE DB Drivers

No

No

Yes

Connecting to Gmail

Yes

Yes

Yes

Connecting to Google BigQuery

No

Yes

Yes

Google Cloud Spanner

Yes

Yes

Yes

Connecting to Google Drive

Yes

Yes

Yes

Connecting to Google Sheets

No

Yes

Yes

Connecting to Greenplum

Yes

Yes

Yes

Connecting to Apache HBase

Yes

Yes

Yes

Connecting to Heroku Postgres

No

Yes

Yes

Connecting to Hadoop via Hive

Yes

Yes

Yes

Connecting to HubSpot

Yes

Yes

Yes

IBM Cloud SQL Query

Yes

Yes

Yes

IBM Cloudant

Yes

Yes

Yes

Impala

Yes

Yes

Yes

Connecting to Instagram

Yes

Yes

Yes

Connecting to Sage Intacct

Yes

Yes

Yes

JDBC-ODBC Bridge Driver

Yes

Yes

Yes

Connecting to Jira

Yes

Yes

Yes

Connecting to JSON

Yes

Yes

Yes

LDAP

Yes

Yes

Yes

Connecting to LinkedIn

Yes

Yes

Yes

Connecting to MailChimp

Yes

Yes

Yes

Connecting to MariaDB

Yes

Yes

Yes

MarkLogic

Yes

Yes

Yes

Connecting to SingleStore

 

Yes

Yes

Connecting to Microsoft Active Directory

Yes

Yes

Yes

Connecting to Microsoft Dynamics CRM

Yes

Yes

Yes

Connecting to DynamicsNav

Yes

Yes

Yes

Connecting to MongoDB

No

Yes

Yes

Connecting to MySQL

No

Yes

Yes

Connecting to OData

Yes

Yes

Yes

Connecting to Oracle

No

Yes

Yes

Parquet

Yes

Yes

Yes

Phoenix

Yes

Yes

Yes

Connecting to PostgreSQL

No

Yes

Yes

Presto

Yes

Yes

Yes

Connecting to QuickBooks Desktop

Yes

Yes

Yes

Connecting to QuickBooks Online

Yes

Yes

Yes

Connecting to Redis

Yes

Yes

Yes

Connecting to Amazon Redshift

No

Yes

Yes

Connecting to REST

Yes

Yes

Yes

Connecting to Salesforce

No

Yes

Yes

SAP Fieldglass

Yes

Yes

Yes

SAP HANA

Yes

Yes

Yes

SAP Hybris C4C

Yes

Yes

Yes

Connecting to SendGrid

Yes

Yes

Yes

Connecting to ServiceNow

Yes

Yes

Yes

SFTP

Yes

Yes

Yes

SharePoint

Yes

Yes

Yes

Connecting to SharePoint Excel Services

Yes

Yes

Yes

Connecting to Sisense ElastiCubes

No

Yes

Yes

Connecting to Shopify

Yes

Yes

Yes

Connecting to Snowflake

No

Yes

Yes

Connecting to SparkSQL

Yes

Yes

Yes

Connecting to Splunk

Yes

Yes

Yes

Connecting to Stripe

Yes

Yes

Yes

SQL Analysis Services

Yes

Yes

Yes

Connecting to SQL Server

No

Yes

Yes

Connecting to SugarCRM

Yes

Yes

Yes

SurveyMonkey

Yes

Yes

Yes

Sybase

Yes

Yes

Yes

Sybase IQ

Yes

Yes

Yes

Connecting to Teradata

Yes

Yes

Yes

Connecting to Twilio

Yes

Yes

Yes

Connecting to Twitter

Yes

Yes

Yes

Connecting to Xero Accounting

Yes

Yes

Yes

Connecting to XML

Yes

Yes

Yes

Connecting to YouTube

Yes

Yes

Yes

Connecting to 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 Custom Connectors with JDBC Drivers.

Vendor JDBC Connectors

With Sisense's Deploying a Custom Connector 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 Custom Connectors with JDBC Drivers.

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 Connecting to Web Sources Using Stitch.

Connecting to More Data Sources and Frameworks

You can connect to many additional data sources by leveraging Sisense's generic frameworks such as Connecting via ODBC Drivers, Deploying a Custom Connector, 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

  • 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 Deploying a Custom Connector.