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: 107.20.231.49. 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

Diagnostic Questions:

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 107.20.231.49?
 

If the answer to the above is both "Yes", reconfigure the widget, choose the "Table" chart type, and try this query:
 
SELECT * FROM yourtablename LIMIT 10
 
(Obviously replace your table name above with the actual name)
 
 
If it's still not working, I would also suggest running the GRANT command on your SQL database to give our servers access to your database. It should be formatted like this:
 
GRANT SELECT ON db_name.* to 'username'@'107.20.231.49';
 
Just replace "db_name" with your database name and "username" with your username.
 
If it's *still* not working, email our friendly Support team for further assistance!
 

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!