Toad allows you to connect to OData services, a Business Intelligence data source, to view and query tables.
After creating a connection, see About Business Intelligence and NoSQL Data Sources for more information about this data source.
Note: This feature is available in the Toad Data Point Professional Edition only.
To create a generic OData connection
Enter the connection information in the Create New Connection dialog. Review the following for additional information:
|URL||Enter the full URL address for the Odata service to which you want to connect.|
|Username||If using an authentication method other than Anonymous, enter the user name to use when connecting.|
|Password||If using an authentication method other than Anonymous, enter the password to use when connecting.|
|Category||(Optional) Select an existing category or create a new one. |
Note: In NoSQL and Business Intelligence connections, Toad automatically saves the password in the connections.xml file as obfuscated text, as well as in Toad. To add additional password security, use Toad's Master Password feature.