Tabular |
A tabular data provider. Commonly used to connect to a Web service.
Inheritance HierarchySystemObject
Dundas.BI.ExtensibilityComponentBase
Dundas.BI.Data.DataProvidersDataProvider
Dundas.BI.Data.DataProviders.RelationalRelationalDataProvider
Dundas.BI.Data.DataProviders.SpecialTabularProvider
Dundas.BI.ExtensibilityComponentBase
Dundas.BI.Data.DataProvidersDataProvider
Dundas.BI.Data.DataProviders.RelationalRelationalDataProvider
Dundas.BI.Data.DataProviders.SpecialTabularProvider
Namespace: Dundas.BI.Data.DataProviders.Special
Assembly: Dundas.BI.Core (in Dundas.BI.Core.dll) Version: 2.0.0.0 (26.2.0.1000)
SyntaxThe TabularProvider type exposes the following members.
Constructors| Name | Description | |
|---|---|---|
 | TabularProvider | Initializes a new instance of the TabularProvider class |
Properties| Name | Description | |
|---|---|---|
 | ComponentDescription |
Gets the standard component description.
(Inherited from ComponentBase) |
| ComponentId |
Gets the component ID.
(Inherited from ComponentBase) |
| ComponentName |
Gets the standard component name.
(Inherited from ComponentBase) |
| GenericCountExpression |
Gets the generic count expression for number of queried records.
(Inherited from RelationalDataProvider) |
| HasCustomConfigurationUI |
Gets a value indicating whether this data provider is using a custom configuration UI.
(Inherited from DataProvider) |
| IsEnabled | Gets a value indicating whether the component is enabled. (Inherited from ComponentBase) |
| ManualAuthentication |
Gets a value indicating whether the data provider is expecting no external authentication.
(Inherited from DataProvider) |
| MaximumParameterValueCount |
Gets the maximum number of parameter values the provider is able to support.
(Inherited from DataProvider) |
| NamedParameterFormat |
Gets the named parameter format.
(Overrides DataProviderNamedParameterFormat) |
| NullReplacementExpression |
Gets the NULL replacement expression or if not supported.
(Inherited from RelationalDataProvider) |
| PackageId |
Gets the ID of the extension package to which the component belongs.
(Inherited from ComponentBase) |
| PropertyDescriptors |
Gets the data provider specific property descriptors.
(Inherited from DataProvider) |
| QueryHints |
Gets the query hints that are supported by the current provider.
(Inherited from DataProvider) |
| RequiresAllColumnDefinitionsWhenReadingFromManualQueries |
Gets a value indicating if all column definitions must be supplied when retrieving data using a manual query.
(Inherited from RelationalDataProvider) |
| SingleValueArrayFilterExpression |
Gets the single value array filter format or Empty if not supported.
(Inherited from RelationalDataProvider) |
| StructureDescriptors | Gets the data provider specific descriptors for tabular structure settings. |
| SupportedDateTrimGranularities |
Gets the supported date trimming functions.
(Overrides RelationalDataProviderSupportedDateTrimGranularities) |
| SupportedStructureTypes |
Gets the supported data structures.
(Overrides RelationalDataProviderSupportedStructureTypes) |
| SupportsArrayFlattening |
Gets a value indicating whether the provider supports flattening of array elements.
(Inherited from DataProvider) |
| SupportsManualQuery |
Gets a value indicating whether this data provider supports manual queries.
(Overrides DataProviderSupportsManualQuery) |
| SupportsParameterPushDown |
Gets a value indicating whether this data provider supports pushing parameters into queries.
(Overrides RelationalDataProviderSupportsParameterPushDown) |
| SupportsSelectElementsExpansion |
Gets a value indicating whether this provider supports injecting additional elements
into a SelectTransform via GetExpandedElements(IListDataParameterValue, DataConnector).
When , the transform will call GetExpandedElements(IListDataParameterValue, DataConnector)
during refresh and validation to auto-select provider-driven columns
(e.g. columns from an OData $expand navigation property).
(Inherited from DataProvider) |
| SupportsSessionSchemas |
Gets a value indicating whether this data provider supports session schemas.
(Inherited from RelationalDataProvider) |
| SupportsTopOneElementDiscovery |
Gets a value indicating whether this data provider supports top one element discovery behaviour.
(Inherited from DataProvider) |
| UsingProviderData |
Gets a value indicating whether this data provider calls LoadProviderData and SaveProviderData(String).
(Inherited from DataProvider) |
Methods| Name | Description | |
|---|---|---|
 | AllowStoringResult |
