This is an automated email from the ASF dual-hosted git repository.
dmagda pushed a commit to branch IGNITE-7595
in repository https://gitbox.apache.org/repos/asf/ignite.git
The following commit(s) were added to refs/heads/IGNITE-7595 by this push:
new 62aaf5d New Ignite Docs: ported and expanded the tools list
62aaf5d is described below
commit 62aaf5dcec1f63168840a25fe5c1dcb3617f9f7c
Author: Denis Magda <[email protected]>
AuthorDate: Thu Oct 1 21:46:23 2020 -0700
New Ignite Docs: ported and expanded the tools list
---
docs/_data/toc.yaml | 20 +-
docs/_docs/images/tools/gg-control-center.png | Bin 0 -> 251342 bytes
.../images/tools/informatica-import-tables.png | Bin 0 -> 54326 bytes
.../images/tools/informatica-rel-connection.png | Bin 0 -> 40510 bytes
.../images/tools/pentaho-ignite-connection.png | Bin 0 -> 77439 bytes
.../images/tools/pentaho-new-transformation.png | Bin 0 -> 81849 bytes
.../tools/pentaho-running-and-inspecting-data.png | Bin 0 -> 56310 bytes
docs/_docs/images/tools/tableau-choose_dsn_01.png | Bin 0 -> 12515 bytes
docs/_docs/images/tools/tableau-choose_dsn_02.png | Bin 0 -> 12860 bytes
.../images/tools/tableau-choosing_driver_01.png | Bin 0 -> 100372 bytes
.../images/tools/tableau-creating_dataset.png | Bin 0 -> 59092 bytes
.../_docs/images/tools/tableau-edit_connection.png | Bin 0 -> 7123 bytes
.../images/tools/tableau-visualizing_data.png | Bin 0 -> 86105 bytes
docs/_docs/images/tools/visor-cmd.png | Bin 0 -> 208235 bytes
docs/_docs/{ => tools}/control-script.adoc | 0
docs/_docs/tools/gg-control-center.adoc | 20 ++
docs/_docs/tools/informatica.adoc | 290 +++++++++++++++++++++
docs/_docs/tools/pentaho.adoc | 51 ++++
docs/_docs/{ => tools}/sqlline.adoc | 2 +-
docs/_docs/tools/tableau.adoc | 52 ++++
docs/_docs/tools/visor-cmd.adoc | 54 ++++
21 files changed, 484 insertions(+), 5 deletions(-)
diff --git a/docs/_data/toc.yaml b/docs/_data/toc.yaml
index 4e7e349..396e09e 100644
--- a/docs/_data/toc.yaml
+++ b/docs/_data/toc.yaml
@@ -367,10 +367,6 @@
url: SQL/ODBC/error-codes
- title: REST API
url: restapi
-- title: Control Script
- url: control-script
-- title: SQLLine
- url: sqlline
- title: Extensions and Integrations
items:
- title: Spring
@@ -473,6 +469,22 @@
url: cpp-specific/cpp-platform-interoperability
- title: Objects Lifetime
url: cpp-specific/cpp-objects-lifetime
+- title: Tools
+ items:
+ - title: Control Script
+ url: tools/control-script
+ - title: Visor CMD
+ url: tools/visor-cmd
+ - title: GridGain Control Center
+ url: tools/gg-control-center
+ - title: SQLLine
+ url: tools/sqlline
+ - title: Tableau
+ url: tools/tableau
+ - title: Informatica
+ url: tools/informatica
+ - title: Pentaho
+ url: tools/pentaho
- title: Plugins
url: plugins
- title: SQL Reference
diff --git a/docs/_docs/images/tools/gg-control-center.png
b/docs/_docs/images/tools/gg-control-center.png
new file mode 100644
index 0000000..d884adb
Binary files /dev/null and b/docs/_docs/images/tools/gg-control-center.png
differ
diff --git a/docs/_docs/images/tools/informatica-import-tables.png
b/docs/_docs/images/tools/informatica-import-tables.png
new file mode 100644
index 0000000..e1f4cfc
Binary files /dev/null and
b/docs/_docs/images/tools/informatica-import-tables.png differ
diff --git a/docs/_docs/images/tools/informatica-rel-connection.png
b/docs/_docs/images/tools/informatica-rel-connection.png
new file mode 100644
index 0000000..097a009
Binary files /dev/null and
b/docs/_docs/images/tools/informatica-rel-connection.png differ
diff --git a/docs/_docs/images/tools/pentaho-ignite-connection.png
b/docs/_docs/images/tools/pentaho-ignite-connection.png
new file mode 100644
index 0000000..1b15d6a
Binary files /dev/null and
b/docs/_docs/images/tools/pentaho-ignite-connection.png differ
diff --git a/docs/_docs/images/tools/pentaho-new-transformation.png
b/docs/_docs/images/tools/pentaho-new-transformation.png
new file mode 100644
index 0000000..58bbc4c
Binary files /dev/null and
b/docs/_docs/images/tools/pentaho-new-transformation.png differ
diff --git a/docs/_docs/images/tools/pentaho-running-and-inspecting-data.png
b/docs/_docs/images/tools/pentaho-running-and-inspecting-data.png
new file mode 100644
index 0000000..e138ef4
Binary files /dev/null and
b/docs/_docs/images/tools/pentaho-running-and-inspecting-data.png differ
diff --git a/docs/_docs/images/tools/tableau-choose_dsn_01.png
b/docs/_docs/images/tools/tableau-choose_dsn_01.png
new file mode 100644
index 0000000..5719d7a
Binary files /dev/null and b/docs/_docs/images/tools/tableau-choose_dsn_01.png
differ
diff --git a/docs/_docs/images/tools/tableau-choose_dsn_02.png
b/docs/_docs/images/tools/tableau-choose_dsn_02.png
new file mode 100644
index 0000000..95cfed4
Binary files /dev/null and b/docs/_docs/images/tools/tableau-choose_dsn_02.png
differ
diff --git a/docs/_docs/images/tools/tableau-choosing_driver_01.png
b/docs/_docs/images/tools/tableau-choosing_driver_01.png
new file mode 100644
index 0000000..03f9c9e
Binary files /dev/null and
b/docs/_docs/images/tools/tableau-choosing_driver_01.png differ
diff --git a/docs/_docs/images/tools/tableau-creating_dataset.png
b/docs/_docs/images/tools/tableau-creating_dataset.png
new file mode 100644
index 0000000..33dc98d
Binary files /dev/null and
b/docs/_docs/images/tools/tableau-creating_dataset.png differ
diff --git a/docs/_docs/images/tools/tableau-edit_connection.png
b/docs/_docs/images/tools/tableau-edit_connection.png
new file mode 100644
index 0000000..ec35e68
Binary files /dev/null and
b/docs/_docs/images/tools/tableau-edit_connection.png differ
diff --git a/docs/_docs/images/tools/tableau-visualizing_data.png
b/docs/_docs/images/tools/tableau-visualizing_data.png
new file mode 100644
index 0000000..e5351ed
Binary files /dev/null and
b/docs/_docs/images/tools/tableau-visualizing_data.png differ
diff --git a/docs/_docs/images/tools/visor-cmd.png
b/docs/_docs/images/tools/visor-cmd.png
new file mode 100644
index 0000000..55249eb
Binary files /dev/null and b/docs/_docs/images/tools/visor-cmd.png differ
diff --git a/docs/_docs/control-script.adoc
b/docs/_docs/tools/control-script.adoc
similarity index 100%
rename from docs/_docs/control-script.adoc
rename to docs/_docs/tools/control-script.adoc
diff --git a/docs/_docs/tools/gg-control-center.adoc
b/docs/_docs/tools/gg-control-center.adoc
new file mode 100644
index 0000000..33ddc3a
--- /dev/null
+++ b/docs/_docs/tools/gg-control-center.adoc
@@ -0,0 +1,20 @@
+= Using GridGain Control Center With Apache Ignite
+
+== Overview
+
+https://www.gridgain.com/products/software/control-center[GridGain Control
Center, window=_blank] is a management and
+monitoring tool designed for Apache Ignite that allows you to do the following:
+
+* Monitor the state of the cluster with customizable dashboards.
+* Define custom alerts to track and react on over 200 cluster, node, and
storage metrics.
+* Execute and optimize SQL queries as well as monitor already running commands.
+* Perform OpenCensus-based root cause analysis with visual debugging of API
calls as they execute on nodes across the cluster.
+* Take full, incremental, and continuous cluster backups to enable disaster
recovery in the event of data loss or corruption.
+* And more...
+
+image::images/tools/gg-control-center.png[GridGain Contro Center]
+
+== Installation and Usage
+
+Refer to the
https://www.gridgain.com/docs/control-center/latest/overview[official
documentation of GridGain Control Center, window=_blank]
+for detailed installation and usage instructions.
diff --git a/docs/_docs/tools/informatica.adoc
b/docs/_docs/tools/informatica.adoc
new file mode 100644
index 0000000..d97ba0d
--- /dev/null
+++ b/docs/_docs/tools/informatica.adoc
@@ -0,0 +1,290 @@
+= Using Informatica With Apache Ignite
+
+== Overview
+
+Informatica is a cloud data management and data integration tool. You can
connect Informatica to Ignite through the ODBC driver.
+
+== Connecting from Informatica PowerCenter Designer
+
+You need to install the 32-bit Ignite OBDC driver to connect an Ignite cluster
with the Power Center Designer. Use the
+following links to build and install the driver:
+
+* link:SQL/ODBC/odbc-driver#installing-on-windows[Install the driver on
Windows]
+* link:SQL/ODBC/connection-string-dsn#configuring-dsn[Configure DSN]
+
+Then do the following:
+
+. Select the `Sources` or `Targets` menu and choose `Import from Database...`
to import tables from Ignite.
+. Connect to the cluster by choosing `Apache Ignite DSN` as the ODBC data
source.
+
+image::images/tools/informatica-import-tables.png[Informatica Import Tables]
+
+== Installing Ignite ODBC on an Informatica Service Node
+
+Refer to the link:SQL/ODBC/odbc-driver#building-on-linux[Building on Linux] and
+link:SQL/ODBC/odbc-driver#installing-on-linux[Installing on Linux]
instructions to install the Ignite ODBC on an Ignite service node.
+
+Informatica uses configuration files referenced by the `$ODBCINI` and
`$ODBCISTINI` environment variables
+(https://kb.informatica.com/howto/6/Pages/19/499306.aspx[Configure the UNIX
environment for ODBC, window=_blank]). Configure
+the Ignite ODBC driver and create a new DSN as shown below:
+
+[tabs]
+--
+tab:odbc.ini[]
+[source,text]
+----
+[ApacheIgnite]
+Driver = /usr/local/lib/libignite-odbc.so
+Description = Apache Ignite ODBC
+Address = 192.168.0.105
+User = ignite
+Password = ignite
+Schema = PUBLIC
+----
+tab:odbcinst.ini[]
+[source,text]
+----
+[ApacheIgnite]
+Driver = /usr/local/lib/libignite-odbc.so
+----
+--
+
+To check the ODBC connection, use the `ssgodbc.linux64` utility included in
the Informatica deployment, as show below:
+
+[tabs]
+--
+tab:Shell[]
+[source,shell]
+----
+<INFORMATICA_HOME>/tools/debugtools/ssgodbc/linux64/ssgodbc.linux64 -d
ApacheIgnite -u ignite -p ignite -v
+----
+--
+
+If the unixODBC or Ignite ODBC libraries are not installed in the default
directory - `/usr/local/lib`, add them to `LD_LIBRARY_PATH`
+and then check the connection, like so:
+
+[tabs]
+--
+tab:Shell[]
+[source,shell]
+----
+UNIXODBC_LIB=/opt/unixodbc/lib/
+IGNITE_ODBC_LIB=/opt/igniteodbc/lib
+LD_LIBRARY_PATH=<UNIXODBC_LIB>:<IGNITE_ODBC_LIB>
+
+<INFORMATICA_HOME>/tools/debugtools/ssgodbc/linux64/ssgodbc.linux64 -d
ApacheIgnite -u ignite -p ignite -v
+----
+--
+
+== Configuring Relation Connection
+
+Choose `Connections > Relational..` to show the Relational Connection Browser.
+
+Select the ODBC type and create a new connection.
+
+image::images/tools/informatica-rel-connection.png[Informatica Relational
Connection]
+
+
+== Installing Ignite ODBC on Suse 11.4
+
+Follow the steps below to build and install Ignite with the Ignite ODBC driver
on Suse 11.4:
+
+. Add repositories - `oss`, `non-oss`, `openSUSE_Factory`, `devel_gcc`
++
+[tabs]
+--
+tab:Shell[]
+[source,shell]
+----
+sudo zypper ar http://download.opensuse.org/distribution/11.4/repo/oss/ oss
+sudo zypper ar http://download.opensuse.org/distribution/11.4/repo/non-oss/
non-oss
+sudo zypper ar
https://download.opensuse.org/repositories/devel:/tools:/building/openSUSE_Factory/
openSUSE_Factory
+sudo zypper ar http://download.opensuse.org/repositories/devel:/gcc/SLE-11/
devel_gcc
+----
+--
+
+. Install `automake` and `autoconf`
++
+[tabs]
+--
+tab:Shell[]
+[source,shell]
+----
+sudo zypper install autoconf automake
+----
+--
+
+. Install `libtool`
++
+[tabs]
+--
+tab:Shell[]
+[source,shell]
+----
+sudo zypper install libtool-2.4.6-7.1.x86_64
+
+Loading repository data...
+Reading installed packages...
+Resolving package dependencies...
+
+Problem: nothing provides m4 >= 1.4.16 needed by libtool-2.4.6-7.1.x86_64
+ Solution 1: do not install libtool-2.4.6-7.1.x86_64
+ Solution 2: break libtool-2.4.6-7.1.x86_64 by ignoring some of its
dependencies
+
+Choose from above solutions by number or cancel [1/2/c] (c): 2
+----
+--
+
+. Install OpenSSL
++
+[tabs]
+--
+tab:Shell[]
+[source,shell]
+----
+sudo zypper install openssl openssl-devel
+
+Loading repository data...
+Reading installed packages...
+'openssl-devel' not found in package names. Trying capabilities.
+Resolving package dependencies...
+
+Problem: libopenssl-devel-1.0.0c-17.1.x86_64 requires zlib-devel, but this
requirement cannot be provided
+ uninstallable providers: zlib-devel-1.2.5-8.1.i586[oss]
+ zlib-devel-1.2.5-8.1.x86_64[oss]
+ Solution 1: downgrade of zlib-1.2.7-0.12.3.x86_64 to zlib-1.2.5-8.1.x86_64
+ Solution 2: do not ask to install a solvable providing openssl-devel
+ Solution 3: do not ask to install a solvable providing openssl-devel
+ Solution 4: break libopenssl-devel-1.0.0c-17.1.x86_64 by ignoring some of its
dependencies
+
+Choose from above solutions by number or cancel [1/2/3/4/c] (c): 1
+----
+--
+
+. Install the GCC Compiler
++
+[tabs]
+--
+tab:Shell[]
+[source,shell]
+----
+sudo zypper install gcc5 gcc5-c++
+
+Loading repository data...
+Reading installed packages...
+Resolving package dependencies...
+2 Problems:
+Problem: gcc5-5.5.0+r253576-1.1.x86_64 requires libgcc_s1 >=
5.5.0+r253576-1.1, but this requirement cannot be provided
+Problem: gcc5-c++-5.5.0+r253576-1.1.x86_64 requires gcc5 = 5.5.0+r253576-1.1,
but this requirement cannot be provided
+
+Problem: gcc5-5.5.0+r253576-1.1.x86_64 requires libgcc_s1 >=
5.5.0+r253576-1.1, but this requirement cannot be provided
+ uninstallable providers: libgcc_s1-5.5.0+r253576-1.1.i586[devel_gcc]
+ libgcc_s1-5.5.0+r253576-1.1.x86_64[devel_gcc]
+ libgcc_s1-6.4.1+r251631-80.1.i586[devel_gcc]
+ libgcc_s1-6.4.1+r251631-80.1.x86_64[devel_gcc]
+ libgcc_s1-7.3.1+r258812-103.1.i586[devel_gcc]
+ libgcc_s1-7.3.1+r258812-103.1.x86_64[devel_gcc]
+ libgcc_s1-8.1.1+r260570-32.1.i586[devel_gcc]
+ libgcc_s1-8.1.1+r260570-32.1.x86_64[devel_gcc]
+ Solution 1: install libgcc_s1-8.1.1+r260570-32.1.x86_64 (with vendor change)
+ SUSE LINUX Products GmbH, Nuernberg, Germany -->
obs://build.opensuse.org/devel:gcc
+ Solution 2: do not install gcc5-5.5.0+r253576-1.1.x86_64
+ Solution 3: do not install gcc5-5.5.0+r253576-1.1.x86_64
+ Solution 4: break gcc5-5.5.0+r253576-1.1.x86_64 by ignoring some of its
dependencies
+
+Choose from above solutions by number or skip, retry or cancel [1/2/3/4/s/r/c]
(c): 1
+
+Problem: gcc5-c++-5.5.0+r253576-1.1.x86_64 requires gcc5 = 5.5.0+r253576-1.1,
but this requirement cannot be provided
+ uninstallable providers: gcc5-5.5.0+r253576-1.1.i586[devel_gcc]
+ gcc5-5.5.0+r253576-1.1.x86_64[devel_gcc]
+ Solution 1: install libgomp1-8.1.1+r260570-32.1.x86_64 (with vendor change)
+ SUSE LINUX Products GmbH, Nuernberg, Germany -->
obs://build.opensuse.org/devel:gcc
+ Solution 2: do not install gcc5-c++-5.5.0+r253576-1.1.x86_64
+ Solution 3: do not install gcc5-c++-5.5.0+r253576-1.1.x86_64
+ Solution 4: break gcc5-c++-5.5.0+r253576-1.1.x86_64 by ignoring some of its
dependencies
+
+Choose from above solutions by number or skip, retry or cancel [1/2/3/4/s/r/c]
(c): 1
+Resolving dependencies...
+Resolving package dependencies...
+
+Problem: gcc5-c++-5.5.0+r253576-1.1.x86_64 requires libstdc++6-devel-gcc5 =
5.5.0+r253576-1.1, but this requirement cannot be provided
+ uninstallable providers:
libstdc++6-devel-gcc5-5.5.0+r253576-1.1.i586[devel_gcc]
+ libstdc++6-devel-gcc5-5.5.0+r253576-1.1.x86_64[devel_gcc]
+ Solution 1: install libstdc++6-8.1.1+r260570-32.1.x86_64 (with vendor change)
+ SUSE LINUX Products GmbH, Nuernberg, Germany -->
obs://build.opensuse.org/devel:gcc
+ Solution 2: do not install gcc5-c++-5.5.0+r253576-1.1.x86_64
+ Solution 3: do not install gcc5-c++-5.5.0+r253576-1.1.x86_64
+ Solution 4: break gcc5-c++-5.5.0+r253576-1.1.x86_64 by ignoring some of its
dependencies
+
+Choose from above solutions by number or cancel [1/2/3/4/c] (c): 1
+----
+--
+
+. Provide symlinks to compiler executables.
++
+[tabs]
+--
+tab:Shell[]
+[source,shell]
+----
+sudo rm /usr/bin/gcc
+sudo rm /usr/bin/g++
+
+sudo ln -s /usr/bin/g++-5 /usr/bin/g++
+sudo ln -s /usr/bin/gcc-5 /usr/bin/gcc
+----
+--
+
+. Install unixODBC from sources. Download and install the latest
unixODBC(2.3.6 or later) library from http://www.unixodbc.org/.
+
+. Check that all required libraries and tools are installed with specified
versions.
++
+[tabs]
+--
+tab:Shell[]
+[source,shell]
+----
+1. libtool --version
+libtool (GNU libtool) 2.4.6
+2. m4 --version
+m4 (GNU M4) 1.4.12
+3. autoconf --version
+autoconf (GNU Autoconf) 2.69
+4. automake --version
+automake (GNU automake) 1.16.1
+5. openssl version
+OpenSSL 1.0.0c 2 Dec 2010
+6. g++ --version
+g++ (SUSE Linux) 5.5.0 20171010 [gcc-5-branch revision 253640]
+7. JDK 1.8
+----
+--
+
+. Check if the environment variable `JAVA_HOME` is set. Then issue the
following commands:
++
+[tabs]
+--
+tab:Shell[]
+[source,shell]
+----
+cd $IGNITE_HOME/platforms/cpp
+export LDFLAGS=-lrt
+
+libtoolize && aclocal && autoheader && automake --add-missing && autoreconf
+./configure --enable-odbc
+make
+sudo make install
+----
+--
+. Reboot the system.
+
+. Install the ODBC driver
++
+[tabs]
+--
+tab:Shell[]
+[source,shell]
+----
+sudo odbcinst -i -d -f
$IGNITE_HOME/platforms/cpp/odbc/install/ignite-odbc-install.ini
+----
+--
diff --git a/docs/_docs/tools/pentaho.adoc b/docs/_docs/tools/pentaho.adoc
new file mode 100644
index 0000000..ae5e5c9
--- /dev/null
+++ b/docs/_docs/tools/pentaho.adoc
@@ -0,0 +1,51 @@
+= Using Pentaho With Apache Ignite
+
+== Overview
+
+http://www.pentaho.com[Pentaho, window=_blank] is a comprehensive platform
that provides the ability to extract,
+transform, visualize, and analyze your data easily. Pentaho Data Integration
uses the Java Database Connectivity (JDBC)
+API in order to connect to your database.
+
+Apache Ignite is shipped with its own implementation of the JDBC driver which
makes it possible to connect to Ignite
+from the Pentaho platform and analyze the data stored in a distributed Ignite
cluster.
+
+== Installation and Configuration
+
+* Download and Install Pentaho platform. Refer to the official
https://help.pentaho.com/Documentation/7.1/Installation[Pentaho documentation,
window=_blank].
+* After Pentaho is successfully installed, you will need to install the Apache
Ignite JDBC Driver using the JDBC Distribution Tool.
+To do so, download Apache Ignite and locate
`{apache-ignite}/libs/ignite-core-{version}.jar` and copy the file to the
`{pentaho}/jdbc-distribution` directory.
+* Open a command line tool, navigate to the `{pentaho}/jdbc-distribution`
directory and run the following script `./distribute-files.sh
ignite-core-{version}.jar`
+
+== Ignite JDBC Driver Setup
+
+The next step is to set up the JDBC driver and connect to the cluster. Below
you will find the minimal number of actions
+that need to be taken. Refer to the link:SQL/JDBC/jdbc-driver[JDBC Thin
Driver] documentation for the more details.
+
+. Open your command line tool, go to the
`{pentaho}/design-tools/data-integration` directory and launch Pentaho Data
Integration using the `./spoon.sh` script.
+. Once the screen like the one below appears, click on the `File` menu option
and create a new transformation - `New -> Transformation`
++
+image::images/tools/pentaho-new-transformation.png[Pentaho New Transformation]
+
+. You can create a new Database Connection using setting the following
parameters in Pentaho:
++
+[opts="header"]
+|===
+|Pentaho Property Name | Value
+
+| Connection Name| Set some custom name such as `IgniteConnection`
+| Connection Type| Select the `Generic database` option.
+| Access| Select the `Native (JDBC)` option.
+| Custom Connection URL| `jdbc:ignite:thin://localhost:10800` or the real
address of a cluster node to connect to.
+| Custom Driver Class Name| `org.apache.ignite.IgniteJdbcThinDriver`
+|===
+
+. Click the `Test` button to check that the connection​ can be established:
++
+image::images/tools/pentaho-ignite-connection.png[Pentaho Ignite Connection]
+
+== Data Querying and Analysis
+
+Once the connection between Ignite and Pentaho is established , you can query,
transform, and analyze the data in a
+variety of ways supported by Pentaho. For more details, refer to the official
Pentaho documentation.
+
+image::images/tools/pentaho-running-and-inspecting-data.png[Pentaho Running
Queries]
diff --git a/docs/_docs/sqlline.adoc b/docs/_docs/tools/sqlline.adoc
similarity index 99%
rename from docs/_docs/sqlline.adoc
rename to docs/_docs/tools/sqlline.adoc
index 20489b5..9717919 100644
--- a/docs/_docs/sqlline.adoc
+++ b/docs/_docs/tools/sqlline.adoc
@@ -1,4 +1,4 @@
-= SQLLine
+= Using SQLLine With Apache Ignite
Command line tool for SQL connectivity.
diff --git a/docs/_docs/tools/tableau.adoc b/docs/_docs/tools/tableau.adoc
new file mode 100644
index 0000000..73b4132
--- /dev/null
+++ b/docs/_docs/tools/tableau.adoc
@@ -0,0 +1,52 @@
+= Using Tableau With Apache Ignite
+
+== Overview
+
+http://www.tableau.com[Tableau, window=_blank] is an interactive
data-visualization tool focused on business intelligence.
+It uses ODBC APIs to connect to a variety of databases and data platforms
allowing to analyze data stored there.
+
+You can use the link:SQL/ODBC/odbc-driver[Ignite ODBC driver] to interconnect
Ignite with Tableau and analyze the data stored
+in the cluster.
+
+== Installation and Configuration
+
+To connect to an Apache Ignite cluster from Tableau, you need to do the
following:
+
+* Download and install Tableau Desktop. Refer to an official Tableau
documentation located on http://www.tableau.com[the product's main website,
window=_blank].
+* Install the Apache Ignite ODBC driver on a Windows or Unix-based operating
system. The detailed instructions can be found on the
link:SQL/ODBC/odbc-driver[driver's configuration page].
+* Finalize the driver configuration by
link:SQL/ODBC/connection-string-dsn#configuring-dsn[setting up a DSN (Data
Source Name)].
+Tableau will connect to the DSN configured at this step.
+* The ODBC driver communicates to the Ignite cluster over a so-called `ODBC
processor`. Make sure that this component is
+enabled on the
link:SQL/ODBC/querying-modifying-data#configuring-the-cluster[cluster side].
+
+After all the above steps are accomplished, you can connect to the cluster and
analyze its data.
+
+== Connecting to Ignite Cluster
+
+. Launch Tableau application and find `Other Databases (ODBC)` setting located
under `Connect` \-> `To a Server` \-> `+More...+` window.
++
+image::images/tools/tableau-choosing_driver_01.png[Tableau Driver Selection]
+
+
+. Click on the `Edit connection` reference.
++
+image::images/tools/tableau-edit_connection.png[Tableau Edit Connection]
+
+. Set the `DSN` property to the name you configured before. In the example
below it's equal to `LocalApacheIgniteDSN`.
+Once this is done, click on the `Connect` button.
++
+image::images/tools/tableau-choose_dsn_01.png[Tableau Choose DSN]
+
+. Tableau will try to check the connection by opening a temporary one. If the
validation succeeds, the `Sign In` button
+as well as additional connection related fields will become active. Click on
`Sign In` to finalize the connection process.
++
+image::images/tools/tableau-choose_dsn_02.png[Tableau Choose DSN]
+
+== Data Querying and Analysis
+
+Once the connection is successfully established between Ignite and Tableau,
the data can be queried and analyzed in a
+variety of ways supported by Tableau. For more details, refer to the
http://www.tableau.com/learn/training[official Tableau documentation,
window=_blank].
+
+image::images/tools/tableau-creating_dataset.png[Tableau Creating DataSet]
+
+image::images/tools/tableau-visualizing_data.png[Tableau Visualizing Data]
diff --git a/docs/_docs/tools/visor-cmd.adoc b/docs/_docs/tools/visor-cmd.adoc
new file mode 100644
index 0000000..ffb3ffb
--- /dev/null
+++ b/docs/_docs/tools/visor-cmd.adoc
@@ -0,0 +1,54 @@
+= Visor CMD
+
+== Overview
+
+Visor Command Line Interface (CMD) is a command-line tool for Ignite clusters
monitoring. It provides basic statistics
+about cluster nodes, caches, and compute tasks. It also lets you manage the
size of your cluster by starting or stopping nodes.
+
+[NOTE]
+====
+[discrete]
+=== Ignite Control Script
+The link:tools/control-script[Control Script] is another command-line tool
developed by the Ignite community.
+It complements and expands capabilities of Visor CMD.
+====
+
+image::images/tools/visor-cmd.png[Visor CMD]
+
+== Usage
+
+Ignite ships the `IGNITE_HOME/bin/ignitevisorcmd.{sh|bat}` script that starts
Visor CMD. To connect Visor CMD to a cluster,
+use the `open` command.
+
+The following commands are supported by Visor. To get full information on a
command, type `help "cmd"` or `? "cmd"`.
+
+[cols="15%,15%,70%", opts="header"]
+|===
+|Command | Alias | Description
+
+| `ack`| | Acks arguments on all remote nodes.
+| `alert`| | Alerts for user-defined events.
+| `cache`| | Prints cache statistics, clears cache, prints list of all entries
from cache.
+| `close`| | Disconnects Visor CMD console from the cluster.
+| `config`| | Prints nodes' configurations.
+| `deploy`| | Copies file or folder to remote host.
+| `disco`| | Prints topology change log.
+| `events`| | Prints events from a node.
+| `gc`| | Runs GC on remote nodes.
+| `help`| `?`| Visor CMD's help.
+| `kill`| | Kills or restarts a node.
+| `log`| | Starts or stops the cluster-wide events logging.
+| `mclear`| | Clears Visor CMD's memory variables.
+| `mget`| | Gets Visor CMD' memory variables
+| `mlist`| | Prints Visor CMD's memory variables.
+| `node`| | Prints node's statistics.
+| `open`| | Connects Visor CMD to the cluster.
+| `ping`| | Pings a node.
+| `quit`| | Close Visor CMD's connection.
+| `start`| | Starts or restarts remote nodes.
+| `status`| `!`| Prints detailed Visor CMD's status.
+| `tasks`| | Prints tasks' execution statistics.
+| `top`| | Prints the current cluster topology.
+| `vvm`| | Opens VisualVM for nodes in the cluster.
+|===
+
