Loading...

Connecting to a Database with Data Cube

You can use Data Cube to collect, organize, and mine the data residing in various databases across your enterprise.

Before You Begin

  • You must be able to log in to the Web Console to view Data Cube. See Accessing the Web Console.
  • Only users assigned a role with the Data Connectors permission at the MediaAgent level can access Data Cube in the Analytics section of the Web Console. The associated MediaAgent must have been configured with Analytics Engine for Data Cube.
  • You need to obtain the following information to configure the source to the database:
    • Type of database management system provider. Only databases with a JDBC driver are supported.
    • JDBC URL that points to the database.
    • Database login credentials.
    • SQL query(s) to select the data that you want to crawl.

Procedure

  1. In a Web browser, log in to the Web Console and then click Analytics > Database.
  2. Under Data Connectors next to Database, click Add New.
  3. On the New Data Source (Database) page, configure the source as follows:
    1. Under Data Source Name:
      • Click the Analytics Engine list and select the Analytics Engine on which to store the crawling data.
      • In Data Source Name, enter a name for the data source. The name can only contain alphanumeric characters, underscores, and dashes.
      • In Data Source Description, enter a description for the data source.
      • Click Next to proceed to the next section.
    2. Under Database Connection Details:
      • Click the Driver list and select the appropriate DBMS driver for the database source.

        Note: If your database driver is not listed, you can add a Java Database Connector (JDBC) driver for your database. See Adding a Adding JDBC Drivers to Data Cube.

      • In Database URL, enter the JDBC URL for connecting to the database.
      • In Username and Password, enter credentials to connect to the database.
      • Click Next to proceed to the next section.
    3. Under SQL Query:
      • A table appears with the results of your SQL query.
      • If you need to modify your SQL query, click Previous to return to the SQL Query section. Otherwise, click Next to proceed to the next section.
    4. Under Advanced Options:
      • If a column in the database contains multiple values, click Add next to the Split by option, and then specify the column name and the delimiter used to separate the values in the column.

        Note: This option must be configured when creating the initial database source.

      • To crawl only updated values in the database, enable Incremental Crawl and enter a Primary Key, Delta SQL Query, and Delta Import SQL Query.

        For more information, see Incremental Crawling Database Sources.

      • Select Start Crawling Now to start crawling the data source after the data source is saved.
  4. When finished, click Submit.