WOLFRAM

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

"MicrosoftSQL" (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""MicrosoftSQL"
    "Location"SQL query given as a string
    "Redownload"whether to rerun the query and overwrite cached results
  • Required keys in assoc 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 a Microsoft SQL database include:
  • "query"SQL query given as a string

    • Supported Types

  • BITTrue or False
    BINARY, IMAGE, VARBINARYByteArray
    DATEDateObject with day granularity
    DATETIME, DATETIME2, SMALLDATETIMEDateObject with instant granularity
    DATETIMEOFFSETDateObject with instant granularity and time zone support
    DECIMAL, NUMERICReal with fixed precision
    BIGINT, INTEGER, SMALLINT, TINYINTInteger
    FLOAT, REALReal
    CHAR, NCHAR, NTEXT, NVARCHAR, TEXT, VARCHAR, XMLString
    TIMETimeObject

    • 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 a Microsoft SQL query:

    Retrieve the data using Import: