Solution Properties
Solution ID:
250219125403120
Last Modified Date:
Fri Feb 21 09:26:22 EST 2025
Taxonomy Path:
Business Technology//Reporting Center
Author:
olsengf
ODS Cloud Instances Connection Details
Environment

Ellucian Banner Operational Data Store (ODS)

Solution

To connect to the Ellucian Banner ODS (Operational Data Store), use the following connection instance details:

INSTANCE PURPOSE TNS NAMES STANZA JDBC STRING
ODSP Production ODS

ODSP =
(DESCRIPTION =
   (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(Host = odsdb-prod.ec.vcu.edu)(Port = 8000))
   )
      (CONNECT_DATA = (SID = ODSP))
)

 Jdbc_string: jdbc:oracle:thin:@odsdb-prod.ec.vcu.edu:8000:ODSP
ODST

TEST ODS

 ODST =
(DESCRIPTION =
   (ADDRESS_LIST =
       (ADDRESS=(PROTOCOL=TCP)(HOST=odsdb-dev.ec.vcu.edu) (PORT=8000))
    )
      (CONNECT_DATA=(SID=ODST))
 )		 Jdbc_string: jdbc:oracle:thin:@odsdb-dev.ec.vcu.edu8000:ODST
Additional Information

For additional assistance, submit a ticket via RamsCentral to Administrative & Business Resources / Administrative Technical / BI/Analytics and Reporting team.