graph-studio

Connecting to Oracle

The following properties can be specified when loading data from an Oracle 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.
Port - The network port number through which the storage system connects.
Database - The name of the database containing the data to be added.
Username - The user account used to authenticate access to the storage system.
Password - The password corresponding to the user account.

Oracle Options

Retain V 9 Long Bind Behavior
New Password
Auto Commit
Protocol
Stream Chunk Size
Set Float And Double Use Binary
Session Terminal
Session Machine
Session Os User
Session Program
Session Process
Session Iname
Session Ename
Profile
External Authentication
Authentication Services
Radius Challenge Response Handler
Kerberos 5 Mutual Authentication
Kerberos 5 Cc Name
Kerberos Realm
Kerberos JAAS Login Module
Set FIPS Mode
Debug JDWP
Allow Weak Crypto
Encryption Client
Encryption Types Client
Crypto Checksum Client
Crypto Checksum Types Client
Crypto Seed
Use JCE API
TCP No Delay
Read Timeout
OUTBOUND CONNECT TIMEOUT
CONNECT TIMEOUT
Disable Oob
Use Zero Copy IO
Use 1900 As Year For Time
Timestamp Tz In Gmt
Timezone As Region
SSL Certificate Alias
SSL Server Dn Match
SSL Server Cert Dn
SSL Allow Weak Dn Match
SSL Version
SSL Cipher Suites
SSL Key Store
SSL Key Store Type
SSL Key Store Password
SSL Trust Store
SSL Trust Store Type
SSL Trust Store Password
SSL Key Manager Factory Algorithm
SSL Trust Manager Factory Algorithm
Old Syntax
Com Sun Jndi Ldap Connect Timeout
Com Sun Jndi Ldap Read Timeout
Wallet Location
Wallet Password
Ldap SSL Sup Port Ed Ciphers
Ldap SSL Sup Port Ed Versions
Ldap SSL Key Store
Ldap SSL Key Store Type
Ldap SSL Key Store Password
Ldap SSL Key Manager Factory Algorithm
Ldap SSL Trust Store
Ldap SSL Trust Store Type
Ldap SSL Trust Store Password
Ldap SSL Trust Manager Factory Algorithm
Ldap SSL Wallet Location
Ldap SSL Wallet Password
Ldap Security Authentication
Ldap Security Principal
Ldap Security Credentials
Ldap SSL SSL Context Protocol
Proxy Client Name
Use Nio
Https Proxy Host
Https Proxy Port
Local Hostname
Connection Id Prefix
JDBC Driver Char Set Id
Edition Name
Internal Logon
Create Descriptor Use Current Schema For Schema Name
OCI Svc Ctx Handle
OCI Env Handle
OCI Err Handle
Prelim Auth
Default Execute Batch
Default Row Prefetch
Default Lob Prefetch Size
Enable Data In Locator
Enable Read Data In Locator
Remarks Reporting
Include Synonyms
Restrict Get Tables
Accumulate Batch Result
Use Fetch Size With Long Column
Process Escapes
Fixed String
Default N Char
Resource Manager Id
Disable Define Column Type
Convert Nchar Literals
Auto Commit Spec Compliant
JDBC Standard Behavior
J2EE 13 Compliant
DMS Name
DMS Type
DMS Statement Metrics
DMS Statement Caching Metrics
Map Date To Timestamp
Use Thread Local Buffer Cache
Driver Name Attribute
Max Cached Buffer Size
Implicit Statement Cache Size
Lob Stream Pos Standard Compliant
Strict ASCII Conversion
DRCP Connection Class
DRCP Tag Name
DRCP Connection Purity
Use DRCP Multipletag
DRCPPL SQL Callback
Thin Force DNS Load Balancing
Enable Temp Lob Ref Cnt
Keep Alive
SQL Translation Profile
SQL Error Translation File
Read Only Instance Allowed
Enable Result Set Cache
Enable Query Result Cache
Backward Compatibile Updateable Result Set
Allowed Logon Version
Commit Option
DOWN HOSTS TIMEOUT
Fan Enabled
Tns Admin
Network Compression
Network Compression Levels
Network Compression Threshold
Config File
Websocket User
Websocket Password
Socks Proxy Host
Socks Proxy Port
Socks Remote DNS
Default Connection Validation
Enable AC Sup Port
Enable TG Sup Port
Enable Implicit Requests
Enable SSS Cursor
DRCP Multiplexing In Request Apis
Continue Batch On Error
TCP KEEPIDLE
TCP KEEPINTERVAL
Use Sharding Driver Connection
TCP KEEPCOUNT
Replay Protected Request Size Limit
Ons Walletfile
Ons Wallet Password
Ons Protocol
Login Timeout
Inband Notification
SSL Context Protocol
Fetch Size Tuning
Use True Cache Driver Connection
Diagnostic Permit Sensitive Diagnostics
Diagnostic Enable Sensitive Diagnostics
Diagnostic Logger Name
Diagnostic Buffer Size
Diagnostic Enable Diagnose First Failure
Diagnostic Enable Logging
Diagnostic Enable Observability
Diagnostic Write Logs To Diagnose First Failure
Diagnostic Debug Tenant
Diagnostic Debug SQL
Token Authentication
Token Location
Password Authentication
Oci Iam Url
Oci Tenancy
Oci Compartment
Oci Database
Commit Select On Autocommit
Json Default Get Object Type
Access Token
Retain Lob Prefetch Data
Oci Config File
Oci Profile
Azure Database Application Id Uri
Tenant Id
Client Id
Client Secret
Client Certificate
Client Certificate Password
Redirect Uri
Enable Error Url
Parameter Metadata Preprocess
Parameter Metadata Cache Size
Parameter Metadata Cache Include Parsing
Remote Configuration Filtering
Send All Data For Value Lobs
Send Boolean In PL SQL
Database State Requirement
Allow Mixing JDBC And Named Binds
Allow Single Shard Transaction Sup Port
Provider Connection String
Provider Username
Provider Password
Provider Access Token
Provider TLS Configuration
Provider Trace Event Listener

Additional Options

Connection Properties

Property Name - The name of a connection property.
Property Value - The value of the connection property.

Encrypted Properties

Encrypted Property Name - The name of an encrypted property.
Encrypted Property Value - The value of the encrypted connection property.

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).

Source: https://docs.sw.siemens.com/documentation/external/PL20260212925461721/en-US/graph_studio/connect-oracle.htm · retrieved 2026-08-23