JackDB – Direct SQL access
While I was evaluating an AWS Redshift lab on qwikLABS, the lab directed me to connect to Redshift cluster by using JackDB which is a hosted service that can be used as a secure client software to connect to cluster in order to run queries . Thus, you are able to query your database by using a 3rd party client software.
If you are seeking a service like JackDB, all of the plans come with 14-days free trial.
Before adding a data source to JackDB dashboard, make sure that you have already configured the AWS security group which allows the incoming connection that is initiated from JackDB IP’s.
In addition to this, you can undoubtedly use it to connect to Azure SQL service as well. I have added a data source which is hosted on Azure SQL.
Data source connection configuration settings are depicted as shown above. After adding the data source, you are able to run queries against you database. Few screenshots are exhibited below.
Notice: The database displayed below contains sample data which comes with Azure SQL, a sample database.
I am not a DB expert actually but I like the way that what the hosted service does. Furthermore, it supports wide range of database from AWS Redshift or MariaDB to HP Vertica or Azure SQL and much more.
I hope you have a great day.