WOLFRAM

Wolfram Language & System Documentation Center
"Oracle" (Data Connection)

"Oracle" (Data Connection)

Details

Properties

  • DataConnectionObject[assoc] creates a reference to a data source. The source does not need to exist yet.
  • General keys typically found in assoc are:
  • "ConnectionName""Oracle"
    "Location"SQL query given as a string
    "Redownload"whether to rerun the query and overwrite cached results
  • Required keys in assoc for an Oracle connection are:
  • "DatabaseName"string giving the database to access
    "Host"the host servicing the database
  • Typical keys in assoc are:
  • "Port"the server port to access the database
  • Possible forms of "Location" when connecting to an Oracle database include:
  • "query"SQL query given as a string

    • Supported Types

  • BFILE, BLOB, RAWByteArray
    DATEDateObject with instant granularity
    TIMESTAMPDateObject with instant granularity and time zone support
    NUMBERReal with fixed precision
    INTEGERInteger
    BINARY_DOUBLE, BINARY_FLOAT, FLOATReal
    CHAR, CLOB, LONG, NCLOB, NVARCHAR, NVARCHAR2, ROWID, VARCHAR, VARCHAR2String

    • Account Setting & Authentication

  • Possible values for Authentication are:
  • Automaticattempt to use saved credentials or give a dialog
    "Dialog"give authentication parameters via a dialog
    SystemCredential["key"]retrieve authentication information from secure storage
    SystemCredentialData[…]stored authentication data
    assocprovide explicit credentials
  • Use the form Authentication:>SystemCredential["key"] to delay evaluating securely stored credentials.
  • The following keys are accepted by Authenticationassoc:
  • "Username"username
    "Password"password

    • Examples

    Basic Examples  (2)

    Create a DataConnectionObject to data from an Oracle query:

    Wolfram Language code: DataConnectionObject[<|"ConnectionName" -> "Oracle", "DatabaseName" -> "dbname", "Host" -> "my.host.com", "Location" -> "SELECT * FROM users"|>, Authentication -> <|"Username" -> "reader1", "Password" -> "reader1"|>]

    Retrieve the data using Import:

    Wolfram Language code: Import@DataConnectionObject[<|"ConnectionName" -> "Oracle", "DatabaseName" -> "dbname", "Host" -> "my.host.com", "Location" -> "SELECT * FROM table"|>, Authentication -> <|"Username" -> "user", "Password" -> "pass"|>]