Defining a datasource using a service name
You can define a datasource that enables your users to connect to an Oracle database by using the service name by using a custom URL.
You must enter the hostname, port, service name, and the custom URL.
About this task
- Determine the Oracle service name. You can use commands like these:
Use the name that appears in the VALUE column.
SQL> set line size 5000; SQL> select host_name, instance_name from v$instance; SQL> select name from v$database; SQL> show parameter service
- Load the appropriate Oracle JDBC thin driver to the Guardium® system.
- Download the driver for your Oracle database from the Oracle website.
- Open the Customer Uploads window by browsing to .
- Locate the section titled Upload Oracle JDBC driver. Click Browse and browse to the location to which you downloaded the file. Click Use open-source driver for all.
- Restart the Guardium user interface after the upload is complete.
- Define the datasource for this database.
- Browse to .
- The Application Selection menu lists all applications with which you can use a datasource definition. Choose the application for which the datasource you want to modify was created, and click Next, bringing you to the Datasource Finder.
- Enter the service name in the Service Name field. In the
custom URL field, enter
jdbc:oracle:thin@//hostname:port/svcnamewhere hostname and port are the standard values for the database and svcname is same value that you entered in the Service Name field.