IBM logo

dashDB

Manage data with dashDB Support Tools

The IBM dashDB Support Tools (also referred to as the dbtoolkit) are a collection of scripts and utilities based on similar scripts delivered for the IBM PureData System for Analytics appliances and Netezza databases. The dbtoolkit can be used to migrate data from Netezza databases to dashDB, to connect to the dashDB database, and to run queries and reports on the migrated data.

Download the IBM dashDB Support Tools (~35MB)

By clicking the download link, you agree to these terms and conditions.

Download IBM dashDB Support Tools Refer to the readme inside the support tools package for more information about prerequisites, installation steps, and how to use the tools.

Utilities in the dbtoolkit package

dbsql
Connect to a dashDB database and run queries. This is based on an IBM Netezza command called nzsql

Scripts in the dbtoolkit package

db_ddl_database
Display the SQL DDL statement that was used to create a database

db_ddl_function
Display the SQL DDL statement that was used to create a user-defined function

db_ddl_procedure
Display the SQL DDL statement that was used to create a user-defined procedure

db_ddl_security
Display the SQL DDL statements that were used to create security objects

db_ddl_sequence
Display the SQL DDL statement that was used to create a sequence

db_ddl_synonym
Display the SQL DDL statement that was used to create a synonym (alias)

db_ddl_table
Display the SQL DDL statement that was used to create a table

db_ddl_view
Display the SQL DDL statement that was used to create a view

db_genstats
Generate statistics on those tables that don't have up-to-date statistics

db_getstats
Get and display the statistics for a user table or a system table

db_migrate
Copy one or more database tables from an IBM Netezza Platform Software (NPS) database to a dashDB database

db_size
Display the amount of storage space that is used by each table

db_tables
List all tables in a database, along with other useful pieces of information


Load

Move Data with IBM Bluemix Lift

Load data from the desktop into dashDB

Load data from the Cloud into dashDB

Move data to the Cloud with dashDB's MoveToCloud script

Load Twitter data into dashDB

Store Tweets Using Bluemix, Node-RED, Cloudant, and dashDB

Load XML data into dashDB

Load JSON Data from Cloudant into dashDB

Use DataStage to Load Data into dashDB

Integrate dashDB and Informatica Cloud

Bring Your Oracle and Netezza Apps to dashDB with Database Conversion Workbench (DCW)

Install IBM Database Conversion Workbench

Convert data from Oracle to dashDB

Convert IBM Puredata System for Analytics to dashDB

From Netezza to dashDB: It's That Easy!

> Manage data with dashDB Support Tools

Use Aginity Workbench for IBM dashDB

Load delimited data using the REST API and cURL