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.
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.
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
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:
- the TimesTen database on the server,
- how the database is to be loaded,
- and how connections are to be managed.
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.
A Server DSN:
- must be defined as a system DSN.
- can be added or configured while the TimesTen Server is running.
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
- DI_TT_AGGR_STORE is the DSN name