Skip to content

Latest commit

 

History

History
117 lines (85 loc) · 5.02 KB

interfaces.md

File metadata and controls

117 lines (85 loc) · 5.02 KB
copyright lastupdated keywords subcollection
years
2014, 2020, 2023
2023-06-09
Db2onCloud

{:external: target="_blank" .external} {:shortdesc: .shortdesc} {:codeblock: .codeblock} {:screen: .screen} {:tip: .tip} {:important: .important} {:note: .note} {:deprecated: .deprecated} {:pre: .pre}

Interfaces

{: #interfaces}

You can work with your database in the following ways: {: shortdesc}

  • From the web console
  • REST API
  • Connect applications or your favorite tools from your local computer
  • Use {{site.data.keyword.Db2_on_Cloud_short}} as a data source for your {{site.data.keyword.Bluemix_notm}} apps or services

Web console

{: #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. {: shortdesc}

You can access your web console in the following ways:

  • From your {{site.data.keyword.Bluemix_notm}} dashboard - You can open the web console from the Service Details page for your {{site.data.keyword.Db2_on_Cloud_short}} service.
  • Direct URL - You can bookmark the URL of the web console for your {{site.data.keyword.Db2_on_Cloud_short}} service.

REST API

{: #int_api}

With {{site.data.keyword.Db2_on_Cloud_short}} service plans, you can do tasks that are related to file management, loading data, and resource scaling by using one of the following REST APIs:

Connect applications or your favorite tools from your local computer

{: #connect_apps}

Configure your local environment to connect to your {{site.data.keyword.Db2_on_Cloud_short}} database by completing the following steps: {: shortdesc}

  1. Download the driver package from the {{site.data.keyword.Db2_on_Cloud_short}} web console.
  2. Install the driver package on the computer where your apps or tools are running:
  3. Configure the driver files for your {{site.data.keyword.Db2_on_Cloud_short}} database.

Use Db2 on Cloud as a data source for your {{site.data.keyword.Bluemix_notm}} apps or services

{: #data_src}

Apps that are hosted on {{site.data.keyword.Bluemix_notm}} can connect to your {{site.data.keyword.Db2_on_Cloud_short}} database the same way as your local applications connect to your {{site.data.keyword.Db2_on_Cloud_short}} database. {: shortdesc}

When your apps use the {{site.data.keyword.Bluemix_notm}} platform, you can take advantage of the VCAP _SERVICES environment variable to simplify the task of specifying database details and credentials:

  1. On your {{site.data.keyword.Bluemix_notm}} dashboard, in the Connections tab of the Service Details page for your {{site.data.keyword.Db2_on_Cloud_short}} service, click the Create connection button.

  2. Select the {{site.data.keyword.cloud_notm}} app to use with your {{site.data.keyword.Db2_on_Cloud_short}} 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, "", "" );
?>