Introduction to Data Sources

Applicable to Sisense on Linux and Microsoft Windows

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.

• Azure Synapse

• Google BigQuery
• MemSQL
• MySQL
• Oracle
• PostgreSQL
• Redshift
• Snowflake
• SQL Server

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.

• Access *
• Airtable *
• Asana *
• Athena **
• Azure Data Management *
• Azure Synapse
• Azure Table Storage *
• Bing Ads *
• Bing Search *
• Box *
• Cassandra *
• CosmosDB *
• CouchBase *
• CSV
• Custom REST
• DataRobot *
• Dropbox *
• DynamoDB *
• Elasticsearch *
• ElastiCube *
• Email *
• Exact Online *
• Excel Services
• Excel
• Exchange *
• Facebook *
• FTP *
• Generic JDBC Driver
• Generic ODBC Driver **
• Generic OLE DB Driver **
• Gmail *
• Google AdWords
• Google Analytics *
• Google BigQuery
• Google Cloud Spanner *
• Google Drive *
• Google Sheets
• GreenPlum *
• HBase *
• Heroku Postgres
• Hive *
• HubSpot *
• IBM Cloud SQL Query *
• IBM Cloudant *
• Impala *
• Instagram *
• Intacct *
• JDBC-ODBC Bridge Driver *
• Jira *
• JSON *
• LDAP *
• LinkedIn *
• MailChimp *
• MariaDB *
• MarkLogic *
• MemSQL
• Microsoft Active Directory *
• Microsoft Dynamics CRM *
• Microsoft Dynamics Nav *
• MongoDB
• MySQL
• OData *
• Oracle
• Parquet *
• Phoenix *
• PostgreSQL
• Presto *
• Quickbooks Desktop *
• Quickbooks Online *
• Redis *
• Redshift
• REST *
• Salesforce
• SAP Fieldglass *
• SAP HANA *
• SAP Hybris C4C *
• SendGrid *
• ServiceNow *
• SFTP *
• SharePoint *
• SharePoint Excel Services *
• Sisense ElastiCube
• Shopify *
• Snowflake
• SparkSQL *
• Splunk *
• Stripe *
• SQL Analysis Services *
• SQL Server
• SugarCRM *
• SurveyMonkey *
• Sybase *
• Sybase IQ *
• Teradata *
• Twilio *
• Twitter *
• Xero *
• XML *
• YouTube *
• YouTube Analytics *
• Zendesk *
• Other Connectors *

* 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.

** This connector is not supported for Linux environments.

Notes for the certified connectors:

• 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 instructions on connecting to certified connectors not included in the above list, see Connecting to JDBC Connectors Using CData 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 Sisense technology partners provide, and to start your free trial.

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

Vendor JDBC Connectors

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

• Azure Data Explorer
• ClickHouse
• Denodo
• Dremio
• IBM DB2 (Connecting to IBM DB2)
• Impala
• PrestoDB
• Vertica

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:

• Google Analytics (Visits and Revenue and Transactions)
• ServiceNow
• Microsoft Dynamic CRM
• Facebook Page Insights
• Facebook Ads

A dashboard example for Facebook Page Insights: