Originally posted by: Balasubramanian G

Can we establish connectivity from ITX map to oracle database installed in different server via ODBC in ITXA/SPE environment in Linux OS without Oracle Client installed? If it is possible, what are the configurations required.

Thanks in advance for your help

Originally posted by: PaulBrett

As per my previous post:

https://www.ibm.com/developerworks/community/forums/html/topic?id=0edb8d0e-5ef6-4bd4-9dd2-e2a0acbdabc9&ps=25

...yes, you can.

Edit the odbc.ini file, taking a copy of the Oracle Wire Adapter line, and a copy of the Oracle Wire Adapter connection stanza, calling it your own unique name.  Example:

RemoteOracle=IBM Corporation 7.1 Oracle Wire Protocol

and

[RemoteOracle]
Driver=/nfshome/pbrett/linux64/wtx9.0.0.2/odbc_drivers/lib/T4ora27.so
Description=IBM Corporation 7.1 Oracle Wire Protocol
AlternateServers=
ApplicationUsingThreads=1
AccountingInfo=
Action=
ApplicationName=
ArraySize=60000
AuthenticationMethod=1
BulkBinaryThreshold=32
BulkCharacterThreshold=-1
BulkLoadBatchSize=1024
BulkLoadFieldDelimiter=
BulkLoadRecordDelimiter=
CachedCursorLimit=32
CachedDescLimit=0
CatalogIncludesSynonyms=1
CatalogOptions=0
ClientHostName=
ClientID=
ClientUser=
ConnectionReset=0
ConnectionRetryCount=0
ConnectionRetryDelay=3
DataIntegrityLevel=0
DataIntegrityTypes=MD5,SHA1
DefaultLongDataBuffLen=1024
DescribeAtPrepare=0
EditionName=
EnableBulkLoad=0
EnableDescribeParam=0
EnableNcharSupport=0
EnableScrollableCursors=1
EnableStaticCursorsForLongData=0
EnableTimestampWithTimeZone=0
EncryptionLevel=0
EncryptionMethod=0
EncryptionTypes=AES128,AES192,AES256,DES,3DES112,3DES168,RC4_40,RC4_56,RC4_128,RC4_256
FailoverGranularity=0
FailoverMode=0
FailoverPreconnect=0
FetchTSWTZasTimestamp=0
GSSClient=native
HostName=
HostNameInCertificate=
InitializationString=
KeyPassword=
KeyStore=
KeyStorePassword=
LoadBalanceTimeout=0
LoadBalancing=0
LocalTimeZoneOffset=
LockTimeOut=-1
LoginTimeout=15
LogonID=
MaxPoolSize=100
MinPoolSize=0
Module=
Password=
Pooling=0
PortNumber=
ProcedureRetResults=0
ProgramID=
QueryTimeout=0
ReportCodePageConversionErrors=0
ReportRecycleBin=0
ServerName=
ServerType=0
ServiceName=
SID=
TimestampeEscapeMapping=0
TNSNamesFile=
TrustStore=
TrustStorePassword=
UseCurrentSchema=1
ValidateServerCertificate=1
WireProtocolMode=2

As a minimum, you would have to provide entries for : HostName, PortNumber or ServerName/SID

Your map's database connection would then use the 'RemoteOracle' connection parameter

Thank you.

Paul

Follow me on Twitter