To configure a data source based on an Oracle database, complete the following steps.
- On the Navigation pane, expand Data Sources.
- Right-click a data source and select .
-
In the Add Data Source dialog box,
in the Configuration section, complete the
following substeps.
- In the Name field, type a name for the data source.
- In the Host field, type the server host name or IP address.
- In the Port field, type the TCP/IP port number for which the database is available. The value is typically 1521, which is the default setting.
- In the SID field, type the Oracle System ID for the data source.
-
(Optional) To test the data source configuration, in the Add
Data Source dialog box, in the Test Configuration section,
complete the following substeps.
- Click Save to create the data source with the current configuration.