We would like to publish data from PI on-premises to Azure SQL Database through PI integrator for Business Analytics. When configuring the target, can we use TLS encryption and a custom port different from 1433?
The Azure SQL Database service is only available through TCP port 1433.
I think this might be doable by changing settings in the CAST.UI.WindowsService.exe.config, but it's definitely undocumented. I'd recommend to contact Techsupport.
E.g. this contains hints at extending the configuration: https://customers.osisoft.com/s/knowledgearticle?knowledgeArticleUrl=KB01958
Retrieving data ...