Terra Dotta - Study Abroad
Terra Dotta is a solution by a company of the same name used by the USU Office of Global Engagement to provide online study abroad applications, collect and track materials, and ensure eligibility. USU maintains Student User, Student Data, and HR User file extracts from the Banner Database which is transmitted to an SFTP folder hosted by Terra Dotta.
Technical Details
The file extracts are generated by a custom Banner package. Applicable term codes and variables are dynamically updating so no periodic update of parameters are necessary. Automation is handled through Applications Manager and the STFP transmissions are handled by batch scripts through Applications Manager as well.
Banner Custom Package:
BANINST1.z_terra_dotta_interface
Application Manager:
application - STUDENT
process flow - TERRA_DOTTA_INTERFACE (runs daily at 00:15)
SFTP_GET_TERRA_DOTTA (grabs the latest studyabroad_usu_edu_pool.txt)
PKG_WITHOUT_PARAMETERS (runs file extract generation)
SFTP_PUT_TERRA_DOTTA (uploads the three file extracts:
sis_user_info_core.txt
hr_user_info_core.txt
sis_user_info_custom.txt)
Documentation for the June 2016 integration can be found here: Terra Dotta - USU Accelerated Deliverable Schedule
Contacts
Functional Team:
Connie Radke-Kurian, International Students and Scholars, 435-797-7888, connie.rk@usu.edu
Amanda Castillo, Office of Global Engagement, 435-797-9220, amanda.castillo@usu.edu
Christopher Cameron, Office of Global Engagement, 435-797-0701, chris.cameron@usu.edu
Janis Boettinger, Vice Provost & Director for Global Engagement, 435-797-8176, janis.boettinger@usu.edu
IT:
Trevor Bennett, Enterprise Applications Administration, 435-797-0575, trevor.bennett@usu.edu
Ken Andersen, Systems Administration, ken.andersen@usu.edu
Duane Black, Database Administration, duane.black@usu.edu
Vendor (Terra Dotta):
Chelsey Harwood, Terra Dotta Support, cases@terradotta.com
last updated: 20210602