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 Veeva Vault.
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.