Installing ybtools on Windows

Make sure that Java 1.8 64-bit is installed on your client system. See Installing the Java Runtime Environment.
Note: Depending on how and where Java is installed, some Windows clients use the JAVA_HOME or JAVACMD environment variable to specify the Java virtual machine (JVM). If your Windows environment depends on these variables, use the .bat file versions of the ybtools commands instead of the .exe versions.

Follow these steps to install the client tools on a Windows client system:

  1. Download the Windows package from the SMC. Go to Configure > Drivers and Tools > Client Tools.
  2. If necessary, copy the downloaded package to the client system.
  3. As an Administrator user, double-click the downloaded file to start the installer (for example, ybtools-1.3.1.8788.windows.x86_64.exe).
    The Client Tools Setup Wizard starts up.
  4. Click through the Setup Wizard and respond to all of the prompts. Note the following options:
    You can select the tools to install:

    You can choose an installation directory:

    The default installation location is as follows:
    C:\Program Files\Yellowbrick Data\Client Tools
  5. Optionally, set the Path variable to point to the installation directory.
    1. Right-click the Start menu.
    2. Select System > Advanced System Settings > Environment Variables...
    3. Edit the Path variable and add the client tools location to the beginning of the string. In this example, the default location is added.


Run a simple ybsql command and check for the following WARNING message:
WARNING: Console code page (437) differs from Windows code page (1252)
         8-bit characters might not work correctly....
To change the console code page:
  1. Each time you open a new command line console, set the code page by entering (for example):
    chcp 1252
    at the command prompt, where 1252 is the Windows Latin 1 (ANSI) code page. Set the code page for your environment, as indicated by the warning message. If you are using Cygwin, you can put this chcp command in /etc/profile.
  2. Set the console font to Lucida Console; the raster font does not work with the ANSI code page.