EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  3. Topics

KB441865: What are the database object types utilized hosting the MicroStrategy Metadata on SQL Server

Chris Robinson

Principal Product Specialist • Strategy

This technical article describes the database object types used when connecting to the MicroStrategy Metadata hosted by SQL Server

What are database object types?
For this article, these are objects specific to SQL Server used to carry out the various functions the database needs for proper functionality. Each database has their own set of objects and their own way of storing the definition of them.
For more information regarding this, see the following article:
https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-objects-transact-sql?view=sql-server-2017
Which of these types are utilized by the Strategy Metadata?
Not all types available are utilized by Strategy. For a list of the utilized types, see the below list:

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRINGFNSQL_SCALAR_FUNCTIONSQSERVICE_QUEUEUUSER_TABLEDDEFAULT_CONSTRAINTPKPRIMARY_KEY_CONSTRAINTSSYSTEM_TABLEITINTERNAL_TABLEPSQL_STORED_PROCEDURETRSQL_TRIGGER

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRINGFNSQL_SCALAR_FUNCTIONSQSERVICE_QUEUEUUSER_TABLEDDEFAULT_CONSTRAINTPKPRIMARY_KEY_CONSTRAINTSSYSTEM_TABLEITINTERNAL_TABLEPSQL_STORED_PROCEDURETRSQL_TRIGGER

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRINGFNSQL_SCALAR_FUNCTIONSQSERVICE_QUEUEUUSER_TABLEDDEFAULT_CONSTRAINTPKPRIMARY_KEY_CONSTRAINTSSYSTEM_TABLEITINTERNAL_TABLEPSQL_STORED_PROCEDURETRSQL_TRIGGER

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRINGFNSQL_SCALAR_FUNCTIONSQSERVICE_QUEUEUUSER_TABLEDDEFAULT_CONSTRAINTPKPRIMARY_KEY_CONSTRAINTSSYSTEM_TABLEITINTERNAL_TABLEPSQL_STORED_PROCEDURETRSQL_TRIGGER

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRINGFNSQL_SCALAR_FUNCTIONSQSERVICE_QUEUEUUSER_TABLEDDEFAULT_CONSTRAINTPKPRIMARY_KEY_CONSTRAINTSSYSTEM_TABLEITINTERNAL_TABLEPSQL_STORED_PROCEDURETRSQL_TRIGGER

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRINGFNSQL_SCALAR_FUNCTIONSQSERVICE_QUEUEUUSER_TABLEDDEFAULT_CONSTRAINTPKPRIMARY_KEY_CONSTRAINTSSYSTEM_TABLEITINTERNAL_TABLEPSQL_STORED_PROCEDURETRSQL_TRIGGER

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRINGFNSQL_SCALAR_FUNCTIONSQSERVICE_QUEUEUUSER_TABLEDDEFAULT_CONSTRAINTPKPRIMARY_KEY_CONSTRAINTSSYSTEM_TABLEITINTERNAL_TABLEPSQL_STORED_PROCEDURETRSQL_TRIGGER

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRINGFNSQL_SCALAR_FUNCTIONSQSERVICE_QUEUEUUSER_TABLEDDEFAULT_CONSTRAINTPKPRIMARY_KEY_CONSTRAINTSSYSTEM_TABLEITINTERNAL_TABLEPSQL_STORED_PROCEDURETRSQL_TRIGGER

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRINGFNSQL_SCALAR_FUNCTIONSQSERVICE_QUEUEUUSER_TABLEDDEFAULT_CONSTRAINTPKPRIMARY_KEY_CONSTRAINTSSYSTEM_TABLEITINTERNAL_TABLEPSQL_STORED_PROCEDURETRSQL_TRIGGER

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRINGFNSQL_SCALAR_FUNCTIONSQSERVICE_QUEUEUUSER_TABLEDDEFAULT_CONSTRAINTPKPRIMARY_KEY_CONSTRAINTSSYSTEM_TABLEITINTERNAL_TABLEPSQL_STORED_PROCEDURETRSQL_TRIGGER

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRINGFNSQL_SCALAR_FUNCTIONSQSERVICE_QUEUEUUSER_TABLEDDEFAULT_CONSTRAINTPKPRIMARY_KEY_CONSTRAINTSSYSTEM_TABLEITINTERNAL_TABLEPSQL_STORED_PROCEDURETRSQL_TRIGGER

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRINGFNSQL_SCALAR_FUNCTIONSQSERVICE_QUEUEUUSER_TABLEDDEFAULT_CONSTRAINTPKPRIMARY_KEY_CONSTRAINTSSYSTEM_TABLEITINTERNAL_TABLEPSQL_STORED_PROCEDURETRSQL_TRIGGER

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRINGFNSQL_SCALAR_FUNCTIONSQSERVICE_QUEUEUUSER_TABLEDDEFAULT_CONSTRAINTPKPRIMARY_KEY_CONSTRAINTSSYSTEM_TABLEITINTERNAL_TABLEPSQL_STORED_PROCEDURETRSQL_TRIGGER

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRINGFNSQL_SCALAR_FUNCTIONSQSERVICE_QUEUEUUSER_TABLEDDEFAULT_CONSTRAINTPKPRIMARY_KEY_CONSTRAINTSSYSTEM_TABLEITINTERNAL_TABLEPSQL_STORED_PROCEDURETRSQL_TRIGGER

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRINGFNSQL_SCALAR_FUNCTIONSQSERVICE_QUEUEUUSER_TABLEDDEFAULT_CONSTRAINTPKPRIMARY_KEY_CONSTRAINTSSYSTEM_TABLEITINTERNAL_TABLEPSQL_STORED_PROCEDURETRSQL_TRIGGER

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRINGFNSQL_SCALAR_FUNCTIONSQSERVICE_QUEUEUUSER_TABLEDDEFAULT_CONSTRAINTPKPRIMARY_KEY_CONSTRAINTSSYSTEM_TABLEITINTERNAL_TABLEPSQL_STORED_PROCEDURETRSQL_TRIGGER

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRINGFNSQL_SCALAR_FUNCTIONSQSERVICE_QUEUEUUSER_TABLEDDEFAULT_CONSTRAINTPKPRIMARY_KEY_CONSTRAINTSSYSTEM_TABLEITINTERNAL_TABLEPSQL_STORED_PROCEDURETRSQL_TRIGGER

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRINGFNSQL_SCALAR_FUNCTIONSQSERVICE_QUEUEUUSER_TABLEDDEFAULT_CONSTRAINTPKPRIMARY_KEY_CONSTRAINTSSYSTEM_TABLEITINTERNAL_TABLEPSQL_STORED_PROCEDURETRSQL_TRIGGER

KB441865

Comment

0 comments

Details

Knowledge Article

Published:

September 21, 2018

Last Updated:

January 4, 2019