Othot to TargetX Integration

Ensure you have a recently refreshed full or partial Salesforce sandbox for testing the integration.
Create the following new folders on your Informatica server in your existing Informatica directory:

Windows (i.e., C:\Informatica\):

Linux (i.e., /opt/informatica/):

Submit a TargetX Support case via the User Community and request Informatica assets be migrated to your org.
Access the Othot → TargetX Data Mapping worksheet and download as follows:
- Click ⠇
- Select Export
- Select the export file type (e.g., Export to Microsoft Excel)

Note: for Informatica resources, access the Informatica knowledgebase.

Once our support team migrates Informatica assets to your org, you can configure the following:

Connections	Configuration Steps
TargetX Integration-OTHOT SFTP	Update Target File Directory to path for downloaded Files folder Update PassKey1 (enter SFTP password if using username/password authentication; leave blank if using public/private key authentication)
TargetX Integration-OTHOT FlatFile	Update Directory to path for Othot dropbox folder

Data Synchronizations / Mappings / Mapping Tasks	Configuration Steps
Othot SFTP Get	Update Data Filter SFTP_User_ID with SFTP username If using public/private key authentication, add Data Filter SFTP_SSH2_KeyFile with key file path and remove Data Filter SFTP_Password
m_Othot_Prediction	Update lkp_AcademicPeriod Lookup Object Connection to Salesforce sandbox connection for testing Update Prediction Target Connection to Salesforce sandbox connection for testing
m_Othot_Prescription	Update Prescription Target Connection to Salesforce sandbox connection for testing
Othot Prescription Task	Update Post-Processing Command for Windows or Linux and update paths for downloaded Files and archive folders Windows: if not exist C:\Informatica\OTHOT\dropbox\downloadedFiles\archive\^"%date:~-4,4%%date:~-10,2%%date:~7,2%^" md C:\Informatica\OTHOT\dropbox\downloadedFiles\archive\^"%date:~-4,4%%date:~-10,2%%date:~7,2%^" && MOVE C:\Informatica\OTHOT\dropbox\downloadedFiles\.json C:\Informatica\OTHOT\dropbox\downloadedFiles\archive\^"%date:~-4,4%%date:~-10,2%%date:~7,2%^" Linux:* mkdir -p /opt/informatica/OTHOT/dropbox/downloadedFiles/archive/$(date +%Y%m%d) && mv /opt/informatica/OTHOT/dropbox/downloadedFiles/*.json /opt/informatica/OTHOT/dropbox/downloadedFiles/archive/$(date +%Y%m%d)/

Run Othot-TargetX Taskflow in Informatica.
- Confirm files are retrieved from the SFTP, data is loaded to your Salesforce sandbox, and files are archived.
- Resolve any errors that occur. If you receive an INVALID_CROSS_REFERENCE_KEY error, this indicates the Contact ID could not be found. If you're testing with a partial sandbox or Othot has received new contacts from your production org that do not exist in the sandbox, you can ignore the error. Review the error rows file from the task in Informatica to confirm. If necessary, re-run the taskflow in Informatica until all errors are resolved.
Validate the data in your Salesforce sandbox.
- If necessary, make changes to the Informatica mappings, then re-run the taskflow in Informatica and re-validate the data until all issues are resolved.

Othot will schedule delivery of prediction and prescriptions output files to your SFTP account. This step may be completed when Othot initially configures the export; otherwise, you can reach out to our support team or a member of your account team for assistance.
Update your mapping connections from Salesforce sandbox to Salesforce production.
Run taskflow in Informatica.
Confirm taskflow ran successfully without errors and validate data.
Schedule the Informatica taskflow to run daily based on the schedule of file delivery to the SFTP.