Custom Function Database Types

Yellowfin FAQ shared this question 6 years ago
Answered

What values can I put into the <database> tag?

Best Answer
photo

Here is a complete list of values that will be accepted in the <database> tag of custom functions:

  • AS400
  • ASTER
  • CACHEDB
  • COLUMNAR
  • COMPOSITE
  • DB2
  • DERBY
  • FILEMAKER
  • FIREBIRD
  • H2
  • HSQLDB
  • INFORMIX
  • INGRES
  • INTERBASE
  • LUCIDDB
  • MONETDB
  • MYSQL
  • OPENEDGE
  • ORACLE
  • PARSTREAM
  • PERVASIVE
  • PHOENIX
  • POSTGRESQL
  • PROGRESS
  • REDBRICK
  • SIMBA
  • SQL_SERVER
  • SQLITE
  • SYBASE_ASA
  • SYBASE_ASE
  • SYBASE_IQ
  • TERADATA
  • UNIVERSE
  • DIAPRISM
  • VECTORWISE
  • NUODB
  • NETEZZA
  • CONNECTIONCLOUD
  • SAPHANA
  • SASJDBC
  • HIVE
  • HIVE2
  • VERTICA
  • DATACURRENT
  • BIGQUERY
  • SALESFORCE
  • GREENPLUM
  • REDSHIFT
  • RDS
  • INFOBRIGHT
  • BMCACTIONREQUEST
  • MARIADB
  • AZURE
  • METADATADB
  • DATABOOSTER
  • SPECTRUM
  • GOOGLECLOUDSQL
  • TREASUREDATA
  • PRESTO
  • SNOWFLAKE
  • EXASOL

Additionally, the following variations will also be accepted

  • Cache DB -> CACHEDB
  • HSQL -> HSQLDB
  • Postgres -> POSTGRESQL
  • SQLServer -> SQL_SERVER
  • SQL Server -> SQL_SERVER
  • MSSQLServer -> SQL_SERVER
  • SQLLite -> SQLITE
  • SQL Lite -> SQLITE
  • SybaseASA -> SYBASE_ASA
  • Sybase ASA -> SYBASE_ASA
  • SybaseASE -> SYBASE_ASE
  • Sybase ASE -> SYBASE_ASE
  • SybaseIQ -> SYBASE_IQ
  • Sybase IQ -> SYBASE_IQ
  • LotusNotes -> NOTES
  • Lotus Notes -> NOTES
  • MSAccess -> ACCESS
  • FoxProODBC -> FOXPRO
  • Netezza -> NETEZZA
  • KISAM -> KISAM
  • MarkLogic -> MARKLOGIC
  • GenericJDBC -> UNKNOWN
  • GenericODBC -> ODBC

Replies (1)

photo
1

Here is a complete list of values that will be accepted in the <database> tag of custom functions:

  • AS400
  • ASTER
  • CACHEDB
  • COLUMNAR
  • COMPOSITE
  • DB2
  • DERBY
  • FILEMAKER
  • FIREBIRD
  • H2
  • HSQLDB
  • INFORMIX
  • INGRES
  • INTERBASE
  • LUCIDDB
  • MONETDB
  • MYSQL
  • OPENEDGE
  • ORACLE
  • PARSTREAM
  • PERVASIVE
  • PHOENIX
  • POSTGRESQL
  • PROGRESS
  • REDBRICK
  • SIMBA
  • SQL_SERVER
  • SQLITE
  • SYBASE_ASA
  • SYBASE_ASE
  • SYBASE_IQ
  • TERADATA
  • UNIVERSE
  • DIAPRISM
  • VECTORWISE
  • NUODB
  • NETEZZA
  • CONNECTIONCLOUD
  • SAPHANA
  • SASJDBC
  • HIVE
  • HIVE2
  • VERTICA
  • DATACURRENT
  • BIGQUERY
  • SALESFORCE
  • GREENPLUM
  • REDSHIFT
  • RDS
  • INFOBRIGHT
  • BMCACTIONREQUEST
  • MARIADB
  • AZURE
  • METADATADB
  • DATABOOSTER
  • SPECTRUM
  • GOOGLECLOUDSQL
  • TREASUREDATA
  • PRESTO
  • SNOWFLAKE
  • EXASOL

Additionally, the following variations will also be accepted

  • Cache DB -> CACHEDB
  • HSQL -> HSQLDB
  • Postgres -> POSTGRESQL
  • SQLServer -> SQL_SERVER
  • SQL Server -> SQL_SERVER
  • MSSQLServer -> SQL_SERVER
  • SQLLite -> SQLITE
  • SQL Lite -> SQLITE
  • SybaseASA -> SYBASE_ASA
  • Sybase ASA -> SYBASE_ASA
  • SybaseASE -> SYBASE_ASE
  • Sybase ASE -> SYBASE_ASE
  • SybaseIQ -> SYBASE_IQ
  • Sybase IQ -> SYBASE_IQ
  • LotusNotes -> NOTES
  • Lotus Notes -> NOTES
  • MSAccess -> ACCESS
  • FoxProODBC -> FOXPRO
  • Netezza -> NETEZZA
  • KISAM -> KISAM
  • MarkLogic -> MARKLOGIC
  • GenericJDBC -> UNKNOWN
  • GenericODBC -> ODBC

Leave a Comment
 
Attach a file