Connecting to my Zoho Reports Database via Google Appscript & JDBC

Connecting to my Zoho Reports Database via Google Appscript & JDBC

I'm wondering if this Google AppScript (below) can be used to connect to Zoho Reports via JDBC. I have successfully managed to connect to my database via the JDBC driver and DBVisualiser but haven't managed to adapt the script to work so far.

Are you able to provide any assistance please? Or can you advise another way to get my database info into google sheets?

Thanks, Stuart.

// Replace the variables in this block with real values.
var address = 'database_IP_address';
var user = 'user_name';
var userPwd = 'user_password';
var db = 'database_name';

var dbUrl = 'jdbc:mysql://' + address + '/' + db;

// Read up to 1000 rows of data from the table and log them.
function readFromTable() {
 
var conn = Jdbc.getConnection(dbUrl, user, userPwd);

 
var start = new Date();
 
var stmt = conn.createStatement();
  stmt
.setMaxRows(1000);
 
var results = stmt.executeQuery('SELECT * FROM entries');
 
var numCols = results.getMetaData().getColumnCount();

 
while (results.next()) {
   
var rowString = '';
   
for (var col = 0; col < numCols; col++) {
      rowString
+= results.getString(col + 1) + '\t';
   
}
   
Logger.log(rowString)
 
}

  results
.close();
  stmt
.close();

 
var end = new Date();
 
Logger.log('Time elapsed: %sms', end - start);
}