If you want to connect to the updated versions of the service, you need to complete this by Sunday 14 May 2017. After this date, the existing version of the odbc-link service will be terminated.
odbc-link migration steps
- Note: If you are using an encryption algorithm other than SHA1 and AES256 as part of your existing connection to the odbc-link service, please contact your technology relationship manager before making any of the changes below.
- If you use outbound firewall rules, please allow the below IPs for the respective odbc-link environments you use.
| Environment | Elastic IP |
| LIVE | 34.250.205.217 |
| HEP1 | 34.249.133.191 |
| HEP2 | 34.248.86.109 |
- Once the IPs have been allowed, please update the TNS connection details your system uses to connect to UCAS.
Live odbc-link – TNS details
ODBCFE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = odbclinkprod.ucas.com)(PORT = 1524))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ODBCFE)
)
)
HEP1 test – TNS details
ODBCFE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =hep1odbcfe.ucasenvironments.com )(PORT = 1524))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ODBCFE)
)
)
HEP2 test – TNS details
ODBCFE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hep2odbcfe.ucasenvironments.com)(PORT = 1524))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ODBCFE)
)
)
Once successfully connected, please check you can send and receive data to the new version of odbc-link.
In addition to the above, details of the settings you should be connecting to for the UCAS live environment can be found in our Changes to UCAS link systems guide, and on the Environments information web page for the test environments.
If you have any queries, or you’re unsure what you need to do to make these changes, please contact your technology relationship manager.
If you experience any issues in setting up your connection to the new version of odbc-link, please raise an incident ticket via the UCAS ServiceNow portal, or contact the HEP Team on 0344 984 1111.