3.7 Spatial Studio Connections Page

The Connections page displays all the existing connections and also allows you to create a new connection.

The following figure shows a layout of the Connections page:

Figure 3-48 Connections Page

Description of "Figure 3-48 Connections Page"

You can perform the following actions on the Connections page:

• You can create a new connection, by clicking Create Connection.

  Figure 3-49 Create Connection

  
  Description of "Figure 3-49 Create Connection"

  As seen in the preceding figure, you can create a connection to the following sources:

  • Oracle Database: You must provide the host, port, schema, and other database authentication details.
  • Oracle Autonomous Database: You can connect to the Autonomous AI Database either with a cloud wallet or without one, depending on your chosen authentication method.
  • OGC Web Map Service: You must provide the URL to connect to the WMS service.

  When a new data source connection is created, GeoRaster will be automatically enabled if it was not already enabled in the database schema.

• You can also perform the following actions by clicking the hamburger icon against any displayed connection or by right-clicking a connection row:
  • Properties: To view the properties of the connection in the Overview tab.

    Also, for a cloud connection to an Autonomous AI Database instance, you can control the generation of vector tiles and H3 hexagons with the Use on-DB Vector Tile Generation and Use on-DB H3 Generation toggles in the Settings tab.

    Spatial Studio by default relies on the Autonomous AI Database server's built-in capabilities to generate the vector tiles and H3 hexagons. Therefore, you must typically keep these toggles ON. In rare situations, you may want to switch OFF these toggles in order to debug potential bugs introduced by a new Autonomous AI Database patch. When set to OFF, Spatial Studio generates vector tiles and H3 hexagons in the mid-tier instead of within the database server.

  • Edit: To update the connection details

    Note:

    You cannot edit the SPATIAL_STUDIO connection on the Connections page. Instead, refer to If the Spatial Studio Repository Schema Password Has Been Changed section.
  • Migrate: To migrate the connection from one environment to another.
  • Replace Cloud Wallet: To replace the cloud wallet for your Autonomous AI Database connection.
  • Test Connection: To validate the connection.
  • Delete: To delete the connection along with all its datasets.

    Note:

    You cannot delete the SPATIAL_STUDIO connection.

• Creating an Oracle Database Connection
  You can create a Spatial Studio connection to any Oracle Database schema.
• Creating a Connection to an Autonomous AI Database Instance
  You can create a Spatial Studio connection to an Autonomous AI Database instance.
• Creating an OGC WMS Connection
  You can create a new connection to an external OGC (Open Geospatial Consortium) WMS (Web Map Service) service.
• Migrating Database Connections
  You can migrate your connections in Spatial Studio between on-premises and cloud database environments.

3.7.1 Creating an Oracle Database Connection

You can create a Spatial Studio connection to any Oracle Database schema.

You can perform the following steps to setup a connection to the database:

1. Navigate to the Connections page.
2. Click Create Connection.
   The Create Connection dialog opens as shown in Figure 3-49.
3. Select Oracle Database as the connection type and click Next.

   The Create Connection dialog open as shown:

   Figure 3-50 Creating a Connection to the Oracle Database

   
   Description of "Figure 3-50 Creating a Connection to the Oracle Database"
4. Enter the Spatial Studio connection Name.
5. Optionally, enter a Description.
6. Select the database Connection type.
   The supported types are:

   • Service
   • SID
7. Enter the Service/SID value depending on your connection type.
8. Enter the database User name and the Password for the user.

   Note that when the database user password expires, Spatial Studio will prompt you to reestablish the schema connection. Then the Create Connection dialog is displayed with prefilled metadata schema details.

9. Enter the Host and Port details.
10. Click OK.
    The Oracle Database connection gets created. This database type connection is displayed on the Connections page.

3.7.2 Creating a Connection to an Autonomous AI Database Instance

You can create a Spatial Studio connection to an Autonomous AI Database instance.

1. Navigate to the Connections page.
2. Click Create Connection.
   The Create Connection dialog opens.
3. Select Oracle Autonomous Database as the connection type and click Next.

   The Select ADB authentication type dialog opens.

4. Select an authentication type as desired and click OK.

   Depending on your choice, perform one of the following to create a custom connection to your Autonomous AI Database instance:

   • Wallet-based: See Using a Wallet-Based mTLS Connection for more information.
   • Wallet-less (TLS): See Using a Walletless TLS Connection for more information.

• Using a Wallet-Based mTLS Connection
  You can create a Spatial Studio connection to an Autonomous AI Database instance using a wallet-based mutual Transport Layer Security (mTLS) authentication.
• Using a Walletless TLS Connection
  You can create a Spatial Studio connection to an Autonomous AI Database instance using a walletless Transport Layer Security (TLS) authentication.

3.7.2.1 Using a Wallet-Based mTLS Connection

You can create a Spatial Studio connection to an Autonomous AI Database instance using a wallet-based mutual Transport Layer Security (mTLS) authentication.

Before you begin, ensure you meet the following prerequisites:

• Download and save the wallet for your Autonomous AI Database instance from the Oracle Cloud Infrastructure (OCI) console. See Download Client Credentials (Wallets) for more information.
• The instructions in this section assume that you have already performed the steps described in Creating a Connection to an Autonomous AI Database Instance and you chose to create a Wallet-based connection.

You can then continue to perform the following steps to set up a cloud connection to your Autonomous AI Database instance using the downloaded wallet.

1. Drag and drop your saved wallet file or click to upload the wallet from your system in the Upload wallet dialog.
2. Click OK.
   The Create Connection dialog opens as shown:

   
   
   Description of the illustration wallet_based_conn.png
   

3. Optionally, change the default Spatial Studio connection Name.
4. Optionally, enter a Description.
5. Enter the Autonomous AI Database User name and the Password for the user.
6. Select the appropriate Service from the drop-down list.
7. Optionally, enter the Proxy Host and Proxy Port details.
8. Click OK.
   The connection to the Autonomous AI Database instance gets created and is displayed on the Connections page.

3.7.2.2 Using a Walletless TLS Connection

You can create a Spatial Studio connection to an Autonomous AI Database instance using a walletless Transport Layer Security (TLS) authentication.

Before you begin, ensure you meet the following prerequisites:

• Obtain the connection string for your Autonomous AI Database instance:
  1. Navigate to you Autonomous AI Database details page and locate the Network section.
  2. Specify an access control rule.
     1. Click Edit next to the Access Control List (ACL).
     2. Click Add access control and add the IP address of your client machine to configure an access control rule.
     3. Click Save.
  3. Disable Mutual TLS (mTLS) Authentication if it is not already disabled.
     1. Click Edit next to the Mutual TLS (mTLS) Authentication.
     2. Uncheck Require mutual TLS (mTLS) authentication.
     3. Click Save.
  4. Obtain the database connection string.
     1. Click Database Connection on the Autonomous AI Database details page.
     2. Select TLS under TLS Authentication to view the list of connection strings.
     3. Copy the required Connection String.

        The connection string follows a format as shown:

        (description=(retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=<host_name>.oraclecloud.com))(connect_data=(service_name=<service_name>.adb.oraclecloud.com))(security=(ssl_server_dn_match=yes))

• The instructions in this section assume that you have already performed the steps described in Creating a Connection to an Autonomous AI Database Instance and you chose to create a Wallet-less (TLS) connection.

You can then continue to perform the following steps to set up a cloud connection to your Autonomous AI Database instance in the Create Connection dialog.

Description of the illustration walletless_conn.png

1. Optionally, change the default Spatial Studio connection Name.
2. Optionally, enter a Description.
3. Enter the Connection string obtained at the beginning of the section.
4. Enter the Autonomous AI Database User name and the Password for the user.
5. Optionally, enter the Proxy Host and Proxy Port details.
6. Click OK.
   The connection to the Autonomous AI Database instance gets created and is displayed on the Connections page.

