Perform the following steps to identify your data source within Data Catalog:
-
Click Management in the left toolbar.
The Manage Your Environment page opens.
-
In the Resources tile, click Add Data
Source.
The Create Data Source page opens.
- 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. - 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: Select Credentials,URI , or SSL as a configuration method. Configuration Method: Credentials - Username/Password: Credentials that provide access to the specified database.
- Host: The address of the machine where the Oracle database server is running. It can be an IP address or a domain name.
- Port: The port number on which the Oracle server is listening for incoming connections.
Configuration method: URI - Username/Password: Credentials that provide access to the specified database.
- Service URI: For example, URL would look like jdbc:oracle:thin:@oracle.example.com:1521/mydb.
Configuration method: SSL Select on of the following option, and enter the required encryption details. - Encryption only
- Encryption with Server and Client Authentication
Driver If you are selecting configuration method as Credentials or URI, then you must use the 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. 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.
-
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.
-
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.
- (Optional) Enter a Note for any information you need to share with others who might access this data source.
- Click Create Data Source to establish your data source connection.