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 Details

  • 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:

    • setApplicationIntentReadOnly

      public Boolean setApplicationIntentReadOnly(Boolean value)
      If true, sets ApplicationIntent=ReadOnly in the connection string.
      Parameters:
      value -
      Returns:

    • getApplicationIntentReadOnly

      public Boolean getApplicationIntentReadOnly()
      If true, sets ApplicationIntent=ReadOnly in the connection string.
      Returns:

    • setMultiSubnetFailover

      public Boolean setMultiSubnetFailover(Boolean value)
      If null, omits MultiSubnetFailover from the connection string; if non-null, explicitly sets MultiSubnetFailover to True or False in the connection string.
      Parameters:
      value -
      Returns:

    • getMultiSubnetFailover

      public Boolean getMultiSubnetFailover()
      If null, MultiSubnetFailover is omitted from the connection string; if non-null, MultiSubnetFailover is explicitly set to True or False in the connection string.
      Returns:

    • getProviderKey

      public String getProviderKey()
      Specified by:
      getProviderKey in class RVDashboardDataSource