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.

There are two ways you can connect to your data sources. You can either import the data into the ElastiCube or you can connect directly to the data source, which is known as a live connection.

Which connection type you choose depends on your use case and the data source itself. Importing your data into the ElastiCube takes advantage of Sisense high performance database. However, if your data changes frequently and your dashboard must reflect this, than a live connection is probably the best choice. Keep in mind however that live connections work only as well as the data source.

The tables below provide a list of supported data sources and links to the documentation for ElastiCube and live data sources.

Live Connectors

Connector Download Link More Information
Google BigQuery Pre-Installed Google BigQuery Live
MemSQL Pre-Installed Connecting to MemSQL Live
MySQL Pre-Installed MySQL Live
Oracle Pre-Installed Oracle Live
PostgreSQL Pre-Installed PostgreSQL Live
Redshift Pre-Installed Amazon Redshift Live
Snowflake Pre-Installed Connecting to Snowflake
SQL Server Pre-Installed SQL Server Live

ElastiCube Connectors

Connector Download Link More Information
Access * Download Connecting to Access
Athena Pre-Installed Connecting to AWS S3 Data with Athena
Azure Data Management * Download Connecting to Azure Data Management
Azure Table Storage * Download Connecting to Azure Table Storage
Bing Ads * Download Connecting to Bing Ads
Bing Search* Download Connecting to Bing Search
Box * Download Connecting to Box
Cassandra * Download Connecting to Apache Cassandra
CosmosDB * Download Connecting to CosmosDB
CSV Pre-Installed Connecting to CSV
CouchBase * Download Connecting to Couchbase
Custom REST Pre-Installed Documentation
Dropbox * Download Connecting to Dropbox
DynamoDB * Download Connecting to DynamoDB
Elasticsearch * Download Connecting to Elasticsearch
Exact Online * Download Connecting to Exact Online
Excel Pre-Installed Connecting to Excel
Facebook * Download Connecting to Facebook
FTP * Download Connecting to FTP
Generic JDBC Driver Pre-Installed Connecting to JDBC
Generic ODBC Driver Pre-Installed Connecting via ODBC Drivers
Generic OLE DB Driver Pre-Installed Connecting via OLE DB Drivers
Gmail * Download Connecting to Gmail
Google AdWords Pre-Installed Connecting to Google Ads
Google Analytics Pre-Installed Connecting to Google Analytics
Google BigQuery Pre-Installed Connecting to Google BigQuery
Google Drive * Download Connecting to Google Drive
Google Sheets Pre-Installed Connecting to Google Sheets
GreenPlum * Download Connecting to Greenplum
HBase * Download Connecting to Apache HBase
Heroku Postgres Pre-Installed Connecting to Heroku Postgres
Hive * Download Connecting to Hadoop via Hive
HubSpot * Download Connecting to HubSpot
Instagram * Download Connecting to Instagram
Intacct * Download Connecting to Sage Intacct
Jira * Download Connecting to Jira
JSON * Download Connecting to JSON
LinkedIn * Download Connecting to Linkedin
MailChimp * Download Connecting to MailChimp
MariaDB * Download Connecting to MariaDB
MemSQL Pre-Installed Connecting to MemSQL
Microsoft Active Directory * Download Connecting to Microsoft Active Directory
Microsoft Dynamics CRM * Download Connecting to Microsoft Dynamics CRM
Microsoft Dynamics Nav * Download Connecting to DynamicsNav
MongoDB Download Connecting to MongoDB
MySQL Pre-Installed Connecting to MySQL
OData * Download Connecting to OData
Oracle Pre-Installed Connecting to Oracle
PostgreSQL Pre-Installed Connecting to PostgreSQL
Quickbooks Desktop * Download Connecting to QuickBooks Desktop
Quickbooks Online * Download Connecting to QuickBooks Online
Redis * Download Connecting to Redis
Redshift Pre-Installed Connecting to Redshift
REST * Download Connecting to REST
Salesforce Pre-Installed Connecting to Salesforce
SendGrid * Download Connecting to SendGrid
ServiceNow * Download Connecting to ServiceNow
SharePoint Excel Services * Download Connecting to SharePoint Excel Services
Sisense ElastiCube Pre-Installed Connecting to Sisense ElastiCubes
Shopify * Download Connecting to Shopify
Snowflake Pre-Installed Connecting to Snowflake
SparkSQL * Download Connecting to SparkSQL
Splunk * Download Connecting to Splunk
Stripe * Download Connecting to Stripe
SQL Server Pre-Installed Connecting to SQL Server
SugarCRM * Download Connecting to SugarCRM
Teradata * Download Connecting to Teradata
Twilio * Download Connecting to Twilio
Twitter * Download Connecting to Twitter
Xero * Download Connecting to Xero Accounting
XML * Download Connecting to XML
YouTube * Download Connecting to YouTube
YouTube Analytics * Download Connecting to YouTube Analytics
Other Connectors * Download Documentation

* Certified connectors are provided by our certificated partner. Sisense carefully evaluates and certifies each external connector to work with Sisense. This helps to ensure that external connectors are always up-to-date and fully supported.

Notes for the certified connectors:

Technology Partner Connectors

Technology partners provide the service of connecting to data sources via the data pipeline, managing API changes and limits, and delivering comprehensive support as part of their service. Import your data into a data warehouse (Redshift, Google BigQuery, Snowflake, SQL Server, MySQL, PostgreSQL, and more) to access your data with either ElastiCube or live data models. Contact your Account Executive or Customer Success Manager to discuss the full functionality our technology partners provide, as well as to start your free trial. For more information, click here.

For instructions on connecting to data sources via the Stitch data pipeline, see here.

Connector Connector Connector
Adobe Analytics Apple Search Ads AppsFlyer
DoubleClick Facebook Facebook Ads
Freshdesk Jira LinkedIn Ads
Magento Marketo Netsuite
Pardot Shopify Twitter Ads
Zendesk And more...  

Vendor JDBC Connectors

With the Sisense's generic JDBC driver you can leverage native JDBC connectors provided by the data source vendors to connect to additional data sources.

Connector Download Link More Information
Azure Data Explorer Download  
ClickHouse Download  
Denodo Download  
Dremio Download  
IBM DB2 Download Connecting to IBM DB2
Impala Download  
PrestoDB Download  
Vertica Download  

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, or Custom REST 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:

Linux Support

Note: For the list of connectors available on Linux, click Linux Connectors.