Connecting to Azure

The following properties can be specified when loading data from an Azure connection.

Not all properties listed here may be necessary when creating the data connection. However, at a minimum, basic information must be provided.

Basic Information

• Title - The name of the connection.

• Description - The description (optional) of the connection.

• Host - The IP address or host name of the storage system.

• Account ID - The Azure Storage account ID.

• Account Key - The Azure Storage account key.

• Storage Container - The top-level Azure Blob storage container.

Azure Options

• User Agent - The application or tool connecting to the Azure database.

• Header - The HTTP header key-value pair to include in requests made to the database service.

• Connect Timeout - The maximum time (e.g., in milliseconds) to wait to establish the connection before failing.

• Read Timeout - The maximum time allowed for reading data from the connection before timing out.

• Data Timeout - The maximum time (e.g., in milliseconds) to wait for a database to return query results or data after a connection has been established before failing.

• Session Timeout - The maximum time (e.g., in milliseconds) a session can last before failing.

• Max Total Connections - The maximum number of concurrent network connections allowed to a single host.

Proxy Options

• Proxy Type - The protocol used by the proxy server (e.g., HTTP, HTTPS, SOCKS, DIRECT).
• Proxy Host - The proxy server's network address or domain name.
• Proxy Port - The network port number through which the proxy server communicates.
• Proxy Username - The user account name required for proxy authentication.
• Proxy Password - The corresponding password used to authenticate the proxy user.

Advanced

Concurrency Control

• Maximum Allowed Concurrency - The overall limit on concurrent executions used to process the source.
• Number of Nodes - The number of nodes to use when processing the source.
• Executors per Node - The number of executors to use per node when processing the source.
• Maximum Request Rate - The maximum aggregate request rate against the source (e.g., 100 / s, 480 / minute).

Localization Settings

• Locale - The locale to use when parsing dates and numbers (e.g., ar-SA, en-US, ja-JP).
• Character Encoding - The default character encoding used by the connection (e.g., EBCDIC, UTF-8).
• Timezone - The timezone to use for dates and times that don't contain one (e.g., GMT+2, PST).

Data Formats

• Recognize only the configured formats - Specifies whether only those formats configured here should be recognized.
• DateTime Formats - How date and time values should be encoded (e.g., yyyy-MM-dd'T'HH:mm:ss, MM/dd/yyyy HH:mm, dd-MMM-yyyy HH:mm:ss).
• Date Formats - How calendar dates without time information should be encoded (e.g., yyyy-MM-dd, MM/dd/yyyy, dd-MMM-yyyy).
• Time Formats - How time-of-day values should be encoded (e.g., HH:mm:ss, hh:mm a, HH:mm:ss.SSS).
• Boolean Formats - How true/false or binary logical values should be encoded (e.g., true/false, 1/0, Y/N).
• Double Formats - How double-precision floating values should be encoded (e.g., ##,##0.00, $, %).
• Float Formats - How single-precision floating-point values should be encoded (e.g., ##,##0.00, %, e).
• Integer Formats - How whole numbers should be encoded (e.g., #, #,###,##0).
• Long Formats - How long integer values exceeding the range of standard integers should be encoded (e.g., #, #,###,##0).
• Month Formats - How standalone month values should be encoded (e.g., MM, MMMM).
• Year Month Formats - How combined month and year values should be encoded (e.g., yyyy MM, yyyy-MMM).
• Month Day Formats - How combined month/day values should be encoded (e.g., MM-dd, MMM dd, MM/dd)
• Year Formats - How standalone year values are encoded (e.g., yyyy, YY).