IBM Cloud Docs
Interfaces

Interfaces

You can work with your warehouse database in the following ways:

  • From the web console
  • REST API
  • Connect applications or your favorite tools from your local computer
  • Use Db2 Warehouse on Cloud as a data source for your IBM Cloud apps or services

Web console

The web console provides a graphical interface for everything that you need to use your database, including: load facilities, an SQL editor, driver downloads, and more.

View of the web console dashboard page
Figure 1. View of the web console dashboard page

You can access your web console in the following ways:

  • From your IBM Cloud dashboard - You can open the web console from the Service Details page for your Db2 Warehouse on Cloud service.
  • Direct URL - You can bookmark the URL of the web console for your Db2 Warehouse on Cloud service.

REST API

With Db2 Warehouse on Cloud service plans, you can do tasks that are related to file management, loading data, and resource scaling using the database management REST API

Connect applications or your favorite tools from your local computer

Configure your local environment to connect to your Db2 Warehouse on Cloud database by completing the following steps:

  1. Download the driver package from the Db2 Warehouse on Cloud web console.
  2. Install the driver package on the computer where your apps or tools are running:
  3. Configure the driver files for your Db2 Warehouse on Cloud database.

Use Db2 Warehouse on Cloud as a data source for your IBM Cloud apps or services

Apps that are hosted on IBM Cloud can connect to your Db2 Warehouse on Cloud database the same way as your local applications connect to your Db2 Warehouse on Cloud database.

When your apps use the IBM Cloud platform, you can take advantage of the VCAP _SERVICES environment variable to simplify the task of specifying database details and credentials:

  1. On your IBM Cloud dashboard, in the Connections tab of the Service Details page for your Db2 Warehouse on Cloud service, click the Create connection button.

  2. Select the IBM Cloud app to use with your Db2 Warehouse on Cloud database as a data source, and then click the Connect button.

  3. Update your application code to retrieve database details and credentials from the VCAP_SERVICES environment variable:

    Example without VCAP_SERVICES

    <?php
    $driver      = "DRIVER={IBM DB2 ODBC DRIVER};";
    
    $database    = "BLUDB";         # Get these database details from
    $hostname    = "<Host-name>";   # the Connection info page of the
    $port        = 50001;           # web console.
    $user        = "<User-ID >";    #
    $password    = "<Password>";    #
    $dsn         = "DATABASE=$database;" .
                   "HOSTNAME=$hostname;" .
                   "PORT=$port;" .
                   "PROTOCOL=TCPIP;" .
                   "UID=$user;" .
                   "PWD=$password;";
    
    $conn_string = $driver . $dsn;
    
    $conn        = db2_connect( $conn_string, "", "" );
    ?>
    

    Example with VCAP_SERVICES

    <?php
    $driver      = "DRIVER={IBM DB2 ODBC DRIVER};";
    
    $vcap        = json_decode( getenv( "VCAP_SERVICES" ), true );
    $dsn         = $vcap[ "dashDB" ][0][ "credentials" ][ "dsn" ];
    
    $conn_string = $driver . $dsn;
                                   
    $conn        = db2_connect( $conn_string, "", "" );
    ?>