For general formatting tips, visit www.cyfe.com/sql-dashboard
Whitelisting IPs -- what IP(s) Do I Need to Whitelist for the SQL Widget to Work?
Just one: 220.127.116.11. If you are hosted on Amazon Web Services, the IP is different -- email our Support team for more info!
My SQL Widget Still Isn't Working
Is not it an Azure or Oracle DB? If it is either, see a workaround for these database types below.
Did you whitelist our IP of 18.104.22.168?
SELECT * FROM yourtablename LIMIT 10
(Obviously replace your table name above with the actual name)
Do You Connect Via SSH, VPN, or VPC?
Not at this time. Whitelist our IP above to your security groups and use general (generic, non-specific) queries for additional security.
How Do I Edit The Existing Cyfe Connection Details to my DB?
This is not possible at this time, but once the new account is added to Cyfe (in one widget), it is fairly easy to reconfigure the rest of the SQL widgets (i.e. simply have to click reconfigure, select new account, and save for each widget)! It usually takes just a few minutes.
Do You Support Azure or Oracle DBs? Postgres, NoSQL, Mondo, etc?
At the moment we don't support certain DBs like PostgreSQL natively, but it is on our roadmap! :)
In the meantime, you can get it to work via our Private URL widget.
Simply create a script on your server that outputs your data to match our examples at http://www.cyfe.com/sql-dashboard
Then connect it to the Cyfe widget. Here's an example of a script we use for demo purposes: http://www.cyfe.com/custom-example
And if you write the script well, you just have to write it once and can pass in the queries via a URL parameter like this:
http://www.yourcompany.com/script?query=SELECT * FROM users ORDER BY datereg ASC
(This is an example we use for people with Azure databases, which have had some compatibility issues -- one simply uses the Private URL to solve)
That way the same script can be used to run multiple queries!