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