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-32.
3. Select Oracle Database as the connection type and click Next.

   The Create Connection dialog open as shown:

   Figure 3-33 Creating a Connection to the Oracle Database

   
   Description of "Figure 3-33 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.