The Optim Connect User Guide and Reference manual,
or OptimConnect_532_User_Guide_and_Reference.pdf file in the
Optim Connect\Documentation subdirectory of the Optim™ installation directory, specifies the
format and contents of the connection strings for ODBC and JDBC.
An Archive File or Archive File Collection
specified in the connection string overrides the corresponding specification
in the ODM Optim Connect data source definition. If an Archive File
or Archive File Collection is not identified in the data source, you
must specify an Archive File or Archive File Collection in the connection
string.
Connection Parameters
The following are special connection parameters that
can be used when connecting to an ODM Optim Connect data source from
ODBC or JDBC:
DSNCONFIG=datasourcename1( [ ARCV_FILE=archivefilename |
ARCV_GUID=guid | ARCV_ID=n
| COLLECTION=archivefilecollection ] ,
[ PST_AF_SUBSET={ ‘AF_IN(n,n,...)' |
‘AF_DATE_RANGE
(yyyy-mm-dd-hh:mm:ss,yyyy-mm-dd-hh:mm:ss)' |
‘AF_ID_RANGE(x,y)' } ]
[ PSTTRACE=COMP (n n ...) [ COMP (n n ...) ] ] )
& datasourcename2(...)
DSNPASSWORDS=datasourcename=domainname/userID/
password & datasourcename2=...
QPTDPNAME=primaryservername:daemonportnumber
Note: For additional connection parameters, refer to Attunity
documentation.
- DSNCONFIG= datasourcename
- The ODM data source name.
- ARCV_FILE= archivefilename
- The fully qualified Archive File name.
- ARCV_GUID= guid
- The Archive File GUID.
- ARCV_ID=n
- The Archive File ID number.
- COLLECTION= archivefilecollection
- The Archive File Collection name.
- PST_AF_SUBSET= ‘AF_IN' | ‘AF_DATE_RANGE'
| ‘AF_ID_RANGE'
- Subsets an Archive File Collection to specific
Archive Files. Use one of the following parameters:
- ‘AF_IN(n,n,...)'
- Archive Files to include, where n is an
Archive File name, GUID, or Archive File ID. If a specified Archive
File cannot be found, the process will fail.
- ‘AF_DATE_RANGE (yyyy-mm-dd-hh:mm:ss, yyyy-mm-dd-hh:mm:ss)'
- A range of Archive File creation dates. You must
include the time of day (hh:mm:ss). You can use zeros to specify the
time (e.g., 00:00:00).
- ‘AF_ID_RANGE (x,y)'
- A range of Archive File IDs, where x is
the start and y is the end.
- PSTTRACE= COMP (n n ...)
- An optional attribute for turning on the Optim Trace file. This attribute
should be used at the direction of Optim support.
Do not use commas in the PSTTRACE attribute.
- DSNPASSWORDS= datasourcename= domainname/
userID/ password
- The user ID and password for Archive File Security
authentication. The datasourcename is the data source to which
the credentials apply. The domainname is optional. You can
use forward or backward slashes within the parameter. If this parameter
is not used, the credentials of the user running the Attunity Server
will be used for Archive File Security authentication.
- QPTDPNAME= primaryservername: daemonportnumber
- The primary server name and port number of the
Attunity daemon on the primary server. Required when the connection
string is passed from a secondary server.