Supported Advanced Data Source Adapters
TDV supports the following application data sources.
Data Source Adapter | Versions, Compatibility, and Notes |
Active Directory | LDAP v2 and v3 servers |
Amazon DynamoDB | DynamoDB REST API Version 2012-08-10 |
Amazon Redshift | Version 1.0.7562 |
Cassandra | Versions 2.1.7 and 3.0.0 |
CosmosDB | 2019 |
Couchbase | Version 4.0 of the API |
DynamicsCRM | Windows server 2016, Windows server 2012 R2, Windows Server 2012. |
DynamicsGP | Dynamics GP 2010, 2013, and 2015 |
DynamicsNAV | Dynamics NAV 2013, 2015, and 2016 |
Eloqua | Eloqua REST API and Bulk API version 2.0 |
Elasticsearch | Version 2.0 and above |
Email | Standard IMAP client as specified in RFC 1730 and RFC 2060 |
Sharepoint Excel Services | Excel data from SharePoint Online, and SharePoint Server 2010 and 2013 |
Facebook | Facebook Graph API 2.0, 2.1, 2.2, 2.3 |
Google Ads | API v201809 Note: Google AdWords has been re-branded as GoogleAds. Google AdWords datasource created in TDV version 8.0 or earlier cannot be opened in TDV version 8.1 or later. You need to create a new datasource by choosing GoogleAds from the new datasource dialogue in TDV Studio and introspect it again. |
Google Analytics | Google Analytics Management API v3.0, Google Analytics Core Reporting API v3.0 |
Google Contacts | API v3.0 |
Google Calendar | API v3.0 |
Google Drive | API V3.0 |
Google BigQuery | Google BigQuery API v2.0 |
Google Sheets | Google Sheets API v3.0 |
HubSpot | HubSpot REST API |
JDBC-ODBC Bridge | ODBC 2.x and 3.x drivers |
JSON | Standard JSON format as specified in RFC 7519 |
MarkLogic | 2019 |
Marketo | Marketo REST API v1, Marketo SOAP API v2.6 |
MongoDB | MongoDB 2.6 and 3.0 |
NetSuite | NetSuite SOAP APIs 2011-2015 |
OData | OData 2.0, 3.0, and 4.0 |
RSS | RSS 2.0 feeds |
SharePoint | SharePoint Online, SharePoint Server 2007, 2010, 2013 |
Single Store | 21.0.7810.0 |
Snowflake | Version 3.25.5 |
SparkSQL | Version 1.0 and above |
Splunk | 2019 |
Twitter | Twitter REST API v1.1 |
Limitations:
• Sometimes, instead of returning an empty value, “Select * from table where columnname = 'value'” may throw an exception, if there is no value in the column.
• Some adapters support ORDER BY, but sometimes there are only a few objects within that data source that support ORDER BY. TDV displays a message if the tables do not support ORDER BY.
• Tables might need to be filtered with mandatory inputs for querying the contents for table scans to work as expected. For example for google apps directions, the starting location and ending location might be needed to retrieve the results.
• Sharepoint adapters support direct Kerberos authentication.
• Bulk inserts are not supported.
• GoogleSheets does not support client side filtering.
• Table names or column names with the period character are not supported.
• Eloqua data sources where the password value is entered when creating the data source will persist the password and it cannot be changed.
• For the Sharepoint Excel Services adapter, during introspection all String data types are mapped to VARCHAR.
• The DynamicsCRM, DynamicsNAV, DynanoDB, GoogleBigQuery, and SharePoint adapters do not support "is not null" syntax.
• Queries that contain "LIMIT"are not supported.
• For MongoDB, updating schema files within a running instance of TDV is not supported.
• Deployment Manager is case sensitive when using it with these adapters.
• Deployment Manager attributes for these adapters can cause plans to fail.
• “Ignore case sensitivity mismatch between CIS and data source” and “Ignore trailing space mismatch between CIS and data source” override the server side setting for a data source.
By default these two overrides are enabled so that queries are always pushed. This is the case even when there is a mismatch and the query does not contain UPPER or RTRIM or similar options.
• Set these attributes to false or disable the push to get the consistent results as when the query is run with in the TDV.
For installation and licensing instructions, consult Installing Optional TDV Products, page 49.
For OAuth descriptions, see Configuring OAuth 2.0 for TDV Advanced Adapters, page 51.