Connecting to the Big SQL server

Big SQL queries are run by the Big SQL server on your cluster against data in your cluster. To run Big SQL queries, your environment must be associated with a Big SQL server that is part of the Big SQL service.

About this task

You can run Big SQL queries from Java SQL Shell (JSqsh), or from the IBM Data Server Manager. You can also run queries from a client application, such as IBM Data Studio, that uses JDBC or ODBC drivers. You must identify a running Big SQL server and configure either a JDBC or ODBC driver.

For more information about JSqsh, or IBM Data Studio, see the related topics in the Big SQL Knowledge Center.

Procedure

  1. Define the appropriate driver connections for the JSqsh environment, by connecting to the JDBC driver. . You can use any client application that uses a JDBC or ODBC driver. To download the Big SQL ODBC and JDBC drivers, see JDBC and ODBC drivers.
  2. Connecting to a Big SQL server.