Package io.revealbi.core.data

Class RVSqlServerDataSource

java.lang.Object

io.revealbi.core.data.RVDashboardDataSource

io.revealbi.core.data.RVSqlBasedDataSource

io.revealbi.core.data.RVSqlPDSDataSource

io.revealbi.core.data.RVSqlServerDataSource

All Implemented Interfaces:

IProcessDataOnServerDataSource

Direct Known Subclasses:

RVAzureSqlDataSource, RVAzureSynapseDataSource

public class RVSqlServerDataSource
extends RVSqlPDSDataSource

Microsoft SQL Server data source, it adds the database name property to the base properties in RVSqlBasedDataSource.

Field Summary

Fields

Modifier and Type	Field	Description
static final String	PROVIDER_KEY

Constructor Summary

Constructors

Constructor	Description
RVSqlServerDataSource()

Method Summary

Modifier and Type	Method	Description
String	getDatabase()	Name of the database to connect to.
Boolean	getEncrypt()	If not null, the Encrypt flag will be set in the connection string to the specified value.
String	getProviderKey()
String	getSchema()	Name of the schema to use to filter tables, views and store procedures, by default all schemas are displayed.
Boolean	getTrustServerCertificate()	If not null, the TrustServerCertificate flag will be set in the connection string to the specified value.
String	setDatabase(String value)	Name of the database to connect to.
Boolean	setEncrypt(Boolean value)	If not null, the Encrypt flag will be set in the connection string to the specified value.
String	setSchema(String value)	Name of the schema to use to filter tables, views and store procedures, by default all schemas are displayed.
Boolean	setTrustServerCertificate(Boolean value)	If not null, the TrustServerCertificate flag will be set in the connection string to the specified value.

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

getProcessDataOnServerDefaultValue, getProcessDataOnServerReadOnly, setProcessDataOnServerDefaultValue, setProcessDataOnServerReadOnly

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

getHost, getPort, setHost, setPort

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

getDefaultRefreshRate, getId, getSubtitle, getTitle, setDefaultRefreshRate, setId, setSubtitle, setTitle

Methods inherited from class java.lang.Object

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

Field Details

PROVIDER_KEY

public static final String PROVIDER_KEY

See Also:

• Constant Field Values

Constructor Details

RVSqlServerDataSource

public RVSqlServerDataSource()

Method Details

setDatabase

public String setDatabase(String value)

Name of the database to connect to.

Parameters:

value -

Returns:

getDatabase

public String getDatabase()

Name of the database to connect to.

Returns:

setSchema

public String setSchema(String value)

Name of the schema to use to filter tables, views and store procedures, by default all schemas are displayed.

Parameters:

value -

Returns:

getSchema

public String getSchema()

Name of the schema to use to filter tables, views and store procedures, by default all schemas are displayed.

Returns:

setTrustServerCertificate

public Boolean setTrustServerCertificate(Boolean value)

If not null, the TrustServerCertificate flag will be set in the connection string to the specified value.

Parameters:

value -

Returns:

getTrustServerCertificate

public Boolean getTrustServerCertificate()

If not null, the TrustServerCertificate flag will be set in the connection string to the specified value.

Returns:

setEncrypt

public Boolean setEncrypt(Boolean value)

If not null, the Encrypt flag will be set in the connection string to the specified value.

Parameters:

value -

Returns:

getEncrypt

public Boolean getEncrypt()

If not null, the Encrypt flag will be set in the connection string to the specified value.

Returns:

getProviderKey

public String getProviderKey()

Specified by:

getProviderKey in class RVDashboardDataSource