The following parameters must be specified in the JSON configuration file or applied to the --connectionstring switch when using Foundation DBUtils with Oracle:
|
Parameter |
Description |
|---|---|
|
Data Source |
Enter the TNS name or connect descriptor of the database. |
|
User Id |
The user name of the database user account accessing the database. Note:
When using OS Authentication, a forward slash is used in place of the username. Note:
The User Id parameter is for the user account accessing the database, not an OnBase user account. |
|
Password |
The password of the database user account accessing the database. Note:
When using OS Authentication, a Password qualifier is not required. Note:
The Password parameter is for the user account accessing the database, not an OnBase user account. |
The following is an example of how parameters are specified when using the --connectionstring switch with a standard Oracle connection string:
--connectionstring "Data Source=TestDB;User Id=username; Password=password"Oracle OS Authentication connection string example:
--connectionstring "Data Source=TestDB;User Id=/"Oracle connect descriptor connection string example:
--connectionstring "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP) (HOST=hostname)(PORT=####))(CONNECT_DATA=(SERVICE_NAME=TestDB))); User Id=username;Password=password"For an example of how to set connection string information in a Foundation DBUtils JSON configuration file, see the Foundation DBUtils JSON Configuration File.