Microsoft Access 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.This default setting specifies which agents should be associated with the data source in a multi-agent deployment.

    Configuration Method: Select Credentials or URI as a configuration method.
    Configuration Method: Credentials
    • Username/Password: Credentials that provide access to the specified database.
    • Database File:
    Configuration Method: URI
    • Username/Password: Credentials that provide access to the specified database.
    • URI: For example, URL would look like jdbc: postgresql://localhost:<port_no>/.

    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.