Before you create a catalog source, ensure that you have the information required to connect to the source system.
Perform the following tasks:
•Verify that your Secure Agent is running on Microsoft Windows.
•Install the Oracle Cloud Object Storage software for Microsoft Windows on the same machine where you installed the Secure Agent.
•Verify authentication.
•Verify permissions.
•Get the database source information to connect to the source system.
•Use the Oracle connector and the OracleScanner package to connect to the Oracle source system in Administrator. For more information about configuring a connection in Administrator, see Connections in the Cloud Common Services help.
•If you're configuring a connection to an SSL-enabled Oracle database, specify appropriate values for the Trust Store and Key Store fields in the Oracle connection properties. The data profiling task for an SSL-enabled Oracle database may fail if either the Truststore or Keystore value is not specified in the connection properties.
•Optionally, if you want to identify pairs of similar columns and relationships between tables within a catalog source, import a relationship inference model.
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 for metadata extraction
To extract MicroStrategy metadata, you need account access and permissions to the MicroStrategy source system.
Verify that the administrator performs the following tasks:
•Creates a minimal Oracle Cloud Infrastructure Identity and Access Management policy.
•Defines users, groups, and one or more compartments to hold the cloud resources for your organization.
•Creates one or more policies, each written in the policy language.
•Places users into appropriate groups depending on the compartments and resources they need to work with.
•Provides the users with the one-time passwords that they need to access the console and work with the compartments.
Permissions to perform data classification
You can perform data classification with the permissions required to perform metadata extraction.
Permissions to perform relationship discovery
You can perform relationship discovery with the permissions required to perform metadata extraction.
Permissions to perform glossary association
You can perform glossary association with the permissions required to perform metadata extraction.
Verify authentication
To extract Oracle Cloud Object Storage metadata, you need to perform Simple or ConfigFile Authentication.
Simple Authentication is an API key-based authentication. You provide the authentication details in the Oracle Cloud Object Storage connection. You must place the private key file in the Secure Agent machine.
You need the following information to perform Simple Authentication:
•Tenancy
•User
•Fingerprint
•Private key location
Note: Place the private key in the runtime environment you use.
•Valid bucket name
•Region
Note: The region is populated by default.
ConfigFile authentication is based on the profile selected in a configuration file. For example:
By default, the Oracle Cloud Infrastructure CLI configuration file is located at ~/.oci/config. The ~/.oci/config file can contain multiple profiles. The default profile name is DEFAULT. You can change the default profile name to a new profile name based on the profiles that you add to the ~/.oci/config file. The ~/.oci/config file cannot contain two profiles with the same name.
You need the following information to perform ConfigFile Authentication:
•The configuration file location
Note: The file needs to contain user, tenancy, fingerprint, and the private key location present in the runtime environment.
•Valid bucket name
•Profile name marked in the configuration file
• Region
Note: The region is populated by default.
Get Oracle Cloud Object Storage source information
Before you configure the catalog source, ask the Oracle Cloud Object Storage administrator for values of connection properties that you need to configure the catalog source.
Note: You don't need to create a connection object for Oracle Cloud Object Storage. You provide this information when you configure the catalog source.
Import a relationship inference model
Import a relationship inference model if you want to configure the relationship discovery capability. You can either import a predefined relationship inference model, or import a model file from your local machine.
1In Metadata Command Center, click Explore on the navigation panel.
2Expand the menu and select Relationship Inference Model. The following image shows the Explore page with the Relationship Inference Model menu:
3Select one of the following options:
- Import Predefined Content. Imports a predefined relationship inference model called Column Similarity Model v1.0.
- Import. Imports the predefined relationship inference model from your local machine. Select this if you previously imported predefined content into your local machine and the inference model is stored on the machine.
To import a file, click Choose File in the Import Relationship Inference Model window and navigate to the model file on your local machine. You can also drag and drop the file.
The imported models appear in the list of relationship inference models on the Relationship Discovery tab.