3.3 Accessing Data

Generally speaking, accessing raw databases requires that you first set up a SSH tunnel. On windows machines this normally requires that you use PuTTy.

Figure 3.2: PuTTY Guide

Below is some of the information that may be needed.

BANDEVL - rdbms.devl.banner.wfu.edu
BANDEVL_REPORT - rptdb.devl.banner.wfu.edu
BANPPRD - rdbms.pprd.banner.wfu.edu
BANPPRD_REPORT - rptdb.pprd.banner.wfu.edu
BANPROD - rdbms.banner.wfu.edu
BANPROD_REPORT - rptdb.banner.wfu.edu
BANTEST - rdbms.test.banner.wfu.edu
DW1DEVL - rdbms.devl.edw.wfu.edu
DW1PPRD - rdbms.pprd.edw.wfu.edu
DW1PROD - rdbms.edw.wfu.edu

It is also good to go ahead and get access to Cognos with report writer permissions in order to see some of these data.