Skip to main content

Additional Tags

Following tags are some additional tags which might not be required for most of the data sources, but still those may be required for some of them. These can be added as per the structure of database:

  1. <system-schemas> </system-schemas>:
    In this tag, the names of the system schemas are provided for a database. You can also provide pattern of the systemSchemasName along with the names of System Schemas within this tag. When Include System Schema/DB Name checkbox is unchecked on the Connections Screen, these schemas will not appear.

    For e.g.,<system-schemas>information_schema,dgcontroller,dgcontrol,dghdfsinfo,dgstar,public, pg_.*</system-schemas>

  2. <ignore-table-names></ignore-table-names>:
    This tag is used for providing the name of the tables which can be ignored. All these tables will not be scanned even if these tables are included through filter object screen.

    For e.g.,<ignore-table-names>OptionSetInfo,RecommendedDocument</ignore-table-names>

  3. <features></features>:
    The valid values for this tag are DISCOVER, MASKER. Only one value can be provided i.e., DISCOVER because MASKER value is for internal use only. By providing the value DISCOVER in this tag, detection support for the database will be added. By default, the value is set to DISCOVER.

    For e.g.,
    <features>
    <value>DISCOVER</value>
    </features> 

  4. <fetch-constraints></fetch-constraints>:
    This tag accepts Boolean value. The value is set to True if the constraints are supported for the database. If the value is True, and the database does not support the constraints, then you will get error in the logs like unable to fetch constraints. If value is set to False, then no constraints query will be executed for that database. By default, the value is set to False.

    For e.g.,<fetch-constraints>True</fetch-constraints>

  5. <empty-string-to-null></empty-string-to-null>:
    This tag is added for SAP HANA data source as there generated an empty string in case of null value. If the value is set to True, then value of the string is set from empty to null.

    For e.g.,<empty-string-to-null>True</empty-string-to-null>  

  6. <show-schema-name></show-schema-name>:
    This tag accepts Boolean value. The value is set to True, if you want to show schema names under Database field in the Result screen. In such a scenario, you can set the value of <append-schema-table-name> tag as False since the schemas are already displayed under Database field in the Result screen. By default, the value is set to False.

    For e.g.,<show-schema-name>True</show-schema-name>

  7. <sql-identifier></sql-identifier>:
    This is a parent tag. The values are provided in the child tags i.e., <start> and <end>.

    1. <start></start>:
      This tag is used for providing the specific character (supported by the database) which is enclosed at the start of the identifier names like tableName or databaseName. By default, the value is set to “ (double quotes)

    2. <end></end>:
      This tag is used for providing the specific character (supported by the database) which is enclosed at the end of the identifier names like tableName or databaseName. By default, the value is set to (double quotes)

      For e.g., in case of MySql database, backticks are supported as shown in the below query:
      Select ‘columnName’ from ‘schemaName’.`TableName’;

      So, you need to provide backtick in the <start> and <end> tags in case of MySql:        
      <sql-identifier>
      <start>`</start>
      <end>`</end>
      </sql-identifier>

      In case of Sql Server database, square brackets are supported as shown in the below query:
      Select [columnName] from [schemaName].[TableName];


      So, you need to provide square brackets ([]) in <start> and <end> tags in case of Sql Server:
      <sql-identifier>
      <start>[</start>
      <end>]</end>
      </sql-identifier>

      You can also use XML character entities in the child tags. XML have some symbols reserved for their use, which cannot be used as content in XML code. The ‘<’ and ‘>’ signs are used for opening and closing XML tags. To display these special characters, the character entities are used.

      <sql-identifier>
      <start&#60;</start>
      <end>&#62;</end>
      </sql-identifier>

Below tags can be used if the generic query used in the code is not working. Name of such tags are Random Sampling, Bottom Sampling, RowCount, etc. In this scenario, the query is customized accordingly for the database.

  1. <sampling-queries></sampling-queries>:
    This is the parent tag in which customized queries for Bottom, Top and Random Sampling can be provided.

    For e.g.,
    <sampling-queries>
    <bottom-data-query></bottom-data-query>
    <top-data-query></top-data-query>
    <random-data-query></random-data-query>

    </sampling-queries>

    1. <bottom-data-query> </bottom-data-query>: In this tag, the query for Bottom Sampling can be provided.

      For e.g.,

      <bottom-data-query>select getColumnList from getSchemaName.getTableName limit getTotalRowsInTable- getLimit,getLimit</bottom-data-query>

    2. <random-data-query></random-data-query>: Using this tag, you can provide the query for Random Sampling.

    3. <top-data-query></top-data-query>: Using this tag, you can provide the query for Top Sampling.

  2. <row-count-query></row-count-query>: Using this tag, you can provide query for getting total rows in the table. In this tag, you need to provide the alias to the column name in the query. This alias is fixed.

Column Name

Alias Name

COUNT

TotalRowsInTable

For e.g., in the below query the alias name for the column name Count is specified as TotalRowsInTable.

<row-count-query>SELECT COUNT(*) AS TotalRowsInTable FROM  getSchemaName.getTableName</row-count-query>

  1. <metadata-queries></metadata-queries>: This is the parent tag in which customized metadata queries can be provided in the child tags.

    1. <tables-query> </tables-query>: Use this tag to provide the query for getting the tables of the database. This tag must contain an attribute tableNameCol. This attribute provides an actual name of the column in which table names of the database are given.

      You need to provide an alias name of the column in the query. The Alias name is fixed and cannot be changed.

ColumnName

Alias

schemaName

TABLE_SCHEM

tableName

TABLE_NAME

Tabletype

TABLE_TYPE

Displaynameplural

DISPLAY_NAME

For e.g.,

<tables-query tableNameCol="tablename">select schemaname as TABLE_SCHEM,tablename as TABLE_NAME,tabletype as TABLE_TYPE,displaynameplural as DISPLAY_NAME  from sys_tables where tabletype in (getTableTypes)</tables-query>

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.