IAM Database Connection Information
Public connection entries for Middleware databases.
Note: Access to data in the following databases are available by express permission only. The databases are protected by network and application level firewalls and requires an approved IDI request that can be found here: IDI Request
Requesting Changes to Existing Connections: You can request a change via email to IAM Support. You will need to include:
- application name
- account it uses
- view or other objects it uses (so we can verify grants)
- IP address(es) or range(s) it will connect from (all addresses so that we can make sure that old authorizations are cleaned up.)
- For Windows Hosting IP ranges, we will need the user that IIS runs the site as.
PHEXPORT Production (PHEXPP)
PHEXPP = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = phexpp1.db.doit.wisc.edu)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = phexpp1_pdb_srv.doit.wisc.edu)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = phexpp2.db.doit.wisc.edu)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = phexpp2_pdb_srv.doit.wisc.edu)) ) )
IAA / UWPDR
IAA = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = iaa.db.doit.wisc.edu)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = iaa_pdb_srv.doit.wisc.edu)) ) UWPDR = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = iaa.db.doit.wisc.edu)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = iaa_pdb_srv.doit.wisc.edu)) )
PHEXPORT Test (PHEXPT)
PHEXPT = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = phexpt1.db.doit.wisc.edu)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = phexpt1_pdb_srv.doit.wisc.edu) ) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = phexpt2.db.doit.wisc.edu)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = phexpt2_pdb_srv.doit.wisc.edu) ) ) )
MSTTST
MSTTST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = msttst.db.doit.wisc.edu)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = msttst_pdb_srv.doit.wisc.edu)) )