Loading...

Data Cube Database Connection Options

The following additional and advanced options are available for configuring a database source with Data Cube.

Note: All SQL queries and column names are case sensitive.

Option

Description

Index Server

Select the Index Server to use for crawling the data source.

Only the Index Servers that are configured for Data Cube and associated with the user who is logged in to Web Console appear.

Data Source Name

Enter the name of the data source as you want it to appear in Data Cube.

SQL Query

A SQL query that selects the data from the database that you want to crawl.

To connect to a database, you must enter a SQL query in this field.

Crawl Option

Select this option to crawl the data source immediately.

To manually crawl the database, see Crawling Data Connections.

Split by

If a column in the database contains multiple values, then use this option to specify the column name and the delimiter that is used to separate the values.

Note: When you create the initial database source, you must use this option.

Incremental Crawling

Select this option to crawl only updated values in the database.

If you select this option, consider the following points:

  • You must enter values in Primary Key, Delta SQL Query, and Delta Import SQL Query.
  • The first crawl of the database uses the query in SQL Query. Subsequent crawls use the queries in Delta SQL Query and Delta Import SQL Query.

    If you don't select this option, then all crawls use the query in SQL Query.

Primary Key

Specifies the column that is the primary key in the database.

If you select Incremental Crawling, then you must enter this value.

Delta SQL Query

A SQL query that defines the criteria for determining the fields that were updated after the previous crawl.

If you select Incremental Crawling, then you must enter this value.

Delta Import SQL Query

A SQL query that selects the data to import from the database for the rows that match the criteria in Delta SQL Query.

If you select Incremental Crawling, then you must enter this value.

Last modified: 2/12/2019 8:18:11 PM