CA SSO Oracle Server Wire Protocol

Document ID : KB000032766
Last Modified Date : 14/02/2018
Show Technical Document Details

Summary

 When configuring an ODBC Data Source on a UNIX OS to connect to an Oracle ODBC Data Source, the 'oraclewire.ini' data source template is used to configure the  'system_odbc.ini' file.  The template files are located in  <Siteminder_home>/db. 

The 'oraclewire.ini' data source template is a basic template.  

Example:

[ODBC Data Sources]
SiteMinder Data Source=DataDirect 7.1 Oracle Wire Protocol

[SiteMinder Data Source]
Driver=/opt/CA/siteminder/odbc/lib/NSora27.so
Description=DataDirect 7.1 Oracle Wire Protocol
HostName=nete_servername
PortNumber=1521
ServiceName=nete_serverid
#SID=nete_serverid
CatalogOptions=0
ProcedureRetResults=0
EnableDescribeParam=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
DMCleanup=2
EnableTimestampWithTimeZone=1

 

The sample Data Source information includes the basic attributes necessary to establish a connection to the database.  Any additional features or settings supported by the ODBC server would require that the appropriate attribute be manually added to the Data Source.

Solution:

This is a list of all of the available Data Source attributes on the SQL Wire Protocol driver for Oracle ODBC.

Driver=C:\\Program Files (x86)\\CA\\siteminder\\bin\\NSORA27.DLL
ArraySize=60000
CatalogOptions=0
Description=
LockTimeOut=-1
LogonID=
ProcedureRetResults=0
HostName=
ServerName=
TNSNamesFile=
PortNumber=
SID=
ServiceName=
EnableStaticCursorsForLongData=0
CatalogIncludesSynonyms=1
UseCurrentSchema=1
ApplicationUsingThreads=1
EnableScrollableCursors=1
EnableDescribeParam=0
DefaultLongDataBuffLen=1024
LocalTimeZoneOffset=
EnableNcharSupport=0
EnableTimestampWithTimeZone=0
ReportRecycleBin=0
EnableServerResultCache=0
DescribeAtPrepare=0
CachedCursorLimit=32
CachedDescLimit=0
LoadBalancing=0
ConnectionRetryCount=0
ConnectionRetryDelay=3
AlternateServers=
ReportCodepageConversionErrors=0
TimestampEscapeMapping=0
ServerType=0
WireProtocolMode=2
GSSClient=native
AuthenticationMethod=1
EncryptionMethod=0
CryptoProtocolVersion=
TrustStore=
TrustStorePassword=
KeyStore=
KeyStorePassword=
KeyPassword=
HostNameInCertificate=
ValidateServerCertificate=1
InitializationString=
BulkLoadFieldDelimiter=
BulkLoadRecordDelimiter=
BulkBinaryThreshold=32
BulkCharacterThreshold=-1
BulkLoadOptions=0
EnableBulkLoad=0
BulkLoadBatchSize=1024
FetchTSWTZasTimestamp=0
EditionName=
LoginTimeout=15
QueryTimeout=0
FailoverMode=0
FailoverGranularity=0
FailoverPreconnect=0
Pooling=0
ConnectionReset=0
MaxPoolSize=100
MinPoolSize=0
LoadBalanceTimeout=0
AccountingInfo=
Action=
ApplicationName=
ClientHostName=
ClientID=
ClientUser=
Module=
ProgramID=
ExtendedOptions=
EncryptionTypes=
EncryptionLevel=0
DataIntegrityTypes=
DataIntegrityLevel=0
KeepAlive=0

NOTE: The attributes in the example (above) reflect the hardcoded, default values.  Adding the attribute and modifying the value will override the default value with the user-designated value.