Connect to Toad Intelligence Central from an External Application

[Trevor_Tubbs]

I have been attempting to connect to Toad Intelligence Central using MySQL Workbench as described in an article on Toad World. http://www.toadworld.com/products/toad-intelligence-central/b/weblog/archive/2014/01/21/custom-amp-3rd-party-applications-with-the-toad-business-intelligence-suite

I have not been successful. I am able to connect from Toad Data Point. This is the error I get:

I am using the same credentials, server name, and port as I am using from Toad Data Point. I am not using the default port because it was already in use on the server. The server is running Windows Server 2008 R2 Standard x64. My workstation is running Windows 8.1 Enterprise x64. The Toad Intelligence Central version is 2.6.0.18.

Any help in getting this to work would be greatly appreciated.

[Kieron]

By default, the MYSQL-based data interface for TIC is on port 3566; and port 8066 is a REST application server interface used by first-party clients (both of these ports can be changed during TIC installation). When connecting with a third-party client such as MySQL Workbench, use the data interface port instead.

You can check which port the data interface is using by accessing https://:8066/TICUtilitiesService/TICServerProxyPort in a web browser. However note that the application server uses a self-signed SSL certificate known to our first-party clients but not to web browsers, so you will have to temporarily ignore your browser’s security warning.