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 = | 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.