The driver includes a browser-based tool, Progress DataDirect Oracle Service Cloud Configuration Manager, that allows you to generate connection URLs, test connections, and execute test queries. This section will guide you through generating and testing a connection URL that can be used by your application.

To generate a connection URL:

  1. Open the Oracle Service Cloud Configuration Manager by double-clicking the driver jar file. Or, in a command line, navigate to the directory containing your driver jar file; then, execute the following command: 
    java -jar oracleservicecloud.jar

    The Oracle Service Cloud Configuration Manager opens in your default web browser.

  2. From the browser window, provide values of the connection properties you want to configure in the corresponding fields. A connection URL will generate in the Connection String field as you provide settings. To view more properties, select the tabs at the top of the page. See "Connection URL examples" for a list of required properties and properties used for different configurations.
    Note: If you do not specify a value for an optional property, the property will be omitted from the string and the default value will be used.
  3. Optionally, you can manually edit your string by clicking the Edit button ().
  4. At any point during the process, you can click Test Connect to attempt to connect to the service using the string generated in the Connection String field. In the Test Connection window:
    1. Provide values for any fields required by your service.
    2. Optionally, in the Test Query field, enter any SQL queries you want to execute during the test. For example: 
      SELECT * FROM TEST_SCHEMA.EXAMPLE_TABLES
    3. Click Execute.
      If successful, the window displays a confirmation message and, if a query was specified, the results of the query.
    Note: The information you enter in the logon dialog box during a test connect is not saved.
  5. To use your string, click the Copy button () and paste the string to a location that can be used by your application.