Class RVRedshiftDataSourceItem

Amazon Redshift data source item

Inheritance
System.Object
RVDataSourceItem
RVSqlBasedDataSourceItem
RVRedshiftDataSourceItem
Implements
Inherited Members
Namespace: Reveal.Sdk.Data.Amazon.Redshift
Assembly: Infragistics.Reveal.Connectors.Redshift.dll
Syntax
public class RVRedshiftDataSourceItem : RVSqlBasedDataSourceItem, IDataSourceItem, IParameterizedCustomQuerySupport, ICustomQuerySupport

Constructors

RVRedshiftDataSourceItem(RVRedshiftDataSource)

Declaration
public RVRedshiftDataSourceItem(RVRedshiftDataSource dataSource)
Parameters
Type Name Description
RVRedshiftDataSource dataSource

Properties

CustomQueryParameters

(Optional) Parameters to be used in the custom SQL query, if any. The parameters are expected to be named parameters in the query, like @param1, @param2, etc.

Declaration
public Dictionary<string, object> CustomQueryParameters { get; set; }
Property Value
Type Description
System.Collections.Generic.Dictionary<System.String, System.Object>

FunctionName

(Optional) name of the function to get data from, the function is expected to return a result set and might have multiple parameters.

Declaration
public string FunctionName { get; set; }
Property Value
Type Description
System.String

FunctionParameters

Parameters to be passed to the function, if there is such specified in FunctionName.

Declaration
public Dictionary<string, object> FunctionParameters { get; set; }
Property Value
Type Description
System.Collections.Generic.Dictionary<System.String, System.Object>

Procedure

(Optional) name of the stored procedure to get data from. The procedure is expected to have a REFCURSOR inout parameter and might have additional input parameters.

Declaration
public string Procedure { get; set; }
Property Value
Type Description
System.String

ProcedureParameters

Parameters to be passed to the stored procedure, if there is such specified in Procedure.

Declaration
public Dictionary<string, object> ProcedureParameters { get; set; }
Property Value
Type Description
System.Collections.Generic.Dictionary<System.String, System.Object>

Schema

Name of the schema the referenced table belongs to

Declaration
public string Schema { get; set; }
Property Value
Type Description
System.String

Methods

CreateModelDataSourceItem()

Declaration
public override BaseDataSourceItem CreateModelDataSourceItem()
Returns
Type Description
Infragistics.ReportPlus.DashboardModel.BaseDataSourceItem
Overrides
RVSqlBasedDataSourceItem.CreateModelDataSourceItem()

Implements

IParameterizedCustomQuerySupport
ICustomQuerySupport