Update connection string information for third-party tools (Alteryx, Tableau, PowerBI…)
‘Connection Info’ is required when connecting 3rd party tools such as Alteryx, Tableau, PowerBI, etc. to Cosmic Frog.
Anura version 2.7 makes use of Next-Gen database infrastructure. As a result, connection strings must be updated to maintain connectivity.
Severed connections will produce an error when connecting your 3rd party tool to Cosmic Frog.
Steps to restore connection:
- Copy the ‘HOST’ value from your Cosmic Frog Cloud Storage browser
- Update the Windows ODBC ‘Server’ value to your existing connection
- Update ‘Server’ value in your 3rd party tool’s data connection settings
- Re-run Cosmic Frog models to refresh output tables
Cosmic Frog ‘HOST’ value can be copied from Cloud Storage browser.