Connect to Hundreds of Data Sources
DataClarity includes JDBC drivers for the following data source types:
- Amazon Athena
- Amazon Aurora (MySQL)
- Amazon Aurora (PostgreSQL)
- Amazon Redshift
- Apache Derby
- Apache Hive
- Azure SQL Database
- Azure SQL Data Warehouse
- EXASOL
- FirebirdSQL
- Google Cloud SQL (MySQL)
- Google Cloud SQL (PostgreSQL)
- HyperSQL
- IBM Cognos TM1 / IBM Planning Analytics cubes
- IBM Cognos TM1 / IBM Planning Analytics cube views
- IBM Cognos packages:
- Relational package
- DMR package
- PowerCube
- Dynamic Cube
- TM1/PA cube
- IBM DB2
- Informix
- MariaDB
- Microsoft SQL Server
- Microsoft SQL Server Analysis Services
- MySQL
- Oracle
- PostgreSQL
- Spreadsheets (xlsx, .xls) and other data files (.csv, .tsv, .txt and .sav)
DataClarity may connect to the data sources below using vendor and third-party JDBC drivers:
- ActCRM
- Active Directory
- Amazon DynamoDB
- Apache HBase
- Authorize.Net
- Azure CosmosDB
- Azure Data Management
- Azure Table Storage
- Basecamp
- Bing Ads
- Bing Search
- Box
- Cassandra
- Couchbase
- DoubleClick CM
- DoubleClick FP
- EBay
- Elasticsearch
- Eloqua
- Email
- ETrade
- Exact Online
- Excel Online
- Excel Services
- Exchange
- Facebook
- Financial Edge NX
- Freshbooks
- FTP
- Gmail
- Google AdWords
- Google Analytics
- Google BigQuery
- Google Calendar
- Google Contacts
- Google Directory
- Google Drive
- Google Search
- Google Spreadsheets
- Highrise
- HPCC
- HubSpot
- IBM Cloudant
- JIRA
- JSON
- Kintone
- LDAP
- LinkedIn
- Magento
- MailChimp
- Marketo
- Microsoft Access
- Microsoft Dynamics 365 Business Central
- Microsoft Dynamics 365 Finance and Operations
- Microsoft Dynamics 365 Sales
- Microsoft Dynamics CRM
- Microsoft Dynamics GP
- Microsoft Dynamics NAV
- MongoDB
- MSProject
- Netezza
- NetSuite
- OData
- Office365
- OFX
- Open Exchange Rates
- Oracle SalesCloud
- PayPal
- QB POS
- Quandl
- QuickBooks
- QuickBooks Online
- Reckon
- Redis
- REST
- RSS
- Sage 50 UK
- Sage Intacct
- Salesforce
- Salesforce Chatter
- Salesforce Einstein Analytics
- Salesforce Marketing Cloud
- SAP Business One
- SAP ERP
- SAP Hybris C4C
- SendGrid
- ServiceNow
- SharePoint
- Shopify
- Slack
- Smartsheet
- Snappy Data
- SparkSQL
- Splunk
- Square
- Stripe
- Sugar CRM
- SuiteCRM
- SurveyMonkey
- Teradata
- Twilio
- Twitter
- xBase
- Xero
- XML
- YouTube Analytics
- YouTube Data
- Zendesk
- Zoho CRM