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:
- 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 - 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.
- 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 *
- SingleStore
- 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:
- 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 instructions on connecting to certified connectors not included in the above list, see Connecting to JDBC Connectors Using CData Drivers.
Vendor JDBC Connectors
With Sisense's generic JDBC driver 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 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:
- Adobe Analytics
- Apple Search Ads
- AppsFlyer
- DoubleClick
- 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.
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:
- Google Analytics (Visits and Revenue and Transactions)
- ServiceNow
- Microsoft Dynamic CRM
- Facebook Page Insights
- Facebook Ads
A dashboard example for Facebook Page Insights:
General Limitations
- Sisense for Windows handles boolean field types differently to 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 aren't supported in Sisense for Linux. Instead, use JDBC connectors. For more information, see Connecting to JDBC.
