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.

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 (Beta) Pre-Installed Documentation
MySQL Pre-Installed Documentation
Oracle Pre-Installed Documentation
PostgreSQL Pre-Installed Documentation
Redshift Pre-Installed Documentation
Snowflake Pre-Installed Documentation
SQL Server Pre-Installed Documentation

ElastiCube Connectors

Connector Download Link More Information
Access Pre-Installed Documentation
Bing Download Documentation
Box Download Documentation
CSV Pre-Installed Documentation
Custom REST Pre-Installed Documentation
DynamoDB Download Documentation
Exact Online Download Documentation
Excel Pre-Installed Documentation
Generic ODBC Driver Pre-Installed Documentation
Generic OLE DB Driver Pre-Installed Documentation
Gmail Download Documentation
Google AdWords Pre-Installed Documentation
Google Analytics Pre-Installed Documentation
Google BigQuery (Beta) Pre-Installed Documentation
Google Sheets Pre-Installed Documentation
Heroku Postgres Pre-Installed Documentation
Hive Download Documentation
Microsoft Active Directory Download Documentation
Microsoft Dynamics CRM Download Documentation
MongoDB Download Documentation
MySQL Pre-Installed Documentation
Oracle Pre-Installed Documentation
PostgreSQL Pre-Installed Documentation
Quickbooks Desktop Download Documentation
Quickbooks Online Download Documentation
Redshift Pre-Installed Documentation
Salesforce Pre-Installed Documentation
ServiceNow Download Documentation
Sisense ElastiCube Pre-Installed Documentation
Snowflake Pre-Installed Documentation
Splunk Pre-Installed Documentation
Stripe Download Documentation
SQL Server Pre-Installed Documentation
Teradata Pre-Installed Documentation

Sisense Community Connectors

Community connectors are drivers that connect to certain databases and web applications available to our technical user community. These connectors may require developer expertise to manage or customize. Sisense Support does not provide support for Community connectors, however you can contact Sisense Support for consultation and basic troubleshooting. For some connectors, certain limitations on data volume, tables, and refresh will apply.

Connector More Information
Facebook Documentation
Facebook Ads Documentation
HubSpot Documentation
Intacct Documentation
MailChimp Documentation
Microsoft Dynamics NAV Documentation
Sharepoint Documentation
Twitter Documentation
Xero Documentation
Youtube Documentation
Youtube Analytics Documentation

Connecting to More Data Sources, Frameworks and Data Integration Partners

You can connect to many additional data sources by leveraging Sisense’s generic frameworks such as the Generic ODBC driver, 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.

You may want to use third-party data integration providers, especially if you are working with large amounts of data from technically intensive web sources. Sisense's preferred data integration partners include StitchData and Fivetran.