Direct SQL / Database Connectivity
One of our roadmapped connectors is “Direct SQL query”, where a user would configure it with the following information:
- Host
- Port
- Database username
- Database password
- Driver / Database (eg, mysql,oracle, postgres, etc)
- SQL query
A future iteration would be to add additional parameters to allow for SSH tunneling so that we could access databases that are not publically accessible by making a temporary SSH tunnel into a public server
- SSH host
- SSH port
- SSH username
- SSH password
** It would be helpful to know what databases we should support - so we can ensure we have the correct drivers. Please add a comment **