Configuring ECDA Option for Oracle

The following describes server creation for an Oracle target database for ECDA Option for Oracle.

StepsTo create a server for Oracle

  1. Start the Create Server wizard by entering:

    DCWizard.bat
    
  2. The Welcome Create Server Wizard window appears, Click Next.

    The Create DirectConnect Server Options window appears.

  3. Select the ECDA Option for Oracle option. Click Next.

    The Server Name and Port Information window appears.

  4. Enter the Server Name for the new DirectConnect server and the Port Number that you want the server to “listen” on. Click Next.

    The DirectConnect Server Admin Account and Password window appears.

  5. Enter the Admin Account Name. Click Next The Oracle Target Information window appears.

  6. Enter the following information:

    • Oracle Connect String

    • Path to the tnsnames.ora file including the file name

    Click Next. The Oracle DirectConnect Server Summary and Build window appears.

  7. Verify the ECDA Server information that appears.

    If correct select Create Server. The Oracle DirectConnect Server Summary and Build window appears.

    If incorrect, select the Back button to change the information.

  8. Verify the ECDA Config information that appears. If correct select Create Server. The Start DirectConnect Server (Optional) window appears. If incorrect, select the Back button to change the information.

  9. Optionally, start the DirectConnect server that you created. This is an optional step that can be used to validate the server configuration. If you exit from this wizard the DirectConnect server you have started will continue to execute. If you wish to skip this step Click Finish.

    NoteAdditional configuration changes can be added using DirectConnect Manager.