Odata connector shows one of the following errors when trying to connect to localhost:
authenticated | error_message |
false | value for oDataServiceRoot 'localhost' is invalid |
Error validation oDataServiceRoot:Access to localhost is denied
In the deploy.config file AllowLocalHostAccess value is set to false by default.
Some web connectors may need Advanced configuration to access localhost, in order to fix this issue the deploy.config needs to be changed.
For allowing access to local host the highlighted tag needs to be changed as following
<ConnectorConfig>
<!-- Some connectors have connector specific configuration options which are managed here -->
<Connector>
<WebConnector>
<AllowLocalHostAccess>false</AllowLocalHostAccess>
</WebConnector>
<SugarCRMConnector>
<AllowLocalHostAccess>false</AllowLocalHostAccess>
</SugarCRMConnector>
<TextAnalyser_RepustateConnector>
<AllowLocalHostAccess>false</AllowLocalHostAccess>
</TextAnalyser_RepustateConnector>
<MongoDBConnector>
<AllowLocalHostAccess>false</AllowLocalHostAccess>
</MongoDBConnector>
<MSCRMConnector>
<AllowLocalHostAccess>false</AllowLocalHostAccess>
</MSCRMConnector>
<ODataConnector> <AllowLocalHostAccess>true</AllowLocalHostAccess> </ODataConnector> <JIRAConnector>
<AllowLocalHostAccess>false</AllowLocalHostAccess>
</JIRAConnector>
<NotificationConnector>
<AllowLocalHostAccess>false</AllowLocalHostAccess>
</NotificationConnector>
<MailboxIMAPConnector>
<AllowLocalHostAccess>false</AllowLocalHostAccess>
</MailboxIMAPConnector>
<MailboxPOP3Connector>
<AllowLocalHostAccess>false</AllowLocalHostAccess>
</MailboxPOP3Connector>
</Connector>
</ConnectorConfig>
Further information can be found in the following link:
https://help.qlik.com/en-US/connectors/Subsystems/Web_Connectors_help/Content/Connectors_QWC/Administer/Advanced-configuration.htm