​@Josh_AFG - we accomplished this by creating a custom field, URL type, within Portfolios. We then mapped this within Hub to load the Jira URL data into that field.  Unfortunately, the native functionality of Hub communicating with Portfolios, forces additional efforts to be made to make this a clickable URL.  We had to have PV’s Hub team create a stored procedure & bat file that would copy the URL information and paste it into the Display Text field of that newly created custom field. The bat file is then used within the creation of a job stream in Portfolios which calls upon the stored procedure to perform the action. 

This means that we had to schedule our job stream to run periodically throughout the day. This is not the ideal long term solution and I have submitted an enhancement request (via a case in customer care) to improve this behavior.  The down side of this is that some job streams cannot run at the same time, therefore one fails. We had to careful time how often we run the “Update Jira URL” job stream as to not coincide with other intraday job streams. This means that the data is not updated when all other Jira data points are synced/updated. 

I have asked if this is truly the only way to accomplish this process and so far have been informed “yes”, unfortunately. 

Hope this helps,

Pam Sargent

Thank you ​@pamela.sargent  - Much appreciated.