ODS Cloud Instances Connection Details

Summary

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

 

 NOTE: Additional information about the ODS can be found here: Data Access and Reporting: ODS and SAS 

Additional Information

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

Solution Properties

Keywords
ods
Solution ID
250219125403120
Last Modified Date
05/13/2025 01:37:56 PM
Taxonomy
  • Business Technology > Reporting Center
Collections
  • VCU (Public)
  • Technology Services (Auth)
Views
0