JDBC Driver for Google Sheets

Build 20.0.7587

JDBC Remoting

The JDBC remoting feature allows you to connect to the JDBC driver from remote machines. The remoting feature is a daemon process that listens for database queries and responds to them. The driver supports the MySQL protocol and the TDS (SQL Server) protocol for remoting.

JDBC remoting will allow any MySQL or SQL Server client (ODBC drivers, programming languages like PHP, Perl, Python, tools like MySQL workbench, and many other applications) to easily connect to Google Spreadsheets.

Configuring the Driver for Remoting

Remoting can be configured through either a Command Line Interface or an INI-formatted configuration file.

Remoting via CLI

The MySQL and TDS daemons can be started directly from the command line. This can be accomplish by invoking the JAR and specifying the necessary CLI Options.

Remoting with a Configuration File

If you prefer not to provide every configuration property directly in the command line, a Configuration File can be defined, which will explicitly list all properties. Once defined, the daemon can be started with a single reference to this file in the CLI.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587