Yellowbrick¶
To use the API of Yellowbrick to perform bulk data loads, first follow these steps:
Install the package “ybtools” (provided by Yellowbrick) on the host where the Virtual DataPort server runs. The documentation of Yellowbrick explains how to install ybtools.
The package “ybtools” requires Java 8 64-bit. Make sure the host where Virtual DataPort runs has Java 8 installed. If it is not, download it from the Oracle website. This package supports either a Java Runtime Environment (JRE) or a Java Development Kit (JDK).
If the environment variable
JAVA_HOME
does not exist or does not point to Java 1.8, modify the scriptybload
so this tool uses Java 8 as it requires:On Windows, the path to this script usually is
C:\Program Files\Yellowbrick Data\Client Tools\bin\ybload.bat
.On Linux, the path to this script usually is
/opt/ybtools/bin/ybload
.
Edit the JDBC data source and click the tab Read & Write. Then, select Use bulk data load APIs and enter the path to the file
ybload
:On Windows, enter
C:\Program Files\Yellowbrick Data\Client Tools\bin\ybload.bat
.On Linux, enter
/opt/ybtools/bin/ybload
.