When you connect from an application, you use a Data Source Name (DSN) to uniquely identify the particular TimesTen database to which you want to connect.
A DSN is a character-string name that identifies a TimesTen database and a collection of connection attributes that are to be used when connecting to the database.
If a user tries to use a DSN that has connection attributes for which they do not have privileges, such as first connection attributes, they receive an error.
Even though the DSN uniquely identifies a TimesTen database, a database can be referenced by multiple DSNs. The difference between each of these unique DSNs is in the specification of the connection attributes to the database. This provides convenient names to different connection configurations for a single database.
The Client DSN defines the server machine and the Server DSN.
The Client DSN is configured in either the user or system ODBC.INI file.
Example of Client DSN on ORACLE_INSTANCE/instance1/bifoundation/OracleBIApplication/coreapplication/setup/odbc.ini
[ODBC Data Sources]
TT_AGGR_STORE = TimesTen 11.2.2 Driver
.....
[TT_AGGR_STORE]
Driver=/u01/app/oracle/product/TimesTen/tt1122/lib/libttclient.so
TTC_SERVER = Exalytics-01.hotitem.local
TTC_SERVER_DSN = TT_AGGR_STORE
TTC_TIMEOUT = 0
where:
The Server DSN is defined on the server machine where the database resides.
It is configured with the TimesTen database name and its connection attributes.
Server DSNs identify uniquely TimesTen databases that are accessed by:
The Server DSN specifies:
It has the same configuration format and attributes as a TimesTen Data Manager DSN. Some connection attributes are only allowed within the Server DSN specification. These attributes enable you to specify multiple client/server connections to a single server.
Server DSN attributes are defined in the ODBC.INI file or the ODBC Data Source Administrator.
A Server DSN:
Example of server DSN in the daemon_dir/sys.odbc.ini
[ODBC Data Sources]
DI_TT_AGGR_STORE=TimesTen 11.2.2 Driver
[DI_TT_AGGR_STORE]
Driver=/u01/app/oracle/product/TimesTen/tt1122/lib/libtten.so
DataStore=/u01/app/oracle/product/aggregate_store/tt_aggr_store/di_tt_aggr_store
LogDir=/u01/app/oracle/product/aggregate_store/logs
DatabaseCharacterSet=AL32UTF8
ConnectionCharacterSet=AL32UTF8
LogFileSize=1024
LogBufMB=1024
LogBufParallelism=16
Preallocate=0
PermSize=25000
TempSize=25000
MemoryLock=4
CkptFrequency=30
CkptLogVolume=0
CkptRate=20
PrivateCommands=1
RecoveryThreads=40
where: