Denodo data source

Administer Pentaho Data Catalog
Version
10.0.x
Audience
anonymous
Part Number
MK-95PDC002-00

Perform the following steps to identify your data source within Data Catalog:
  1. Click Management in the left toolbar.
    The Manage Your Environment page opens.
  2. In the Resources tile, click Add Data Source.
    The Create Data Source page opens.
  3. Specify the following basic information for the connection to your data source:
    Field Description
    Data Source Name Specify the name of your data source. This name is used in the Data Catalog interface. It should be something your Data Catalog users recognize.
    Note: Names must start with a letter, and must contain only letters, digits, and underscores. White spaces in names are not supported.
    Data Source ID (Optional) Specify a permanent identifier for your data source. If you leave this field blank, Data Catalog generates a permanent identifier for you.
    Note: You cannot modify Data Source ID for this data source after you specify or generate it.
    Description (Optional) Specify a description of your data source.
    Data Source Type Select the database type of your source. You are then prompted to specify additional connection information based on the file system or database type you are trying to access.
  4. After you have specified the basic information, specify the following additional connection information based on the file system or database type you are trying to access.
    Field Description
    Affinity

    This default setting specifies which agents should be associated with the data source in a multi-agent deployment.
    Configuration method By default, it is URI, as the connection is configured using a URL.
    • Username and Password: Credentials associated with your Denodo account to log in and access the Denodo environment.
    • URI: URIs are used to access and manage various objects and services within the Denodo environment. For example, the URI would look like vdp://denodo-server:9999/data-sources/MyDatabase
    • Database Name: The name of the data sources within the Denodo environment that contain the data you want to access.
    Driver Select an existing driver or upload a new driver to ensure that the communication between the application and the database is efficient, secure, and follows the required standards.

    To upload a new driver, click Manage Drivers, and click Add New, upload the driver, and then click Add Driver.

    After you have specified the detailed information according to your data source type, test the connection to the data source and add the data source.

  5. Click Test Connection to test your connection to the specified data source.
    Note: Before you finalize and save your new data source configuration, you need to perform a process called Ingest Schemas. This process loads fundamental information about the database schema and related metadata into the system.
  6. Click Ingest Schema, select the schemas, and then click Ingest Schemas.
    Note: Although you can select all schemas, it is recommended to avoid selecting certain system-related schemas that are unnecessary for your needs.
  7. (Optional) Enter a Note for any information you need to share with others who might access this data source.
  8. Click Create Data Source to establish your data source connection.