Runtime Connection Information

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.


Feedback