Oracle DB Features
From DreamFactory
(Created page with "The SQL Anywhere service type can connect to local or remote SQL Anywhere servers. ==Common Feature Exceptions== * This service type currently is not supported on Windows OS...") |
m (Jason moved page DreamFactory/Features/Database/Oracle DB to DreamFactory/Features/Database/Oracle DB Features) |
||
| (6 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| − | The | + | The [[https://www.dreamfactory.com/hub/integrations/oracle/ Oracle]] service type can connect to local or remote Oracle Database servers. |
==Common Feature Exceptions== | ==Common Feature Exceptions== | ||
| − | |||
==Requirements== | ==Requirements== | ||
| − | Check [[DreamFactory/Installation/Databases/ | + | * PHP extension '''oci8''' is required to be installed or compiled in. Check [[DreamFactory/Installation/Databases/Oracle DB_Installation|here]] for installation help. |
| − | + | ||
| − | + | ||
==Configuration== | ==Configuration== | ||
* '''host''' - String. Required. The name of the database host, i.e. localhost, 192.168.1.1, etc. | * '''host''' - String. Required. The name of the database host, i.e. localhost, 192.168.1.1, etc. | ||
| − | * '''port''' - Integer. Optional. The number of the database host port, internally defaults to | + | * '''port''' - Integer. Optional. The number of the database host port, internally defaults to 1521. |
| − | * '''database''' - String. Required. The name of the database to connect to on the given server. This can be a lookup key. | + | * '''database''' - String. Required. The name of the database (aka SID) to connect to on the given server. This can be a lookup key. |
* '''username''' - String. Optional. The name of the database user. This can be a lookup key. | * '''username''' - String. Optional. The name of the database user. This can be a lookup key. | ||
* '''password''' - String. Optional. The password for the database user. This can be a lookup key. | * '''password''' - String. Optional. The password for the database user. This can be a lookup key. | ||
* '''default_schema_only''' - Boolean. Defaults to false. Do not include other schemas/databases on this server regardless of permissions given to the supplied credentials. | * '''default_schema_only''' - Boolean. Defaults to false. Do not include other schemas/databases on this server regardless of permissions given to the supplied credentials. | ||
| + | * '''tns''' - String. Optional. TNS full connection string which overrides all other host, port, etc. settings. | ||
| + | * '''protocol''' - String. Optional. Connection Protocol, internally defaults to TCP. | ||
| + | * '''charset''' - String. Optional. The character set to use for this connection, internally defaults to AL32UTF8. | ||
| + | * '''service_name''' - String. Optional. Optional service name if database (i.e. SID) is not set. | ||
* '''options''' - Object. Optional. A name-value array of driver-specific connection options. | * '''options''' - Object. Optional. A name-value array of driver-specific connection options. | ||
* '''attributes''' - Object. Optional. A key-value array of attributes to be set after connection. For further information, see http://php.net/manual/en/pdo.setattribute.php. | * '''attributes''' - Object. Optional. A key-value array of attributes to be set after connection. For further information, see http://php.net/manual/en/pdo.setattribute.php. | ||
* '''statements''' - Array of Strings. Optional. An array of additional SQL statements to run during connection initialization. | * '''statements''' - Array of Strings. Optional. An array of additional SQL statements to run during connection initialization. | ||
| + | |||
| + | ==FAQs== | ||
| + | If you want to change the default way Date is returned you can change it via adding it to Additional SQL Statements | ||
| + | * <code>ALTER SESSION SET NLS_DATE_FORMAT = ‘DD/MM/YYYY HH24:MI:SS’</code> | ||
Latest revision as of 06:33, 19 July 2022
The [Oracle] service type can connect to local or remote Oracle Database servers.
Common Feature Exceptions
Requirements
- PHP extension oci8 is required to be installed or compiled in. Check here for installation help.
Configuration
- host - String. Required. The name of the database host, i.e. localhost, 192.168.1.1, etc.
- port - Integer. Optional. The number of the database host port, internally defaults to 1521.
- database - String. Required. The name of the database (aka SID) to connect to on the given server. This can be a lookup key.
- username - String. Optional. The name of the database user. This can be a lookup key.
- password - String. Optional. The password for the database user. This can be a lookup key.
- default_schema_only - Boolean. Defaults to false. Do not include other schemas/databases on this server regardless of permissions given to the supplied credentials.
- tns - String. Optional. TNS full connection string which overrides all other host, port, etc. settings.
- protocol - String. Optional. Connection Protocol, internally defaults to TCP.
- charset - String. Optional. The character set to use for this connection, internally defaults to AL32UTF8.
- service_name - String. Optional. Optional service name if database (i.e. SID) is not set.
- options - Object. Optional. A name-value array of driver-specific connection options.
- attributes - Object. Optional. A key-value array of attributes to be set after connection. For further information, see http://php.net/manual/en/pdo.setattribute.php.
- statements - Array of Strings. Optional. An array of additional SQL statements to run during connection initialization.
FAQs
If you want to change the default way Date is returned you can change it via adding it to Additional SQL Statements
-
ALTER SESSION SET NLS_DATE_FORMAT = ‘DD/MM/YYYY HH24:MI:SS’
