Mount Autonomous Database as Catalog

You will use an existing Autonomous Database to create a Database link and provide catalog name to mount it.

1. On the Catalog page, select Manage Catalog. Click +Add.

2. On the Add Catalog page, select Autonomous Database as Catalog Source.
   
   
   
   Description of the illustration catalog-source-adb.png
   
   
3. Select the Database name from the drop-down. For example, AA-TESTING.
4. You can view the following fields after you select the database name. Specify the following field values:
   
   
   
   Description of the illustration add-catalog-adb.png
   
   
   • Catalog Name: Enter the name of the catalog you want to mount the database link as. For example, AA-TESTING.
   • Database link name: Enter the name of the database link the tool creates using the existing database. For example, AA-TESTING_LINK.
   • Database credential: Select the credential from the drop-down which is required to create the database link. For example, AWSGLUE_CRED.

     Click Create Credential in case there is no existing credentials.

   • Under Show Advanced Options, select the Wallet Directory name from the drop-down. You need to have permission to access the directory. For example, WALLET_DIR-TESTING.
     Note
     
     The wallet file, along with the Database user ID and password provide access to data in the target Oracle Autonomous Database.
   • Click Test to test the creation of the Database Link.

   Click Create to create the autonomous database as Catalog.

After successful creation, you can view the Autonomous database listed under Manage Catalog.

Mount an existing Database Link as Catalog

You can instantiate a catalog schema as a local database user. If a database link has already been set up, you can mount a catalog over the linked database in order to search and discover data sets in that database.

You can add a database link to one of the databases and mount its metadata as a new catalog.

1. On the Catalog page, select Manage Catalog.
2. Click +Add.
3. On the Add Catalog page, select Database Link from Catalog Source.
   
   
   
   Description of the illustration catalog-source-dblink.png
   
   
4. Select the Database Link tab.
   
   
   
   Description of the illustration add-catalog-dblink.png
   
   
5. Select the Database Link name from the drop-down. For example, AA-TESTING_LINK.
6. Enter the name of the catalog in the Catalog name field. For example, AA-TESTING_LINK.
7. Click Create.

   You can view the newly mounted catalog in the Manage Catalogs dialog box.

   After you have successfully mounted a new catalog over a database connected using a Database link, you can select the catalog in Catalog Explorer and search for data in it.

Mount either Live Share or Delta Share Provider as Catalog

You can mount catalogs from registered data shares. This enables the consumers to access tables defined by other providers in other databases. The external tables need to be defined just once.

1. On the Catalog page, select Manage Catalog. Click +Add.
2. On the Add Catalog page, select Data Share from Catalog Source.
   
   
   
   Description of the illustration catalog-source-share.png
   
   
3. Click Next to progress to the Share provider settings tab.
   Under Share Source, select any of the available options:

   • Select from Live Share Providers
   • Delta Share Provider JSON

   In this example, you will select share source from Live Share Providers.

   Under Share Provider Details, specify the following details:

   • Provider Name: Enter the name of the share provider. For example, TEST-PROVIDER.
   • Description: Enter any description. This field is optional.
   
   
   
   Description of the illustration add-catalog-share-settings.png
   
   
4. Click Next to progress to the Select shares tab.
5. On the Share provider settings tab, drag and drop the share you want to mount as a catalog from the Available Shares to the Selected Shares.
6. Click Next to progress to the Catalog details tab. On the Catalog details tab, specify the following details:
   • Catalog name: Enter a catalog name of your choice.
   • Catalog description: Enter a description.
7. Select Create to mount a Live Share or Delta Share as a catalog.

After you have successfully mounted a new catalog over a Share, you can select the catalog in Catalog Explorer and search for data in it.

Mount Amazon Glue as Catalog

You can mount catalogs from registered AWS Glue data connections.

1. On the Catalog page, select Manage Catalog.
2. Click +Add.
3. On the Add Catalog page, select Amazon Glue from Catalog Source.
   
   
   
   Description of the illustration catalog-source-amazon-glue.png
   
   
4. Click Next to proceed to the Amazon Glue Catalog tab.
5. On the Amazon Glue Catalog tab, specify the following details:
   • Credential for Data Catalog Connection: Select a credential from the drop-down.
   • Region: Select a region from the drop-down.
6. Click Next to progress to the Catalog details tab. Specify the following field values on the Catalog details tab:
   • Catalog Name: Enter the name that you want to use in Data Studio to refer to the catalog.
   • Catalog Description: Enter a description of the catalog.
7. Click Create to mount the AWS Glue Data Catalog region as a catalog.

After you have successfully mounted a new catalog over an AWS Glue Data Catalog region, you can select the catalog in Catalog Explorer and search for data in it.

Mount OCI Data Catalog as Catalog

You can mount catalogs from a registered OCI Data Catalog.

1. On the Catalog page, select Manage Catalog. Click +Add.
2. On the Add Catalog page, select OCI Data Catalog from Catalog Source.
   
   
   
   Description of the illustration catalog-source-oci.png
   
   
3. Click Next to proceed to the OCI Data Catalog tab.
4. On the OCI Data Catalog tab, specify the following field values:

   • Credential for Data Catalog Connection: Select a credential from the drop-down. This field is mandatory. For example, BASICOCICRED.

   • Region: Select a region from the drop-down. This field is mandatory. For example, us-phoenix-1.

   • Data Catalog ID: Select a Data Catalog ID from the drop-down. A Data Catalog ID is the ID of the account to which the data catalog belongs. For example, catalog1.

     Select Use separate credential for Object Storage to use a different credential other than the selected one.

     
     
     
     Description of the illustration oci-data-catalog.png
     
     
5. Click Next to progress to the Catalog details tab.
6. On the Catalog details tab, specify the following field values:
   • Catalog Name: Enter the name that you want to use in Data Studio to refer to the catalog. For example, TEST_CATALOG.
   • Catalog Description: Enter a description of the catalog.
   
   
   
   Description of the illustration catalog-details.png
   
   
7. Click Create to mount the OCI Data Catalog as catalog.

After you have successfully mounted a new catalog over an OCI Data Catalog, you can select the catalog in Catalog Explorer and search for data in it.