XML-RPC Commandline

Exasol provides you with a command line interface that you can use for all the system administration tasks. You can also use this interface to automate some of the tasks.

This documents explains the basic setup requirements and how you can create a connection with an Exasol cluster through command line interface before you could start performing the administrative tasks.

Prerequisites

  • A running Exasol cluster that you can connect to.
  • Python 3 package

Setting Up

Do the following to set up the XML-RPC package:

  1. Run the following commands to import the XML-RPC packages:
    from xmlrpc.client import ServerProxy
    from xmlrpc.client import ServerProxy as xmlrpc
  2. Run the following command to create a connection with your Exasol cluster:
    import ssl
    server = ServerProxy ('https://user:password@<IP_Address>/cluster1', context=ssl._create_unverified_context (), allow_none = True)
  3. Run the following command to list all the XML-RPC methods:
    server.listMethods()

If you want to see the help for any of the methods, run the following command:
server.methodHelp ('<method name>')

The methods that you can use for the administrative tasks are described in EXAoperation XMLRPC API on GitHub