Connectors

Data is the basis for any analytical or explorative business intelligence. In Sisense, data is generally managed via one or more data source. Data Sources hold information on metadata and connectivity settings for the data used in dashboards.

One of the biggest advantages of this approach is the ability to combine and mash up data from multiple sources quickly and easily.

A Data Source contains the following:

  • Connectivity information such as the server address, table name, login credentials, etc.  A Data Source maintains a connection for a single table, view, OLAP cube or an ElastiCube.
  • A dimensional representation of the data, in terms of dimensions and measures.
  • User-created resources such as custom filters or measures, widgets or questions.

The table below provides a list of connectors Sisense supports, installation files for connectors for Sisense’s standalone connectors, and links to the documentation pages for each connector.

ConnectorPre-InstalledMore Information
AccessYesDocumentation
BingDownloadDocumentation
BoxDownloadDocumentation
CSVYesDocumentation
Custom RESTYesDocumentation
DynamoDBDownloadDocumentation
Ebay (beta)Contact UsDocumentation
Exact OnlineDownloadDocumentation
ExcelYesDocumentation
FacebookContact UsDocumentation
Facebook AdsContact UsDocumentation
Generic ODBC DriverYesDocumentation
Generic OLE DB DriverYesDocumentation
Gmail DownloadDocumentation
Google AdWordsYesDocumentation
Google AnalyticsYesDocumentation
Google BigQueryDownloadDocumentation
Google SheetsYesDocumentation
HiveDownloadDocumentation
Heroku PostgresYesDocumentation
HubSpotDownloadDocumentation
Intacct (beta)Contact UsDocumentation
MailChimp (beta)DownloadDocumentation
Microsoft Active DirectoryDownloadDocumentation
Microsoft Dynamics CRMDownloadDocumentation
Microsoft Dynamics NAV (beta)Contact UsDocumentation
MongoDBDownload Documentation
MySqlYesDocumentation
OracleYesDocumentation
PayPal (beta)Contact UsDocumentation
PostgreSQLYesDocumentation
Quickbooks Desktop DownloadDocumentation
Quickbooks OnlineDownloadDocumentation
RedshiftYesDocumentation
SalesforceYesDocumentation
ServiceNow DownloadDocumentation
Sharepoint (beta)Contact UsDocumentation
Sisense ElastiCubeYesDocumentation
SnowflakeClick here for instructions.Documentation
SplunkYesDocumentation
Stripe DownloadDocumentation
SQL ServerYesDocumentation
TeradataYesDocumentation
TwitterDownloadDocumentation
XeroDownloadDocumentation
YoutubeDownloadDocumentation
Youtube AnalyticsDownloadDocumentation
ZendeskYesDocumentation

Learn more about Sisense’s data analytics software.