TIBCO Data Virtualization® Adapter Online Help
Essentials
Essentials
Product-Specific Documentation
How to Access TIBCO Documentation
How to Contact TIBCO Support
How to Join TIBCO Community
TDV Cloud File System
Connecting to Cloud File System Data Sources
Basic Tab
Advanced Tab
Data Type Mapping
Azure Data Lake Storage to TDV Data Types
TDV to Azure Data Lake Storage Data Types
Amazon S3 to TDV Data Types
TDV to Amazon S3 Data Types
Local File Storage to TDV Data Types
TDV to Local File Storage Data Types
Supported Functions
Supported Functions - Azure Data Lake Storage
Supported Functions - Amazon S3
Supported Functions - Local File Storage
Composite Adapter
Introduction
Datasource Configuration
Common Properties
Composite Specific Properties
Composite Function and Operators Support
References
TDV DataDirect Mainframe Adapter
Introduction
Datasource Configuration
Common Properties
DataDirect Mainframe Specific Properties
Obtain and Install Drivers for DataDirect Mainframe
Data Type Mappings
DataDirect Mainframe to TDV Data Types
DataDirect Mainframe Function Support
DataDirect Mainframe Aggregate Function Support
DataDirect Mainframe Character Function Support
DataDirect Mainframe Conditional Function Support
DataDirect Mainframe Conversion Function Support
DataDirect Mainframe Date Function Support
DataDirect Mainframe Numeric Function Support
DataDirect Mainframe XML Function Support
References
TDV DB2 Adapter
Introduction
Datasource Configuration
Common Properties
DB2 Specific Properties
Obtain and Install Drivers for DB2
DB2 and DB2 z/OS Data Source Limitations
DB2 Native (Bulk) Loading Caching Limitations
Data Type Mappings
DB2 to TDV Data Types
DB2 Cache Mapping
DB2-on-z/OS Cache Mapping
DB2 Function Support
DB2 Aggregate Function Support
DB2 Analytic Function Support
DB2 Analytic Aggregate Function Support
DB2 Character Function Support
DB2 Conditional Function Support
DB2 Conversion Function Support
DB2 Date Function Support
DB2 Linear Regression Function Support
DB2 Numeric Function Support
DB2 XML Function Support
DB2 Mainframe Function Support
DB2 Mainframe Aggregate Function Support
DB2 Mainframe Character Function Support
DB2 Mainframe Conditional Function Support
DB2 Mainframe Binary Function Support
DB2 Mainframe Conversion Function Support
DB2 Mainframe Date Function Support
DB2 Mainframe Numeric Function Support
DB2 Mainframe XML Function Support
References
TDV File Data Sources
Supported Character Encoding Types
Supported URL Protocols
About Export and Import of Custom Java Procedures
Adding a Custom Java Procedure
File-Delimited Data Source
Adding a Delimited File Data Source
File - Delimited to TDV Data Types Mapping
File Function Support
Cache File Data Source
Adding a Cache File Data Source
File - Cache to TDV Data Types Mapping
File Cache Mapping
LDAP Data Source
Adding an LDAP Data Source
LDAP to TDV Data Types
Microsoft Excel Data Sources
Adding Microsoft Excel Data Sources
Adding Microsoft Excel (non-ODBC) Data Sources
Microsoft Excel to TDV Data Types
Microsoft Excel Function Support
XML File Data Source
Adding an XML File Data Source
XML Function Support
TDV Greenplum Adapter
Introduction
Datasource Configuration
Common Properties
Greenplum Specific Properties
Data Type Mappings
Greenplum to TDV Data Types
Greenplum Cache Mapping
Greenplum Function Support
Greenplum Aggregate Function Support
Greenplum Analytic Function Support
Greenplum Analytic Aggregate Function Support
Greenplum Binary Function Support
Greenplum Character Function Support
Greenplum Conditional Function Support
Greenplum Conversion Function Support
Greenplum Date Function Support
Greenplum Numeric Function Support
Greenplum Time Function Support
References
TDV HBase Adapter
Introduction
Datasource Configuration
Common Properties
HBase Specific Properties
Obtain and Install Drivers for HBase
Data Type Mappings
HBase to TDV Data Types
HBase Function Support
HBase Aggregate Function Support
HBase Conversion Function Support
HBase Date Function Support
HBase Numeric Function Support
HBase String Function Support
References
TDV Hive Adapter
Introduction
Datasource Configuration
Common Properties
Hive Specific Properties
Obtain and Install Drivers for Hive
Hive Compatible Data Source Limitations
Apache Hive Caching Limitations
Data Type Mappings
Apache Hive to TDV Data Types
Cloudera Hive to TDV Data Types
Hive Function Support
Apache Hive Function Support
Apache Hive Aggregate Function Support
Apache Hive Character Function Support
Apache Hive Conversion Function Support
Apache Hive Conditional Function Support
Apache Hive Date Function Support
Cloudera Hive Function Support
Cloudera Hive Numeric Function Support
Cloudera Hive Aggregate Function Support
Cloudera Hive Conversion Function Support
Cloudera Hive Date Function Support
Cloudera Hive Conditional Function Support
Cloudera Hive Character Function Support
References
TDV HSQLDB Adapter
Introduction
Datasource Configuration
Common Properties
HSQLDB Specific Properties
Data Type Mappings
HSQLDB Database to TDV Data Types
HSQLDB Cache Mapping
HSQLDB Function Support
HSQLDB Aggregate Function Support
HSQLDB Binary Function Support
HSQLDB Conversion Function Support
HSQLDB Date Function Support
HSQLDB Numeric Function Support
HSQLDB String Function Support
References
TDV Impala Adapter
Introduction
Datasource Configuration
Common Properties
Impala Specific Properties
Obtain and Install Drivers for Impala
Data Type Mappings
Apache Impala to TDV Data Types
Cloudera Impala to TDV Data Types
Impala Function Support
Apache Impala Function Support
Cloudera Impala Function Support
References
TDV Informix Adapter
Introduction
Datasource Configuration
Common Properties
Informix Specific Properties
Obtain and Install the Driver for Informix
Informix Data Source Limitations
Data Type Mappings
Informix to TDV Data Types
Informix Cache Mapping
Informix Function Support
Informix Aggregate Function Support
Informix Character Function Support
Informix Conditional Function Support
Informix Conversion Function Support
Informix Date Function Support
Informix Numeric Function Support
References
TDV Microsoft Access Adapter
Introduction
Datasource Configuration
Common Properties
Microsoft Access Specific Properties
Data Type Mappings
Microsoft Access to TDV Data Types
Microsoft Access Cache Mapping
Microsoft Access Function Support
Microsoft Access Aggregate Function Support
Microsoft Access Analytic Aggregate Function Support
Microsoft Access Character Function Support
Microsoft Access Conditional Function Support
Microsoft Access Conversion Function Support
Microsoft Access Date Function Support
Microsoft Access Numeric Function Support
References
TDV MySQL Adapter
Introduction
Datasource Configuration
Common Properties
MySQL Specific Properties
Obtain and Install the Driver for MySQL
MySQL Caching Limitations
Data Type Mappings
MySQL to TDV Data Types
MySQL Cache Mapping
MySQL Function Support
MySQL Aggregate Function Support
MySQL Analytic Function Support
MySQL Analytic Aggregate Function Support
MySQL Character Function Support
MySQL Conditional Function Support
MySQL Conversion Function Support
MySQL Date Function Support
MySQL Numeric Function Support
MySQL Time Function Support
References
TDV NeoView Adapter
Introduction
Datasource Configuration
Common Properties
NeoView Specific Properties
Obtain and Install the Driver for NeoView
Data Type Mappings
Neoview to TDV Data Types
NeoView Function Support
NeoView Aggregate Function Support
NeoView Character Function Support
NeoView Conditional Function Support
NeoView Conversion Function Support
NeoView Date Function Support
NeoView Numeric Function Support
References
TDV Netezza Adapter
Introduction
Datasource Configuration
Common Properties
Netezza Specific Properties
Netezza Setup
Obtain and Install the Driver for Netezza
Netezza Data Source Limitations
Native (Bulk) Caching DDL Creation Limitations
Netezza Caching Tips from an Expert
Data Type Mappings
Netezza to TDV Data Types
Netezza Cache Mapping
Netezza Function Support
Netezza Aggregate Function Support
Netezza Analytic Function Support
Netezza Analytic Aggregate Function Support
Netezza Binary Function Support
Netezza Character Function Support
Netezza Conditional Function Support
Netezza Conversion Function Support
Netezza Date Function Support
Netezza Numeric Function Support
Netezza Phonetic Function Support
Netezza Statistical Analytic Aggregate Function Support
Netezza Time Function Support
References
TDV Oracle Adapter
Introduction
Datasource Configuration
Common Properties
Oracle Specific Connection Properties
Obtain and Install the Drivers for Oracle Applications
Obtain and Install the Driver for Oracle OCI Client
Oracle Data Source Limitations
Oracle Caching Limitations
Oracle to TDV Data Types
Oracle NUMBER Data Types and TDV Data Types
Oracle to Data Types Common to All Versions
Oracle 11g to TDV Data Types
Oracle 19c to TDV Data Types
Oracle Cache Mapping
Oracle Function Support
Oracle Aggregate Function Support
Oracle Analytic Function Support
Oracle Analytic Aggregate Function Support
Oracle Binary Function Support
Oracle Character Function Support
Oracle Conditional Function Support
Oracle Conversion Function Support
Oracle Date Function Support
Oracle Encryption Function Support
Oracle Numeric Function Support
Oracle Time Function Support
Oracle XML Function Support
References
TDV PostgreSQL Adapter
Introduction
Datasource Configuration
Common Properties
PostgreSQL Specific Properties
Data Type Mappings
PostgreSQL to TDV Data Types
PostgreSQL Cache Mapping
PostgreSQL Function Support
PostgreSQL Aggregate Function Support
PostgreSQL Analytic Aggregate Function Support
PostgreSQL Binary Function Support
PostgreSQL Character Function Support
PostgreSQL Conversion Function Support
PostgreSQL Date Function Support
PostgreSQL Numeric Function Support
PostgreSQL Time Function Support
References
TDV SAP HANA Adapter
Introduction
Datasource Configuration
Common Properties
SAP HANA Specific Properties
Obtain and Install the Driver for SAP Hana
SAP HANA Data Source Limitations and Characteristics
SAP HANA Caching Characteristics
Data Type Mappings
SAP HANA Data Types
SAP HANA Cache Mapping
SAP HANA Function Support
SAP HANA Aggregate Function Support
SAP HANA Analytical Function Support
SAP HANA Binary Function Support
SAP HANA Character Function Support
SAP HANA Conditional Function Support
SAP HANA Conversion Function Support
SAP HANA Date Function Support
SAP HANA Numeric Function Support
References
TDV SQL Server Adapter
Introduction
Datasource Configuration
Common Properties
SQL Server Connection Properties
Obtain and Install the Driver for SQL Server
Connecting to SQL Server datasource using an Active directory Login
Microsoft SQL Server 2008 Limitation
Data Type Mappings
Microsoft SQL Server to TDV Data Types
Microsoft SQL Server Cache Mapping
Microsoft SQL Server Function Support
Microsoft SQL Server Aggregate Function Support
Microsoft SQL Server Analytic Function Support
Microsoft SQL Server Analytic Aggregate Function Support
Microsoft SQL Server Character Function Support
Microsoft SQL Server Conditional Function Support
Microsoft SQL Server Conversion Function Support
Microsoft SQL Server Date Function Support
Microsoft SQL Server Encryption Function Support
Microsoft SQL Server Numeric Function Support
Microsoft SQL Server Time Function Support
References
TDV Sybase Adapter
Introduction
Datasource Configuration
Common Properties
Sybase Connection Properties
Sybase IQ Connection Properties
Obtain and Install the Driver for Sybase
Obtain and install the JDBC driver for Sybase
Sybase Data Source Characteristics
Data Type Mappings
Sybase ASE to TDV Data Types
Sybase IQ to TDV Data Types
Sybase ASE Cache Mapping
Sybase IQ Cache Mapping
Sybase Function Support
Sybase Aggregate Function Support
Sybase Character Function Support
Sybase Conditional Function Support
Sybase Conversion Function Support
Sybase Date Function Support
Sybase Numeric Function Support
Sybase ASE 15.7 MERGE Behavior
Sybase IQ Function Support
Sybase IQ Aggregate Function Support
Sybase IQ Analytic Function Support
Sybase IQ Character Function Support
Sybase IQ Conditional Function Support
Sybase IQ Conversion Function Support
Sybase IQ Date Function Support
Sybase IQ Numeric Function Support
References
TDV Teradata Adapter
Introduction
Datasource Configuration
Common Properties
Teradata Specific Properties
Obtain and Install the Driver for Teradata
Teradata Data Source Introspection
Teradata Data Source Limitations
Teradata Caching Limitations
Data Type Mappings
Teradata to TDV Data Types
Teradata Cache Mapping
Teradata Function Support
Teradata Aggregate Function Support
Teradata Analytic Function Support
Teradata Character Function Support
Teradata Conditional Function Support
Teradata Conversion Function Support
Teradata Date Function Support
Teradata Number Function Support
References
TDV Vertica Adapter
Introduction
Datasource Configuration
Common Properties
Vertica Specific Properties
Obtain and Install the Driver for Vertica
Using Pass-Through Introspection with Vertica Data Source Clients
Vertica Data Source Limitations
Vertica Caching Limitations
Data Type Mappings
Vertica to TDV Data Types
Vertica Cache Mapping
Vertica Function Support
Vertica Aggregate Function Support
Vertica Analytic Function Support
Vertica Binary Function Support
Vertica Character Function Support
Vertica Conditional Function Support
Vertica Conversion Function Support
Vertica Date Function Support
Vertica Numeric Function Support
Vertica OLAP Analytic Function Support
Vertica Time Series Function Support
References
TDV Web-Based Data Sources
About OAuth Configuration for SOAP and REST Data Sources
About WSDL Bare and Wrapper Parameter Styles
WSDL and SOAP Data Sources
Adding a WSDL or SOAP Data Source
Enabling Tube Logs for SOAP Data Sources
Subscribe to a WSDL Offered as a JMS Data Source
Defining SOAP Message Pipelines
Message Level Security (Pipelines) for Legacy Web Services Imported from CAR Files
REST Data Sources
Adding a REST Data Source
Setting a Value for NULL JSON Values in REST Responses
Passing a Full XML Document in a POST Request to a REST Service
Using an HTTP Header Parameter to Specify the Content Type
Using Design By Example to Infer Parameter Data Types
Cross-Origin Resource Sharing (CORS)
Configuring XML/HTTP Data Sources
Creating an XML Definition Set
Adding an XML/HTTP Data Source
Retrieving XML Data Over HTTP
Proxy Configuration Limitations
Client Authentication for Web Data Sources
TDV SOAP and REST OAUTH Examples
Google OAuth Example
Facebook OAuth Example
Linkedin OAUTH Example
Salesforce OAuth Example
Github OAuth Example
Foursquare OAuth Example
TDV OAuth Tab XML Processors Field Reference
Authorization Element Reference
AccessToken XML Element Reference
RefreshToken Element
QueryTokenName Element
Partial Example of Using OAuth Customized Flow for WSDL, SOAP, and REST
ComputeDB Adapter
Introduction
Datasource Configuration
Common Properties
ComputeDB Specific Properties
ComputeDB Data Source Limitations
ComputeDB Caching Characteristics
Data Type Mappings
ComputeDB to TDV Data Types
ComputeDB Cache Mapping
ComputeDB Function Support
ComputeDB Aggregate Function Support
ComputeDB Character Function Support
ComputeDB Conversion Function Support
ComputeDB Date Function Support
ComputeDB Numeric Function Support
ComputeDB SparkSQL Function Support
References
TDV Drill Adapter
Introduction
Datasource Configuration
Common Properties
Drill Specific Properties
Apache Drill Data Source Limitations
Data Type Mappings
Apache Drill to TDV Data Types
Apache Drill Cache Mapping
Apache Drill Function Support
Apache Drill Aggregate Function Support
Apache Drill Character Function Support
Apache Drill Conversion Function Support
Apache Drill Conditional Function Support
Apache Drill Date Function Support
Apache Drill Numeric Function Support
Apache Drill Binary Function Support
Apache Drill Analytic Function Support
Apache Drill Push Only Function Support
Apache Drill Encryption Function Support
Apache Drill Phonetic Function Support
Apache Drill XML Function Support
References
TIBCO Streaming Adapter
Introduction
Datasource Configuration
Common Properties
TIBCO Streaming Data Source Limitations
Data Type Mappings
TIBCO Streaming to TDV Data Types
TIBCO Streaming Cache Mapping
TIBCO Streaming Function Support
TIBCO Streaming Numeric Function Support
TIBCO Streaming Character Function Support
TIBCO Streaming Conversion Function Support
TIBCO Streaming Date Function Support
TIBCO Streaming Aggregate Function Support
TIBCO Streaming Conditional Function Support
TIBCO Streaming Binary Function Support
TIBCO Streaming Push Only Function Support
TIBCO Streaming SparkSQL Function Support
References
Using the Oracle E-Business Suite Adapter
About Oracle E-Business Suite Data Source
Oracle EBS Basic Tab
Oracle EBS Advanced Tab
Security for Oracle E-Business Suite with TDV
Using the Salesforce.com Adapter
Salesforce.com Limitations
Salesforce.com Basic Tab
Salesforce.com Advanced Tab
Salesforce.com Identity Confirmation Security Feature
Security for the Salesforce.com Adapter
TDV SQL Support for Salesforce.com
Using the SAP for TDV Adapter
About SAP Data Sources
SAP Basic tab
SAP Advanced tab
Configuring TDV Logging Level when Using SAP for TDV
SQL Support for SAP
TDV SQL Support for SAP Tables
TDV SQL Support for SAP ABAP Queries
TDV SQL Support for SAP Dates
Security for SAP with TDV
Pooled and Cluster Tables
SAP Global Properties
Using SAP BW with TDV
About SAP BW Data Sources
SAP BW Basic Tab
SAP BW Advanced Tab
Reintrospecting SAP BW
Introspecting Large Datasets with SAP BW
Creating a View from a Cube
Generating an OLAP View Execution Plan
Accessing Data Lineage for an OLAP View
SQL Support for SAP BW
Security for SAP BW with TDV
SAP BW Global Properties
Using SAP BW BEx with TDV
Query Limitations and Workarounds
SAP BW BEx Characteristics
SAP BW BEx Basic Tab
SAP BW BEx Advanced Tab
Reintrospecting SAP BW BEx
Clearing the Metadata Cache
Generating an Execution Plan
Accessing Data Lineage
SQL Support for SAP BW BEx
Security for SAP BW BEx with TDV
SAP BW BEx Global Properties
Using Siebel with TDV
Siebel Limitations
Siebel Basic Tab
Working with Siebel Connect Strings
SQL Support Reference for Siebel
Siebel Multi-Valued Groups
TDV Active Directory Adapter
Deploying the Adapter
Basic Tab
Advanced Tab
Connection String Options
Logging
Working with Active Directory Tables
Connecting to Custom Tables
Defining a New Table
Defining Table Columns and Inputs
Configuring Table Settings
Defining Supported Operations
Advanced Settings
Customizing the SSL Configuration
Connecting Through a Firewall or Proxy
Troubleshooting the Connection
SQL Compliance
SELECT Statements
SELECT INTO Statements
INSERT Statements
UPDATE Statements
DELETE Statements
EXECUTE Statements
Data Model
Tables
Views
Stored Procedures
TDV Apache HBase Adapter
Deploying the Adapter
Basic Tab
Advanced Tab
Connection String Options
Logging
Using Kerberos
Authenticating with Kerberos
Retrieve the Kerberos Ticket
Advanced Settings
Fine-Tuning Data Access
Customizing the SSL Configuration
Connecting Through a Firewall or Proxy
Troubleshooting the Connection
SQL Compliance
SELECT Statements
SELECT INTO Statements
INSERT Statements
UPDATE Statements
DELETE Statements
EXECUTE Statements
Data Model
Stored Procedures
TDV Cassandra Adapter
Deploying the Adapter
Basic Tab
Advanced Tab
Connection String Options
Logging
Using Kerberos
Authenticating with Kerberos
Retrieve the Kerberos Ticket
Cross-Realm Authentication
Advanced Settings
NoSQL Database
Automatic Schema Discovery
Custom Schema Definitions
Custom Schema Example
Data Type Mapping
SQL Compliance
SELECT Statements
SELECT INTO Statements
INSERT Statements
UPDATE Statements
DELETE Statements
EXECUTE Statements
TDV Cosmos DB Adapter
Getting Started
Deploying the Adapter
Connecting to Cosmos DB
Basic Tab
Advanced Tab
Connection String Options
Logging
Advanced Settings
Accessing NoSQL Tables
Fine Tuning Data Access
Customizing the SSL Configuration
Connecting Through a Firewall or Proxy
Troubleshooting the Connection
Changes in 2019
NoSQL Database
Automatic Schema Discovery
Free-Form Queries
Vertical Flattening
JSON Functions
Sql API Built-In Functions
Query Mapping (Sql API)
Built-In functions
Custom Schema Definitions
Custom Schema Example
Stored Procedures
SQL Compliance
SELECT Statements
SELECT INTO Statements
INSERT Statements
UPDATE Statements
DELETE Statements
EXECUTE Statements
TDV Couchbase Adapter
Getting Started
Deploying the Adapter
Connecting to Couchbase
Basic Tab
Advanced Tab
Connection String Options
Logging
Advanced Settings
NoSQL Database
Automatic Schema Discovery
Child Tables
Query Mapping
Vertical Flattening
JSON Functions
Custom Schema Definitions
Custom Schema Example
SQL Compliance
SELECT Statements
SELECT INTO Statements
INSERT Statements
UPDATE Statements
DELETE Statements
EXECUTE Statements
Data Model
Stored Procedures
TDV Amazon DynamoDB Adapter
Deploying the Adapter
Basic Tab
Advanced Tab
Connection String Options
Logging
Querying The Data
Advanced Settings
NoSQL Database
Automatic Schema Discovery
Vertical Flattening
JSON Functions
DynamoDB Queries
Querying Documents and Lists
Data Type Mapping
Custom Schema Definitions
Custom Schema Example
SQL Compliance
SELECT Statements
SELECT INTO Statements
INSERT Statements
UPDATE Statements
DELETE Statements
EXECUTE Statements
Data Model
Tables
Table Columns
Stored Procedures
TDV Microsoft Dynamics CRM Adapter
Deploying the Adapter
Basic Tab
Advanced Tab
Connection String Options
Logging
Advanced Settings
SQL Compliance
SELECT Statements
SELECT INTO Statements
INSERT Statements
UPDATE Statements
UPSERT Statements
DELETE Statements
EXECUTE Statements
Data Model
Tables
Stored Procedures
TDV Microsoft Dynamics GP Adapter
Deploying the Adapter
Basic Tab
Advanced Tab
Connection String Options
Logging
Advanced Settings
SQL Compliance
SELECT Statements
SELECT INTO Statements
Data Model
TDV Microsoft Dynamics NAV Adapter
Deploying the Adapter
Basic Tab
Advanced Tab
Connection String Options
Logging
Advanced Settings
SQL Compliance
SELECT Statements
SELECT INTO Statements
INSERT Statements
UPDATE Statements
DELETE Statements
EXECUTE Statements
Data Model
Tables
Microsoft Dynamics NAV Adapter Tables
Stored Procedures
Microsoft Dynamics NAV Adapter Stored Procedures
Data Type Mapping
TDV Elasticsearch Adapter
Deploying the Adapter
Basic Tab
Advanced Tab
Connection String Options
Logging
Using KerberosCustom URLsRaw DataParsing Hierarchical Data
Authenticating with Kerberos
Retrieve the Kerberos Ticket
Cross-Realm Authentication
Advanced Settings
Accessing NoSQL Tables
Querying Multiple Indices
Fine Tuning Data Access
Fine Tuning Performance
Connecting Through a Firewall or Proxy
Using KerberosCustom URLsRaw DataParsing Hierarchical Data
Troubleshooting the Connection
Searching with SQL
Schema Mapping
Parent-Child Relationships
Using KerberosCustom URLsRaw DataParsing Hierarchical Data
Automatic Schema Discovery
Using KerberosCustom URLsRaw DataParsing Hierarchical Data
Flattened Documents Model
Joining Object Arrays into a Single Table
Top-Level Document Model
Modeling a Top-Level Document View
Relational Model
Joining Nested Arrays as Tables
JSON Functions
Query Mapping
Custom Schema Definitions
Custom Schema Example
SQL Compliance
SELECT Statements
SELECT INTO Statements
INSERT Statements
UPDATE Statements
UPSERT Statements
DELETE Statements
EXECUTE Statements
Data Model
Stored Procedures
Data Type Mapping
TDV Oracle Eloqua Adapter
Deploying the Adapter
Basic Tab
Advanced Tab
Connection String Options
Logging
Connecting to Eloqua
Advanced Settings
SQL Compliance
SELECT Statements
SELECT INTO Statements
INSERT Statements
UPDATE Statements
DELETE Statements
EXECUTE Statements
Data Model
TDV Email Adapter
Getting Started
Deploying the Adapter
Connecting to Email
Basic Tab
Advanced Tab
Connection String Options
Logging
Advanced Settings
SQL Compliance
SELECT Statements
SELECT INTO Statements
INSERT Statements
UPDATE Statements
DELETE Statements
EXECUTE Statements
Supported Mail Protocols
IMAP
POP
SMTP
Data Model
Tables
Stored Procedures
TDV SharePoint Excel Services Adapter
Getting Started
Deploying the Adapter
Connecting to SharePoint Excel Services
Basic Tab
Advanced Tab
Connection String Options
Logging
Advanced Settings
SQL Compliance
SELECT Statements
EXECUTE Statements
Data Model
OData API
REST API
Data Type Mapping
TDV Facebook Adapter
Deploying the Adapter
Basic Tab
Advanced Tab
Connection String Options
Logging
Using OAuth Authentication
Embedded Credentials
Custom Credentials
Headless Machines
Creating a Custom OAuth App
Advanced Settings
Connecting to Facebook
Configuring the Adapter
Configuring a Development Machine
Configuring a Production Machine
Configuring OAuth in a Cluster
Importing/Exporting Archives and Using the Deployment Manager
Major Changes
Product Split
Deprecations in Graph API v7.0
Deprecations in Graph API v6.0
Changes Prior to 2020
Insight Mapping
Current Insights
SQL Compliance
SELECT Statements
SELECT INTO Statements
INSERT Statements
UPDATE Statements
DELETE Statements
EXECUTE Statements
Data Model
Tables
Views
Stored Procedures
TDV Google Ads Adapter
Deploying the Adapter
Basic Tab
Advanced Tab
Connection String Options
Logging
Using OAuth Authentication
Embedded Credentials
Custom Credentials
Headless Machines
Creating a Custom OAuth App
Retrieving Google AdWords data
Advanced Settings
Google Ads
Google Ads V3
SQL Compliance
SELECT Statements
SELECT INTO Statements
EXECUTE Statements
v201809 Data Model
TDV Google Analytics Adapter
Deploying the Adapter
Basic Tab
Advanced Tab
Connection String Options
Logging
Using OAuth Authentication
Embedded Credentials
Custom Credentials
Headless Machines
Creating a Custom OAuth App
Retrieving Google Analytics Data
Advanced Queries
Advanced Settings
SQL Compliance
SELECT Statements
SELECT INTO Statements
EXECUTE Statements
Data Model
Tables
Views
Stored Procedures
TDV Google BigQuery Adapter
Getting Started
Deploying the Adapter
Connecting to Google BigQuery
Basic Tab
Authenticate via OAuth Authentication
Advanced Tab
Connection String Options
Logging
Using OAuth Authentication
Embedded Credentials
Custom Credentials
Headless Machines
Creating a Custom OAuth App
Advanced Settings
Saving Result Sets
Limiting Billing
Registering Your Application
Customizing the SSL Configuration
Connecting Through a Firewall or Proxy
Troubleshooting the Connection
SQL Compliance
SELECT Statements
SELECT INTO Statements
INSERT Statements
EXECUTE Statements
Data Model
Views
Stored Procedures
Data Type Mapping
Google BigQuery Adapter Limitations
TDV Google Calendar Adapter
Deploying the Adapter
Basic Tab
Authenticate via OAuth Authentication
Advanced Tab
Connection String Options
Logging
Using OAuth Authentication
Embedded Credentials
Custom Credentials
Headless Machines
Creating a Custom OAuth App
Advanced Settings
SQL Compliance
SELECT Statements
SELECT INTO Statements
INSERT Statements
UPDATE Statements
DELETE Statements
EXECUTE Statements
Data Model
Tables
Views
Stored Procedures
TDV Google Contacts Adapter
Deploying the Adapter
Basic Tab
Advanced Tab
Connection String Options
Logging
Using OAuth Authentication
Embedded Credentials
Custom Credentials
Headless Machines
Creating a Custom OAuth App
Advanced Settings
SQL Compliance
SELECT Statements
SELECT INTO Statements
INSERT Statements
UPDATE Statements
DELETE Statements
EXECUTE Statements
Data Model
TDV Google Drive Adapter
Deploying the Adapter
Basic Tab
Advanced Tab
Connection String Options
Logging
Using OAuth Authentication
Embedded Credentials
Custom Credentials
Headless Machines
Creating a Custom OAuth App
Advanced Settings
SQL Compliance
SELECT Statements
SELECT INTO Statements
INSERT Statements
UPDATE Statements
DELETE Statements
EXECUTE Statements
Data Model
Tables
Views
Stored Procedures
TDV Google Sheets Adapter
Getting Started
Deploying the Adapter
Connecting to Google Sheets
Basic Tab
Advanced Tab
Connection String Options
Logging
Using OAuth Authentication
Embedded Credentials
Custom Credentials
Headless Machines
Creating a Custom OAuth App
Advanced Settings
SQL Compliance
SELECT Statements
SELECT INTO Statements
INSERT Statements
UPDATE Statements
DELETE Statements
EXECUTE Statements
Using Spreadsheets as Tables
Tables
Columns
Views
Stored Procedures
TDV HubSpot Adapter
Deploying the Adapter
Basic Tab
Advanced Tab
Connection String Options
Logging
Using OAuth Authentication
Embedded Credentials
Custom Credentials
Headless Machines
Creating a Custom OAuth App
Major Changes
HubSpot CRM API v3
Advanced Settings
SQL Compliance
SELECT Statements
SELECT INTO Statements
INSERT Statements
UPDATE Statements
DELETE Statements
EXECUTE Statements
Data Model
TDV JDBC-ODBC Bridge Adapter
Basic Tab
Advanced Tab
Connection String Options
Logging
TDV MarkLogic Adapter
Getting Started
Deploying the Adapter
Connecting to MarkLogic
Basic Tab
Advanced Tab
Connection String Options
Logging
Advanced Settings
Customizing the SSL Configuration
Connecting Through a Firewall or Proxy
SQL Compliance
SELECT Statements
SELECT INTO Statements
EXECUTE Statements
Data Model
TDV Marketo Adapter
Deploying the Adapter
Basic Tab
Advanced Tab
Connection String Options
Logging
Advanced Settings
SQL Compliance
SELECT Statements
SELECT INTO Statements
INSERT Statements
UPDATE Statements
UPSERT Statements
DELETE Statements
EXECUTE Statements
SOAP Data Model
REST Data Model
TDV MongoDB Adapter
Deploying the Adapter
Basic Tab
Advanced Tab
Connection String Options
Logging
DBaaS Connections
Atlas
ObjectRocket
Advanced Settings
NoSQL Database
Automatic Schema Discovery
Free-Form Queries
Vertical Flattening
JSON Functions
Query Mapping
Custom Schema Definitions
Custom Schema Example
Data Type Mapping
Stored Procedures
SQL Compliance
SELECT Statements
SELECT INTO Statements
INSERT Statements
UPDATE Statements
DELETE Statements
EXECUTE Statements
CREATE TABLE Statements
DROP TABLE Statements
TDV NetSuite Adapter
Deploying the Adapter
Basic Tab
Advanced Tab
Connection String Options
Logging
Major Changes
Discontinuation of User/Password
Multiple Schemas
Deprecation of Login and Session Changes
Using OAuth Authentication
Custom Credentials
Headless Machines
Using OAuth on a Headless Machine
Creating a Custom OAuth App
When to Create a Custom OAuth App
Create a Custom OAuth App: Desktop
Creating an Access Token in NetSuite
Create Tokens in the NetSuite UI
Permission Configurations
Most Commonly Required
Other Permissions
SuiteQL
Differences between SuiteTalk and SuiteQL
Limitations of SuiteQL
Supported Formulas
SuiteTalk
Exposed Data
RESTlets
Create a RESTlet Schema
Fine-Tuning Schemas
Limitations
Saved Searches
SavedSearches View
CreateSavedSearchSchema Stored Procedure
Retrieving Data
Limitations
Advanced Settings
Customizing the SSL Configuration
Connecting Through a Firewall or Proxy
SQL Compliance
SELECT Statements
SELECT INTO Statements
INSERT Statements
UPDATE Statements
DELETE Statements
GETDELETED Statements
EXECUTE Statements
Data Model
TDV OData Adapter
Getting Started
Connecting to OData
Deploying the Adapter
Basic Tab
Advanced Tab
Connection String Options
Logging
Using OAuth Authentication
Creating a Custom OAuth App
Custom Credentials
Headless Machines
Advanced Settings
Customizing API Requests
Fine-Tuning Data Access
SQL Compliance
SELECT Statements
SELECT INTO Statements
INSERT Statements
UPDATE Statements
DELETE Statements
EXECUTE Statements
Data Model
Tables
Views
Navigation Properties
Working with Navigation Properties Relationally
Stored Procedures
Data Type Mapping
TDV Amazon Redshift Adapter
Getting Started
Deploying the Adapter
Connecting to Amazon Redshift
Basic Tab
Advanced Tab
Connection String Options
Logging
Advanced Settings
Customizing the SSL Configuration
Connecting Through a Firewall or Proxy
Troubleshooting the Connection
Data Type Mapping
Amazon Redshift Adapter Limitations
TDV RSS Adapter
Deploying the Adapter
Basic Tab
Advanced Tab
Connection String Options
Logging
Creating a Schema
Advanced Settings
Customizing the SSL Configuration
Connecting Through a Firewall or Proxy
Troubleshooting the Connection
SQL Compliance
SELECT Statements
SELECT INTO Statements
EXECUTE Statements
Data Model
Views
Stored Procedures
TDV Salesforce with SSO Adapter
Deploying the Adapter
Basic Tab
Authenticating to Salesforce APIs
Connecting to Salesforce with SSO APIs
Advanced Tab
Connection String Options
Logging
Using OAuth Authentication
Custom Credentials
Headless Machines
Creating a Custom OAuth App
Advanced Settings
SQL Compliance
SELECT Statements
SELECT INTO Statements
INSERT Statements
UPDATE Statements
UPSERT Statements
DELETE Statements
GETDELETED Statements
EXECUTE Statements
CREATE TABLE Statements
DROP TABLE Statements
ALTER TABLE Statements
Data Model
Tables
Views
Stored Procedures
Data Type Mapping
TDV SharePoint Adapter
Getting Started
Deploying the Adapter
Connecting to SharePoint
Basic Tab
Advanced Tab
Connection String Options
Logging
Using OAuth Authentication
Admin Consent
Admin Consent Permissions
Client Credentials
Client OAuth Flow
Connecting to REST API
Using Kerberos
Advanced Settings
SQL Compliance
SELECT Statements
SELECT INTO Statements
INSERT Statements
UPDATE Statements
DELETE Statements
EXECUTE Statements
Data Model
SOAP Data Model
REST Data Model
Data Type Mapping
TDV Snowflake Adapter
Getting Started
Deploying the Adapter
Connecting to Snowflake
Basic Tab
Advanced Tab
Connection String Options
Logging
Troubleshooting
Advanced Logging
Advanced Settings
SQL Compliance
SELECT Statements
SELECT INTO Statements
INSERT Statements
UPDATE Statements
DELETE Statements
EXECUTE Statements
Data Model
Discovering Schemas
SnowFlake Adapter Limitations
TDV SparkSQL Adapter
Getting Started
Deploying the Adapter
Connecting to SparkSQL
Basic Tab
Advanced Tab
Connection String Options
Logging
Using Kerberos
Advanced Settings
SQL Compliance
SELECT Statements
SELECT INTO Statements
INSERT Statements
EXECUTE Statements
Data Model
SpartSQL Adapter Limitations
TDV Splunk Adapter
Getting Started
Deploying the Adapter
Connecting to Splunk
Basic Tab
Advanced Tab
Connection String Options
Logging
Configure Logging for the Splunk Adapter
Advanced Settings
Troubleshooting the Connection
SQL Compliance
SELECT Statements
SELECT INTO Statements
INSERT Statements
UPDATE Statements
DELETE Statements
EXECUTE Statements
Data Model
Tables
Views
Stored Procedures
TDV Twitter Adapter
Deploying the Adapter
Basic Tab
Advanced Tab
Connection String Options
Logging
Using OAuth Authentication
Embedded Credentials
Custom Credentials
Headless Machines
Advanced Settings
SQL Compliance
SELECT Statements
SELECT INTO Statements
INSERT Statements
DELETE Statements
EXECUTE Statements
Data Model
Tables
Views
Stored Procedures
TIBCO Data Virtualization® Adapter Online Help
Stored Procedures