The Oracle data source enables interaction with an Oracle database server. With this data source, app developers can access databases, execute queries and integrate data into their apps.
You can establish the connection using the connection parameters, such as host, and login information (user and password). You can then use SQL queries to retrieve, insert, update, or delete data.
Things to know
To specify the host parameter, you can use a connection string or the Easy Connect method.
The syntax for a connection string is:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=[host_name])(PORT=[port]))(CONNECT_DATA=(SID=[sid])))
The syntax for the Easy Connect method is:
[//]host_name[:port][/service_name][:server_type][/instance_name]
You can determine the service names by running the Oracle auxiliary tool lsnrctl status on the database server.
Parameters
|
Type |
Name |
Description |
|---|---|---|
|
TEXT |
host |
Specifies the server address of the Oracle server. Example: |
|
TEXT |
user |
Specifies the user to establish the connection. |
|
PASSWORD |
password |
Specifies the password of the specified user. |