Analyzing your data

After loading your data into the data warehouse, you can analyze your data by using analytics software that is connected to the database.

Analyzing with Esri ArcGIS
You can use Esri ArcGIS for Desktop version 10.3.1 together with your warehouse to analyze and visualize geospatial data.
Analyzing with Python
You can run Python scripts that retrieve data from and write data to a Db2® database.
Analyzing with R
You can run R scripts that retrieve data from and write data to a Db2 database.
Analyzing with Spark
Db2 Warehouse includes an integrated Apache Spark cluster environment that is optimized for use with Db2 Warehouse. You can run Spark applications in this environment to analyze data contained in the database and to write results to the database.
Analyzing with SQL
You can run in-database analytic functions from within SQL that let you run analytics wherever the data resides within your warehouse. These analytic functions help you accelerate your application performance when you do analytical queries.
Analyzing spatial data
You can use special functions to generate and analyze data about geographic features, and to store and manage the data on which that information is based.
Analyzing with SPSS Statistics
You can use IBM® SPSS® Statistics together with your database to quickly view data, formulate hypotheses for additional testing, and carry out procedures to clarify relationships between variables, create clusters, identify trends, and make predictions.