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 table below provides a list of supported data sources and links to the documentation for ElastiCube and live data sources when relevant.
| 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 | Download | 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 | ElastiCube
Live |
| Oracle | Pre-Installed | ElastiCube
Live |
| PostgreSQL | Pre-Installed | ElastiCube
Live |
| Quickbooks Desktop | Download | Documentation |
| Quickbooks Online | Download | Documentation |
| Redshift | Pre-Installed | ElastiCube
Live |
| Salesforce | Pre-Installed | Documentation |
| ServiceNow | Download | Documentation |
| Sisense ElastiCube | Pre-Installed | Documentation |
| Snowflake | Click here for instructions. | Documentation |
| Splunk | Pre-Installed | Documentation |
| Stripe | Download | Documentation |
| SQL Server | Pre-Installed | ElastiCube
Live |
| 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. For some connectors, certain limitations on data volume, tables, and refresh will apply.
| Connector | Download Link | More Information |
|---|---|---|
| Ebay | Download | Documentation |
| Download | Documentation | |
| Facebook Ads | Download | Documentation |
| HubSpot | Download | Documentation |
| Intacct | Download | Documentation |
| MailChimp | Download | Documentation |
| Microsoft Dynamics NAV | Download | Documentation |
| PayPal | Download | Documentation |
| Sharepoint | Download | Documentation |
| Download | Documentation | |
| Xero | Download | Documentation |
| Youtube | Download | Documentation |
| Youtube Analytics | Download | Documentation |