Gets a value indicating whether the data returned by this provider can be put into cache or used in storage jobs.
(Inherited from DataProvider) |
| AreCompatible |
Determines if two connectors are compatible for possible generation of single SQL.
(Inherited from RelationalDataProvider) |
| BuildConnectionString |
Builds the connection string.
(Inherited from DataProvider) |
| CreateReader |
Creates the reader for the specified query object.
(Inherited from RelationalDataProvider) |
| CreateTable |
Creates a database table.
(Inherited from RelationalDataProvider) |
| CreateTemporaryTable |
Creates a temporary table.
(Inherited from RelationalDataProvider) |
| DiscoverColumns |
Discovers the columns for the specified query object.
(Inherited from RelationalDataProvider) |
| DiscoverParameters | Discovers the best parameters. |
| DiscoverStructure(IDisposable, DataStructure) |
Discovers the structure definition.
(Overrides DataProviderDiscoverStructure(IDisposable, DataStructure)) |
| DiscoverStructure(IDisposable, SupportedDataStructures, String) |
Gets the structure definition with the specified name.
(Overrides DataProviderDiscoverStructure(IDisposable, SupportedDataStructures, String)) |
| DiscoverStructures |
Gets the list of the structures with the specified type.
(Inherited from DataProvider) |
| EnumerateCustom |
Enumerates the provider-specific values.
(Inherited from DataProvider) |
| EnumerateDatabases |
Enumerates the available databases.
(Overrides DataProviderEnumerateDatabases(ICollectionParameterValue)) |
| EnumerateServers |
Enumerates the available database servers.
(Overrides DataProviderEnumerateServers) |
| GenerateDefaultDataConnector | Generates default data connector. (Inherited from DataProvider) |
| GenerateFunctionCall |
Generates the statement that calls the table-valued function.
(Inherited from RelationalDataProvider) |
| GenerateQuery |
Generates the query.
(Inherited from RelationalDataProvider) |
| GetBasicStructureDetails |
Get basic details of the structure.
(Inherited from DataProvider) |
| GetCapabilities |
Gets the relational provider capabilities.
(Overrides RelationalDataProviderGetCapabilities(IProviderConnector)) |
| GetCastExpression |
Gets a data conversion expression, used in general for avoiding overflow exceptions when using aggregates.
(Overrides RelationalDataProviderGetCastExpression(DatabaseType)) |
| GetCollectionValueArrayFilterExpression |
Gets the collection value array filter expression.
(Inherited from RelationalDataProvider) |
| GetConnection |
Gets the open connection.
(Inherited from DataProvider) |
| GetCredentialsProviderId |
Gets the ID of the credentials provider.
(Inherited from DataProvider) |
| GetCustomConfigurationUI |
Gets the custom configuration UI based on the requested content type.
(Inherited from DataProvider) |
| GetDataCacheKey |
Gets the data cache key.
(Inherited from DataProvider) |
| GetDateTrimFunction(DateTimeGranularity, String) |
Returns a function that can be used to 'trim date/time' values to a specified grain.
(Overrides RelationalDataProviderGetDateTrimFunction(DateTimeGranularity, String)) |
| GetDateTrimFunction(IProviderConnector, DateTimeGranularity, String) |
Returns a function that can be used to 'trim date/time' values to a specified grain.
(Inherited from RelationalDataProvider) |
| GetDefaultStructureName |
Gets the default structure name.
(Inherited from DataProvider) |
| GetDiagnosticInfo | Gets diagnostic information about the data provider. (Inherited from DataProvider) |
| GetExpandedElements |
Returns additional elements to be used in the SelectTransform.
(Inherited from DataProvider) |
| GetIncrementalWarehouseSupportType |
Gets the type of incremental warehouse support provided by this data provider.
(Overrides RelationalDataProviderGetIncrementalWarehouseSupportType(ParameterValueCollection)) |
| GetOpenReader(IDisposable, QueryDefinition) |
Creates and opens the reader for the specified query object.
(Inherited from RelationalDataProvider) |
| GetOpenReader(IDisposable, QueryDefinition, CommandBehavior) |
Creates and opens the reader for the specified query object.
(Inherited from RelationalDataProvider) |
| GetRemoteConnectionMetadata |
Gets the remote connection specific metadata.
(Overrides RelationalDataProviderGetRemoteConnectionMetadata(IProviderConnector)) |
| GetRemoteMetadata |
Gets the remote metadata.
(Overrides RelationalDataProviderGetRemoteMetadata) |
| GetSingleRecord |
Returns the updated query statement with limit/top function wrapped with select query.
(Inherited from RelationalDataProvider) |
| GetSingleRecordWithLimit |
Returns the updated query statement with limit function wrapped within select query.
(Inherited from RelationalDataProvider) |
| GetSingleRecordWithLimitAndAlias |
Returns the updated query statement with limit function with alias wrapped within select query.
(Inherited from RelationalDataProvider) |
| GetSingleRecordWithTop |
Returns the updated query statement with top function wrapped within select query.
(Inherited from RelationalDataProvider) |
| GetStructureCustomConfigurationUI | Gets the custom configuration UI based on the requested content type for the structure. |
| GetSupportedAggregators |
Gets the supported aggregators.
(Inherited from RelationalDataProvider) |
| IsDriverInstalled |
Determines whether third party driver required for this data provider is installed.
(Inherited from DataProvider) |
| IsUsingUploadedFile |
Determines whether the connection is made to a file stored in Dundas BI database.
(Inherited from DataProvider) |
| LoadDynamicProviderValues | Loads the dynamically retrieved provider values. (Inherited from DataProvider) |
| Localize |
Localizes the specified string using the engine localization service.
(Inherited from ComponentBase) |
| LogQueryStatement |
Logs the query statement into Data.DataRetrieval.QueryAudit channel at the Information level.
(Inherited from DataProvider) |
| MakeCompatible |
Returns structure name from a different database.
(Inherited from RelationalDataProvider) |
| NormalizeName |
Escapes special characters or reserved words in a name.
(Overrides RelationalDataProviderNormalizeName(IProviderConnector, String)) |
| OnGetReader |
Called when GetOpenReader(IDisposable, QueryDefinition) is called.
(Inherited from RelationalDataProvider) |
| OnProviderValuesLoaded |
Allows the data provider a chance to view and modify the ProviderValues after they are retrieved from the Dundas BI database.
(Inherited from DataProvider) |
| ParseStructureName |
Parses the structure name.
(Inherited from RelationalDataProvider) |
| ProcessTask |
Processes the current task if the task is compatible with the data provider.
(Overrides RelationalDataProviderProcessTask(ProviderTransformTask)) |
| SetConnectionSchema |
Sets the schema on the connection.
(Inherited from RelationalDataProvider) |
| TestConnection |
Tests the connection.
(Inherited from DataProvider) |
| UpdateFromConnectionString |
Updates from connection string.
(Inherited from DataProvider) |
| ValidateProviderValues |
Validates data ProviderValues after they are retrieved from the Dundas BI database.
(Inherited from DataProvider) |
| ValidateSchema |
Determines if the schema is valid. Schema name can only contain alpha numeric character, underscore and hyphen.
(Inherited from RelationalDataProvider) |
| ValidateSchemaAgainstServer |
Validates the schema name against the actual source.
(Inherited from RelationalDataProvider) |
See Also