Package io.revealbi.core.data

Class RVSqlServerDataSourceItem

java.lang.Object

io.revealbi.core.data.RVDataSourceItem

io.revealbi.core.data.RVSqlBasedDataSourceItem

io.revealbi.core.data.RVSqlPDSDataSourceItem

io.revealbi.core.data.RVSqlServerDataSourceItem

All Implemented Interfaces:

IProcessDataOnServerDataSourceItem

Direct Known Subclasses:

RVAzureSqlDataSourceItem, RVAzureSynapseDataSourceItem

public class RVSqlServerDataSourceItem
extends RVSqlPDSDataSourceItem

Microsoft SQL Server data source item.

Constructor Summary

Constructors

Constructor	Description
RVSqlServerDataSourceItem(RVSqlServerDataSource dataSource)

Method Summary

Modifier and Type	Method	Description
String	getProcedure()	(Optional) name of the stored procedure to get data from, the procedure is expected to return a result set and might have multiple parameters.
HashMap<String,Object>	getProcedureParameters()	Parameters to be passed to the stored procedure, if there is such specified in getProcedure().
String	getSchema()	Name of the schema the referenced table belongs to.
String	setProcedure(String value)	(Optional) name of the stored procedure to get data from, the procedure is expected to return a result set and might have multiple parameters.
HashMap<String,Object>	setProcedureParameters(HashMap<String,Object> value)	Parameters to be passed to the stored procedure, if there is such specified in getProcedure().
String	setSchema(String value)	Name of the schema the referenced table belongs to.

Methods inherited from class io.revealbi.core.data.RVSqlPDSDataSourceItem

getProcessDataOnServer, setProcessDataOnServer

Methods inherited from class io.revealbi.core.data.RVSqlBasedDataSourceItem

getCustomQuery, getDatabase, getTable, setCustomQuery, setDatabase, setTable

Methods inherited from class io.revealbi.core.data.RVDataSourceItem

getDataSource, getDefaultRefreshRate, getDescription, getId, getSubtitle, getTitle, setDataSource, setDefaultRefreshRate, setDescription, setId, setSubtitle, setTitle

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

RVSqlServerDataSourceItem

public RVSqlServerDataSourceItem(RVSqlServerDataSource dataSource)

Method Details

setSchema

public String setSchema(String value)

Name of the schema the referenced table belongs to.

Parameters:

value -

Returns:

getSchema

public String getSchema()

Name of the schema the referenced table belongs to.

Returns:

setProcedure

public String setProcedure(String value)

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

Parameters:

value -

Returns:

getProcedure

public String getProcedure()

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

Returns:

setProcedureParameters

public HashMap<String,Object> setProcedureParameters(HashMap<String,Object> value)

Parameters to be passed to the stored procedure, if there is such specified in getProcedure().

Parameters:

value -

Returns:

getProcedureParameters

public HashMap<String,Object> getProcedureParameters()

Parameters to be passed to the stored procedure, if there is such specified in getProcedure().

Returns: