|
Description |
Connection to an Oracle database |
|---|---|
|
Type |
oracle |
|
Category |
Db |
Configuration in States
The Oracle Db Store can be configured directly in the States interface via the Data Stores module. The following configuration modes are available:
Parameters
|
Name |
Description |
Mandatory |
Default |
Comment |
|---|---|---|---|---|
|
Host |
The hostname or IP address of the Oracle server |
Yes |
|
|
|
Port |
The port of the Oracle server |
Yes |
|
|
|
Database |
The name or service name of the target database |
Yes |
|
|
|
Username |
The username used to authenticate |
Yes |
— |
|
|
Password |
The password used to authenticate |
Yes |
— |
Value is hidden |
|
Suffix |
Additional parameters appended to the connection string |
No |
— |
|
Connection String
A connection string can be entered manually instead of using the parameter form. For the full list of supported connection string parameters, refer to the Oracle Data Provider for .NET documentation.
Local Configuration
The local configuration is defined in a JSON file (stores.json) deployed directly on the Workers' server. A locally configured store takes priority over a store with the same name configured in the States interface.
|
Name |
Description |
Type |
Mandatory |
Comment |
|---|---|---|---|---|
|
ConnectionString |
The connection string to connect to the database |
string |
True |
|
{
"Name": "propilot",
"Type": "oracle",
"HealthCheck": true,
"Config": {
"ConnectionString": ""
}
}