# Oracle

Allows you to configure Oracle as a destination for Inforiver writeback. You can writeback to a specific instance of an Oracle database using the SID and Service name.

After navigating to the add destination page, enter the following details. 

* Server
* Service name
* SID
* Port
* Username
* Password
* Encrypted Connection (Y/N)
* Table Name

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FM4A7U29YIzbUwqCzFJUH%2Fimage.png?alt=media&#x26;token=62574de9-3840-416d-b437-7b41104b1c6f" alt=""><figcaption><p>Configuring an oracle destination</p></figcaption></figure>

#### Fetching the service name

Enter the service name or SID, which are optional fields. To retrieve the service name from the database, execute the following query

```
SELECT SYS_CONTEXT('userenv', 'service_name') AS service_name FROM dual 
```