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 |
|---|---|
| Documentation | |
| Facebook Ads | Documentation |
| HubSpot | Documentation |
| Intacct | Documentation |
| MailChimp | Documentation |
| Microsoft Dynamics NAV | Documentation |
| Sharepoint | Documentation |
| 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.