Action required by odbc-link

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.

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