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 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 Microsoft Power BI XMLA.

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 daemon 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.