Let's try Zoomdata (Big Data: 4)

In the previous digression (?), Even between different ** big data ** solutions, by using ** fusion ** to set key data, it is transparently treated as one data source. I introduced what you can do. Various ** big data ** solutions that will be scaled out in the right place and in the right amount will evolve further in the future, and at the same time, next-generation solutions equipped with new concepts and technologies will be released one after another. It may come. Taking full advantage of each advantage, ** Zoomdata ** itself has evolved as a platform for high-speed visualization analysis that can sustainably develop even in ** hybrid ** big data ** environments in many ways. Is continuing.

(1) Preparation of environment

Now, this time, I would like to change the taste a little and verify the connection with ** Zoomdata ** using ** Drill **. Actually, for this ** Drill ** connection environment, it is necessary to ** "post-insert" the modules **, so please contact ** Zoomdata ** first.

It's very easy to deploy. For example, when installing to ** CentOS **, use ** yum command ** with ** sudo ** based on the sent information, and after confirming that the installation was successful. , Introduced connector service

sudo systemctl enable xxxxxxxxx-xxx-xxxxxx (Here, xxxxxxxxx-xxx-xxxxxx is the name of the connector to be installed)

You can make it available in and finally reboot ** OS **.

If the installation is successful, you should see the ** Drill ** icon on the familiar ** Sources ** page.

By the way, next is the introduction of ** Sandbox ** that can use ** Drill **, but since ** MapR ** was published on the homepage. , I will use that environment. (The following is at the time of writing)

(1) Move to ** MapR ** company homepage (2) Select ** TRY MAPR ** at the top right of the screen (3) Select ** Download MapR ** (4) Select ** Download Sandbox with Drill ** (5) Fill in the required information for ** Get the sandbox ** on the left side of the screen. (6) Select ** Download **

The necessary information will be sent to the registered e-mail address, so you can download the target ** Sandbox ** accordingly.

After downloading, if you import it into the virtual environment and start it, if there are no problems, the console will start and the information necessary for use will be displayed. (This time, we will use the ** IP ** address used to set up the connection with ** Zoomdata **.)

(2) Zoom data settings

At this point, the basic procedure is the same as before, so we will proceed with connection verification quickly.

Enter ** Zoomdata ** with ** admin **, bring up the usual connector settings screen, then configure the required information and select ** Next **.

This time, I set ** Jdbc Url ** as follows.

jdbc:drill:drillbit=XXX.XXX.XXX.XXX

Then select ** Validate ** and wait for a while to list the available tables.

** logs ** seems to work, so select a table and go to ** Next **.

** Zoomdata ** For cooperation with the time axis that you are good at, we will proceed with the setting using ** date **, but since the notation seems to be slightly different, ** Custom introduced earlier ** Make the settings. This time, it matches the format of ** MM / dd / yyyy **.

After that, select ** Next ** quickly and go to ** Finish ** at once. If the registration is successful, the information will be stored and can be used from the user level.

(3) Connection verification and dashboard creation

The actual connection verification and the basic flow will be the same as the introduction so far, so I will omit the details, but I set a visualization chart for some data and set a visualization chart. As usual, I created ** "Nanchatte Dashboard" **.

Save this dashboard so that it can be reused in subsequent verifications.

I was able to save it quickly this time as well.

(4) Summary of this time

This time, I tried to verify big data linkage via an interface called ** Drill **. In addition to ** Drill **, several connection methods can be introduced later, so what is this kind of connection? Please do not hesitate to send the consultation to ** Zoomdata **. (The Japanese corporation has also started activities, so you can consult in Japanese.) Next time, I plan to explain how to link with ** SQL ** databases, which are generally used as existing data stores.

(5) Acknowledgments

Regarding the creation of this article, we used ** Sandbox ** published by ** MapR ** as the engine of the big data source. We would like to take this opportunity to thank you very much.