3.7.3 Creating an OGC WMS Connection

You can create a new connection to an external OGC (Open Geospatial Consortium) WMS (Web Map Service) service.

This enables you to create an OGC WMS dataset which can be used in map visualizations.

Note that a WMS service or server typically offers many individual map layers that can be combined in different orders. The full list of available map layers, as well as many other important supported functionalities are all advertised by the WMS server through a standard WMS GetCapabilities response.

When you create a new WMS connection, Spatial Studio will be querying such capabilities against the external WMS server using the standard GetCapabilities call. Based on the result of such a query, you will later be able to choose the required WMS map layers that must be included when creating a new Spatial Studio WMS dataset.

Prior to creating a WMS connection, if the Spatial Studio server is running behind a fire wall, then you must configure the Web Proxy using the General panel in the Console page. This is to enable Spatial Studio to access the WMS server (which can either be running on the same data center or remotely) from the server side.

You can perform the following steps to create an OGC WMS connection:

1. Navigate to the Connections page.
2. Click Create Connection.
   The Create Connection dialog opens as shown in Figure 3-49.
3. Select OGC Web Map Service as the connection type and click Next.

   The Create Connection dialog open as shown:

   Figure 3-51 Creating an OGC WMS Connection

   
   Description of "Figure 3-51 Creating an OGC WMS Connection"
4. Enter the connection Name.
5. Optionally, enter a Description.
6. Enter the WMS URL to connect to the WMS service.
   Also, note the following:

   • Ensure that the WMS URL is added to the Safe Domains list.
   • You can use one of the following two formats for the WMS URL:
     • A complete GetCapabilities request, including the version of the WMS specification (1.3.0 is recommended). For instance:

       https://nowcoast.noaa.gov/geoserver/observations/weather_radar/ows?SERVICE=WMS&VERSION=1.3.0&REQUEST=GetCapabilities

     • The base URL of the WMS server. For instance:

       https://nowcoast.noaa.gov/geoserver/observations/weather_radar/ows

7. Optionally, select the WMS VERSION.
8. Click OK.
   The OGC WMS connection gets created. This wms type connection is displayed on the Connections page.

   Also, the new WMS connection stores the names of all the available map layers (hosted by the WMS service) and a host of other information based on the GetCapabilities response as a part of its metadata.

9. Right-click on the newly created connection, select Test connection, and verify that the connection tests successfully.

3.7.4 Migrating Database Connections

You can migrate your connections in Spatial Studio between on-premises and cloud database environments.

It is possible that you may want to migrate data from your on-premises database to an Autonomous AI Database instance or the other way around. In such scenarios, you can also migrate the Spatial Studio connection related to the data to the new target data source. Thus, Spatial Studio allows you to continue working with the datasets that were created using the earlier connection properties, without rendering them invalid.

You can perform the following steps to migrate a database connection.

1. Navigate to the Connections page.
2. Right-click on the required connection Name.
   The context menu for the database connection appears as shown:

   Figure 3-52 Migrate Option for a Database Connection

   
   Description of "Figure 3-52 Migrate Option for a Database Connection"
3. Click Migrate.
   Migrate Database Connection is displayed as shown:

   Figure 3-53 Migrate Database Connection

   
   Description of "Figure 3-53 Migrate Database Connection"

   Note that in the preceding image, the target environment for migration may vary depending on the current source of the database connection. You can perform the following steps to configure the target environment that applies to you:

   • Migrating from On-Premises Database to Oracle Autonomous AI Database:
     1. Click Next and provide the Upload Wallet details.
     2. Click OK and provide the database connection details.
   • Migrating from Oracle Autonomous AI Database to On-Premises Database:
     1. Click Next and provide the database connection details.
     2. Click OK.
   The connection gets updated to the new data source.