This workflow blends data between two different relational DBMS in KNIME Analytics Platform. It focuses on two common relational database systems, i.e. MS Access and H2. Why these two? Both are relatively easy to use, and used mainly in individual departments or small-to-medium business sectors.
The data is a standard baseball encyclopedia and it is available in text form, in .csv file, and in relational database format. Data are available at http://www.seanlahman.com/baseball-archive/statistics/.
BLOG: Will They blend? Experiments in Data & Tool Blending. Today: MS Access meets H2. Test your Baseball Knowledge. https://www.knime.org/blog/MSAccess_meets_H2
* Find more about the Examples Server here.
The link will open the workflow directly in KNIME Analytics Platform (requirements: Windows; KNIME Analytics Platform must be installed with the Installer version 3.2.0 or higher). In other cases, please use the link to a zip-archive or open the provided path manually