•  Adapter Online Help
  •  TIBCO Product Documentation and Support Services
    • How to Access TIBCO Documentation
    • How to Contact TIBCO Support
    • How to Join TIBCO Community
  • Legal and Third-Party Notices
  •  TDV Amazon S3 Adapter
    •  Connecting to Amazon S3 Data Source
      • Basic Tab
      • Advanced Tab
    •  Data Type Mapping
      • Amazon S3 to TDV Data Types
      • TDV to Amazon S3 Data Types
    • Supported Functions
    • DDL Support
  •  TDV Azure Data Lake Adapter
    •  Connecting to Azure Data Lake Data Source
      • Basic Tab
      • Advanced Tab
    •  Data Type Mapping
      • Azure Data Lake Storage to TDV Data Types
      • TDV to Azure Data Lake Storage Data Types
    • Supported Functions
  •  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
    • Obtain and Install Drivers for DB2
    •  Datasource Configuration
      • Common Properties
      • DB2 Specific Properties
    •  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
    • Obtain and Install Drivers for Hive
    •  Datasource Configuration
      • Common Properties
      • Hive Specific Properties
    •  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
    • Obtain and Install Drivers for Impala
    •  Datasource Configuration
      • Common Properties
      • Impala Specific Properties
    •  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 Local File Storage Adapter
    •  Connecting to Local File Storage Data Source
      • Basic Tab
      • Advanced Tab
      • Local File Storage to TDV Data Types
      • TDV to Local File Storage Data Types
    • Supported Functions
  •  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
    • Obtain and Install the Driver for MySQL
    • Using the MySQL SingleStore Adapter
    •  Datasource Configuration
      • Common Properties
      • MySQL Specific Properties
    • 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
    • Obtain and Install the Driver for Netezza
    •  Datasource Configuration
      • Common Properties
      • Netezza Specific Properties
      • Netezza Setup
    •  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
    • Obtain and Install the Drivers for Oracle Applications
    • Obtain and Install the Driver for Oracle OCI Client
    •  Datasource Configuration
      • Common Properties
      • Oracle Specific Connection Properties
    •  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 Teradata Adapter
    • Introduction
    • Obtain and Install the Driver for Teradata
    •  Datasource Configuration
      • Common Properties
      • Teradata Specific Properties
    • 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
    • Obtain and Install the Driver for Vertica
    •  Datasource Configuration
      • Common Properties
      • Vertica Specific Properties
    • 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 Features
      • User Defined Views
      • SSL Configuration
      • Firewall and Proxy
      • Logging
    •  SQL Compliance
      • SELECT Statements
      • SELECT INTO Statements
      • INSERT Statements
      • UPDATE Statements
      • DELETE Statements
      • EXECUTE Statements
    •  Data Model
      • Tables
      • Views
    •  Views
      • Active Directory Adapter 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 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 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 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 Kerberos
      • Authenticating with Kerberos
      • Retrieve the Kerberos Ticket
    •  Using OAuth Authentication
      • Creating a Custom OAuth App
      • Custom Credentials
      • Headless Machines
    •  Fine-Tuning Data Access
      • Customizing API Requests
      • Fine-Tuning Data Access
    •  Advanced Features
      • User Defined Views
      • Inserting Parent and Child Records
      • SSL Configuration
      • Firewall and Proxy
      • Logging
    •  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
      • Connecting to SharePoint
      • Authenticating to SharePoint Online
      • Authenticating to SharePoint On Premises
      • Authenticating with Kerberos
    •  Advanced Tab
      • Connection String Options
    • Logging
    •  Using OAuth Authentication
      • Embedded Credentials
      • Custom Credentials
    •  Headless Machines
      • Using OAuth on a Headless Machine
    •  Creating a Custom OAuth App
      • When to Create a Custom OAuth App
      • Steps to Create a Custom OAuth App
    •  Create credentials using Sharepoint App
      • Steps to Create a Sharepoint App
    •  Admin Consent
      • Admin Consent Permissions
    •  OAuthJWT Certificate Authentication
      • Client OAuth Flow With A Certificate
    •  Using Azure Service Principal Authentication
      • Custom Credentials
    •  Creating a Custom OAuth App
      • Steps to Create a Custom OAuth App
      • Custom Credentials
    • Connecting to REST API
    •  Using Kerberos
      • Authenticating with Kerberos
      • Retrieve the Kerberos Ticket
      • Cross-Realm Authentication
    •  Fine-Tuning Data Access
      • Fine Tuning the SharePoint Connection
    •  Advanced Features
      • User Defined Views
      • SSL Configuration
      • Firewall and Proxy
      • Logging
    •  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 SingleStore Adapter
  •  TDV Snowflake Adapter
    •  Getting Started
      • Deploying the Adapter
      • Connecting to Snowflake
    •  Basic Tab
      • Connecting to Snowflake
      • Authenticating to Snowflake
      • Configuring Access Control
    •  Advanced Tab
      • Connection String Options
    • Logging
    •  Using OAuth Authentication
      • Custom Credentials
      • Creating a Custom OAuth Integration
    •  Headless Machines
      • Using the Credentials for a Custom OAuth App
    •  Creating a Custom OAuth App
      • Create an OAuth Integration
    •  Changelog
      • General Changes
      • Snowflake Changes
    •  Advanced Features
      • User Defined Views
      • SSL Configuration
      • Firewall and Proxy
      • Logging
    •  SQL Compliance
      • SELECT Statements
      • SELECT INTO Statements
      • INSERT Statements
      • UPDATE Statements
      • DELETE Statements
      • EXECUTE Statements
    •  Data Model
      • Stored Procedures
    • SnowFlake Adapter Limitations
  •  TDV SparkSQL Adapter
    •  Getting Started
      • Deploying the Adapter
      • Connecting to SparkSQL
    •  Basic Tab
      • Connecting to SparkSQL
      • Authenticating to SparkSQL
      • Connecting to Databricks
    •  Advanced Tab
      • Connection String Options
    • Logging
    • Using Kerberos
    •  Advanced Features
      • User Defined Views
      • SSL Configuration
      • Firewall and Proxy
      • Logging
    • 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

Adapter Online Help

Stored Procedures