Oracle DB

From DreamFactory
Jump to: navigation, search
(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...")
 
(Errors)
 
(3 intermediate revisions by 2 users not shown)
Line 1: Line 1:
The SQL Anywhere service type can connect to local or remote SQL Anywhere servers.
+
The Oracle service type can connect to local or remote Oracle Database servers.
  
 
==Common Feature Exceptions==
 
==Common Feature Exceptions==
* This service type currently is not supported on Windows OS installs.
 
  
 
==Requirements==
 
==Requirements==
Check [[DreamFactory/Installation/Databases/SQLAnywhere|here]] for installation help.
+
* PHP extension '''oci8''' is required to be installed or compiled in. Check [[DreamFactory/Installation/Databases/Oracle_DB|here]] for installation help.
 
+
* PHP extension '''pdo_dblib''' (and possibly '''mssql''' for PHP versions <7.0) are required to be installed or compiled in.
+
  
 
==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 1433.
+
* '''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 18:07, 19 December 2018

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’