Before you create a catalog source, ensure that you have the information required to connect to the source system.
Perform the following tasks:
•Download the Denodo drivers and copy the denodo-vdp-jdbcdriver.jar file to the following location in your Secure Agent:
- On Windows: <Agent installation location>\ext\connectors\thirdparty\infa.denodo
- On Linux: <Agent installation location>/ext/connectors/thirdparty/infa.denodo
•Create a connection to the Denodo source system in Administrator.
•Assign the required permissions.
•Create endpoint catalog sources for connection assignment.
Verify permissions
To extract metadata and to configure other capabilities that a catalog source might include, you need account access and permissions on the source system. The permissions required might vary depending on the capability.
Permissions to extract metadata
To extract metadata, you need account access and permissions to the source system.
Verify that the administrator grants the following privileges to the user account on the Denodo database:
•Connect
•Metadata
•Write
Create a connection
Before you configure the Denodo catalog source, create a connection object in Administrator.
1In Administrator, select Connections.
2Click Add Connection and select Denodo.
3Enter the following connection details:
Property
Description
Connection Name
Name of the connection.
Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -,
Maximum length is 255 characters.
Description
Description of the connection. Maximum length is 4000 characters.
Use Secret Vault
Stores sensitive credentials for this connection in the secrets manager that is configured for your organization.
This property appears only if secrets manager is set up for your organization.
When you enable the secret vault in the connection, you can select which credentials that the Secure Agent retrieves from the secrets manager. If you don't enable this option, the credentials are stored in the repository or on a local Secure Agent, depending on how your organization is configured.
Note: If you’re using this connection to apply data access policies through pushdown or proxy services, you cannot use the Secret Vault configuration option.
The name of the runtime environment where you want to run tasks. Select a Secure Agent or serverless runtime environment.
Host
Host name or IP address of the machine that hosts the Denodo database.
Port
Network port number used to connect to the Denodo database. Default is 9999 for JDBC connections.
Database
The Denodo database name.
User Name
The user name to connect to the Denodo database.
Password
The password associated with the user name.
4Click Test.
5Click Save.
Create endpoint catalog sources for connection assignment
An endpoint catalog source represents a source system that the catalog source references. Before you perform connection assignment, create endpoint catalog sources and run the catalog source jobs.
You can then perform connection assignment to reference source systems and run connection-aware scans to view complete lineage with source system objects.