Connecting to PolyData Using an Oracle Client or JDBC
Connecting to PolyData Using an Oracle Client
- Install an Oracle client on the workstation/server
- Configure the client to use the ITS TNS Name Service
- Reference the appropriate TNS service name when connecting to PolyData from your application (see table below)
| Description | Service Name |
|---|---|
| Production PolyData Data Warehouse | DWPRDDB |
| Test PolyData Data Warehouse | DWTSTDB |
Connecting to PolyData Using a Local TNSNAMES.ORA
- If you need to connect to PolyData using a local TNSNAMES.ORA file, please contact the ITS DBA Support team for assistance.
Connecting to PolyData Using JDBC
JDBC Connection Properties
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=dwXXXdb-dg1.db.calpoly.edu)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=dwXXXdb-dg2.db.calpoly.edu)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=dwXXXdb_APPLICATION_ADMINISTRATORS)(CONNECTION_PROPERTY_THIN_NET_ENCRYPTION_LEVEL=REQUIRED)(CONNECTION_PROPERTY_THIN_NET_ENCRYPTION_TYPES=AES256)))Note:
The HOST and SERVICE_NAME parameters that include dwXXXdb will need to be updated to reflect the desired connection environment (i.e. dwDEVdb, dwTSTdb, or dwPRDdb)