• CData Excel Add-In for Epicor Kinetic
  • Getting Started
    • Establishing a Connection
    • Creating an Entra ID (Azure AD) Application
      • Updating Your Custom AzureAD App
    • Changelog
  • Using the Excel Add-In
    • Managing Connections
    • Querying Data
    • Modifying Data
    • Writing Parameterized Queries
    • CData Excel Functions
  • Using the Excel Add-In (VBA)
    • Connecting from VBA
    • Querying Data
    • Executing Parameterized Queries
    • Modifying Data
    • Calling Stored Procedures
    • Invoking UI Elements
  • Advanced Features
    • User Defined Views
    • SSL Configuration
    • Firewall and Proxy
    • Query Processing
    • Logging
  • SQL Compliance
    • SQL Functions
      • STRING Functions
      • MATH Functions
      • DATE Functions
      • Date Literal Functions
    • SELECT Statements
      • Aggregate Functions
      • JOIN Queries
      • Window Functions
      • Table-Valued Functions
    • INSERT Statements
    • UPDATE Statements
    • DELETE Statements
    • CACHE Statements
    • EXECUTE Statements
    • PIVOT and UNPIVOT
  • Data Model
    • Views
      • Services
    • Stored Procedures
      • GetOAuthAccessToken
      • GetOAuthAuthorizationURL
      • RefreshOAuthAccessToken
    • System Tables
      • sys_catalogs
      • sys_schemas
      • sys_tables
      • sys_tablecolumns
      • sys_procedures
      • sys_procedureparameters
      • sys_keycolumns
      • sys_foreignkeys
      • sys_primarykeys
      • sys_indexes
      • sys_connection_props
      • sys_sqlinfo
      • sys_identity
      • sys_information
  • Connection Properties
    • Authentication
      • AuthScheme
      • URL
      • ERPInstance
      • User
      • Password
      • Service
    • Connection
      • ApiKey
      • ApiVersion
      • Company
    • Azure Authentication
      • AzureTenant
    • OAuth
      • OAuthClientId
      • OAuthClientSecret
      • CallbackURL
    • SSL
      • SSLServerCert
    • Firewall
      • FirewallType
      • FirewallServer
      • FirewallPort
      • FirewallUser
      • FirewallPassword
    • Proxy
      • ProxyAutoDetect
      • ProxyServer
      • ProxyPort
      • ProxyAuthScheme
      • ProxyUser
      • ProxyPassword
      • ProxySSLType
      • ProxyExceptions
    • Logging
      • Logfile
      • Verbosity
      • LogModules
      • MaxLogFileSize
      • MaxLogFileCount
    • Schema
      • Location
      • BrowsableSchemas
      • Tables
      • Views
    • Caching
      • AutoCache
      • CacheProvider
      • CacheConnection
      • CacheLocation
      • CacheTolerance
      • Offline
      • CacheMetadata
    • Miscellaneous
      • MaxRows
      • Other
      • Pagesize
      • Readonly
      • Timeout
      • UserDefinedViews
  • License
  • Third Party Copyrights