Buy Percona ServicesBuy Now!

Export to JSON from MySQL All Ready for MongoDB

 | October 16, 2018 |  Posted In: Entry Level, MongoDB, MySQL, Tools

export-data-to-JSON-from-MySQL

This post walks through how to export data from MySQL® into JSON format, ready to ingest into MongoDB®. Starting from MySQL 5.7+, there is native support for JSON. MySQL provides functions that actually create JSON values, so I will be using these functions in this article to export to JSON from MySQL: JSON_OBJECT JSON_ARRAY These […]

Read More

Easy and Effective Way of Building External Dictionaries for ClickHouse with Pentaho Data Integration Tool

 | August 2, 2018 |  Posted In: MySQL, Open Source Databases

pentaho pdt with clickhouse

In this post, I provide an illustration of how to use Pentaho Data Integration (PDI) tool to set up external dictionaries in MySQL to support ClickHouse. Although I use MySQL in this example, you can use any PDI supported source. ClickHouse ClickHouse is an open-source column-oriented DBMS (columnar database management system) for online analytical processing. […]

Read More