Appendix: (4) support tool

Tool	Environment	attachment
postman	Salesforce (HSIDEV/QA)	collection: CRM(Salesforce)Testing.postman_collection.json
postman	Fairpass DB (QA)	collection: FairPass Online DB (QA).postman_collection.json
SQL	TCS DB (oracle)	CSIS-Parent-Initial.sql CSIS-Child-Initial.sql CSIS-Parent-Delta.sql CSIS-Child-Delta.sql CSIS-CaseStatus-Household-Delta-newviewquery.sql CSIS-ProcessLog.sql
	DB Tool	Oracle SQL Developer DEV & QA: user - hsiusr DEV: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST= dbdev.csd.toronto.ca)(PORT=1528))(CONNECT_DATA=(SERVICE_NAME=CSISDV))) QA: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST= dbqa.csd.toronto.ca)(PORT=1528))(CONNECT_DATA=(SERVICE_NAME= TCSLINKEXT)))
	SSHA-DB (MS SQL)	MS SQL Server Management Studio QA: MVSSHSQL01Q user: HSI_RO PROD: mvsshsql01p user: HSI_RO (for support only: HSI_READONLY)
Excel	User test (QA01) (need reset user/password)	Guide-Excel test data upload to CRM.docx RGI2CRM-v1.0-qa01.xlsm TCS-Children2CRM-v1.1-qa01.xlsm TCS-Household2CRM-v1.0-qa01.xlsm TCS-Parent2CRM-v1.2-qa01.xlsm OW2CRM-v1.0-qa01.xlsm
	User test (Dev05) (need reset user/password)	TCS-Children2CRM-v1.1-hsidev05.xlsm TCS-Household2CRM-v1.0-hsidev05.xlsm TCS-Parent2CRM-v1.2-hsidev05.xlsm OW2CRM-v1.0-hsidev05.xlsm RGI2CRM-v1.0-hsidev05.xlsm
Katalon	Fairpass online form	fairpass-ow.csv fairpass-rgi.csv fairpass-tcs.csv Fairpass Test Suite1.1.krecorder Usage please refer: HSI Fairpass online automation test -- plugin Katalon Recorder