How-tos

Provision dashDB for Analytics and Transactions SQL database for your move to the cloud

Share this post:

dashDB HeroIt’s easy to provision IBM dashDB for Transactions and IBM dashDB for Analytics cloud offerings directly from Bluemix now. DashDB for Transactions SQL Database provides a dedicated, fully managed, OLTP-optimized solution that offers both DB2 and Oracle compatible options. Alternatively, harness the power of dashDB for Analytics with in-memory processing, RStudio and Cloudant integrations, in-database analytics, and much more.

Provision dashDB directly from Bluemix

PayGo provisioning is available for both of these offerings. You can purchase them directly from Bluemix by using your Bluemix subscription or a credit card. Choose the options that you want, click “Create,” and your system will soon be available on the Bluemix dashboard. It’s that easy.

Move data to the cloud using Bluemix Lift

You can use Bluemix Lift to move your on-premises data store to a dashDB for Analytics instance quicker and easier than you might have thought possible. Bluemix Lift leverages IBM Aspera to transport data in a highly efficient and secure way, achieving up to 10 times better performance than traditional data transfer methods.

Automate dashDB Provisioning

If you’re a re-seller or you just want to automate the provisioning of a new dashDB service instance, make sure that you take a look at the Bluemix command line or the Cloud Foundry REST API. You can use these in your applications or processes to get the services that you need without requiring the use of the Bluemix UI.

To use the Cloud Foundry CLI to create a service, download it here and install it

    1. Log in to your Bluemix account:
      C:\cf_cli>cf login
      API endpoint: https://api.ng.bluemix.net
      Email> dashtxteam@ibm.com
      Password>
      Authenticating...
      OK
      Targeted org dashtxteam@ibm.com
      Select a space (or press enter to skip):
      1. batcave
      2. async
      Space> 2
      Targeted space async
      API endpoint:   https://api.ng.bluemix.net (API version: 2.54.0)
      User:           dashtxteam@ibm.com
      Org:            dashtxteam@ibm.com
      Space:          async
    2. Create the dashDB service by running the following command:
      C:\cf_cli>cf create-service <service_name> "<plan_name>" "<service_instance_name>" -c "<parameters_file>"

      where <service_name> represents either “dashdb” for analytical workloads or “dashdb for transactions” for transactional (OLTP) workloads<plan_name> is the plan you want to provision.
      For the dashDB service you can specify one of the following plans:

      • SMP Small
      • SMP Medium
      • SMP Large
      • MPP Small

      For the dashDB for Transactions service, you can specify one of the following plans:

      • EnterpriseForTransactions2.8.500
      • EnterpriseTransactional12.128.1400″

      <service_instance_name> is whatever you want to call the service instance that appears in Bluemix.
      <parameters file>

        is a file in json format that you can use to pass in options to tailor the service. The following parameters are available:

      • Oracle_compatible: Specify either “yes” or “no” for the service instance to be Oracle compatible.
      • High_availability: If you are creating a dashDB for Transactions SQL Database service, specify either “yes” or “no” to configure the service with high availability.
      • Datacenter: The location where you want the service to be created:
        us-south:Dallas
        us-south:dallas – federal
        us-south:Houston
        us-south:queretaro
        us-south:San Jose
        us-south:Seattle
        us-south:Toronto
        us-south:Washington d.c
        us-south:Montreal
        us-south:wdc – federal
        us-south:Sao Paulo
        eu-gb:London
        eu-gb:Paris
        eu-gb:Milan
        eu-gb:Frankfurt
        eu-gb:Amsterdam
        eu-gb:Oslo
        au-syd:Hong Kong
        au-syd:Singapore
        au-syd:Sydney
        au-syd:Melbourne
        au-syd:Tokyo
        au-syd:Chennai

      Here is an example of the command in action:

      C:\&gt;cf create-service dashDB "SMP Small" "AwesomeDashDB" -c c:\parameters.json
      Creating service instance AwesomeDashDB in org dashtxteam@ibm.com / space async as dashtxteam@ibm.com...
      OK
      Create in progress. Use 'cf services' or 'cf service AwesomeDashDB' to check operation status.
      Attention: The plan `SMP Small` of service `dashDB` is not free.  The instance `AwesomeDashDB` will incur a cost.  Contact your administrator if you think this is in error.
      C:\&gt;cf service AwesomeDashDB
      Service instance: AwesomeDashDB
      Service: dashDB
      Bound apps:
      Tags:
      Plan: SMP Small
      Description: A flexible and powerful data warehouse for enterprise-level analytics.
      Documentation url: https://console.ng.bluemix.net/docs/services/dashDB/dashDB.html
      Dashboard: https://dashdbrm.ng.bluemix.net/dashDBRM/launchdashboard?region=us-south&amp;instance_id=a35cd3a6-46b2-45e9-ac3a-23da51b92d00
      Last Operation
      Status: create in progress
      Message: dashDB system is being built
      Started: 2016-11-27T19:03:49Z
      Updated: 2016-11-27T19:06:26Z

      In the Parameters.json I specified the following options:
      {
      "oracle_compatible":"no",
      "datacenter":"us-south:Dallas"
      }
    3. Check the status of your provision request. Depending on the location and plan, a dashDB service instance might take some time to provision. You can run the following command to check the provisioning status:
      C:\&gt;cf service AwesomeDashDB

      Service instance: AwesomeDashDB
      Service: dashDB
      Bound apps:
      Tags:
      Plan: SMP Small
      Description: A flexible and powerful data warehouse for enterprise-level analyti
      cs.
      Documentation url: https://console.ng.bluemix.net/docs/services/dashDB/dashDB.ht
      ml
      Dashboard: https://dashdbrm.ng.bluemix.net/dashDBRM/launchdashboard?region=us-so
      uth&instance_id=a35cd3a6-46b2-45e9-ac3a-23da51b92d00Last Operation
      Status: create in progress
      Message: dashDB system is being built
      Started: 2016-11-27T19:03:49Z
      Updated: 2016-11-27T19:06:26Z
    4. After creating a service, you may want to create service keys and use those service keys to access the service directly.
      C:\&gt;cf create-service-key AwesomeDashDB keys1
      Creating service key keys1 for service instance AwesomeDashDB as dashtxteam@ibm.com
      com...
      OK

      C:\&gt;cf service-key AwesomeDashDB keys1
      Getting key keys1 for service instance AwesomeDashDB as dashtxteam@ibm.com
      {
      "db": "BLUDB",
      "dsn": "DATABASE=BLUDB;HOSTNAME=dashdb-enterprise-small-yp-09-04.services.dal.blu
      emix.net;PORT=50000;PROTOCOL=TCPIP;UID=bluadmin;PWD=HIDDEN_PASSWORD;",
      "host": "dashdb-enterprise-small-yp-09-04.services.dal.bluemix.net",
      "hostname": "dashdb-enterprise-small-yp-09-04.services.dal.bluemix.net",
      "https_url": "https://dashdb-enterprise-small-yp-09-04.services.dal.bluemix.net:8
      443",
      "jdbcurl": "jdbc:db2://dashdb-enterprise-small-yp-09-04.services.dal.bluemix.net:
      50000/BLUDB",
      "password": "HIDDEN_PASSWORD",
      "port": 50000,
      "ssldsn": "DATABASE=BLUDB;HOSTNAME=dashdb-enterprise-small-yp-09-04.services.dal.
      bluemix.net;PORT=50001;PROTOCOL=TCPIP;UID=bluadmin;PWD=HIDDEN_PASSWORD;Security
      =SSL;",
      "ssljdbcurl": "jdbc:db2://dashdb-enterprise-small-yp-09-04.services.dal.bluemix.n
      et:50001/BLUDB:sslConnection=true;",
      "uri": "db2://bluadmin:HIDDEN_PASSWORD@dashdb-enterprise-small-yp-09-04.services
      .dal.bluemix.net:50000/BLUDB",
      "username": "bluadmin"
      }

 

More How-tos stories
April 30, 2019

Introducing IBM Analytics Engine v1.2 and Announcing the Deprecation of IBM Analytics Engine v1.0

We are excited to inform you about the new version of IBM Analytics Engine v1.2 that will be available starting May 15, 2019. Along with this release, Analytics Engine v1.0 will be retired.

Continue reading

April 16, 2019

Announcing the Deprecation of the Decision Optimization Beta Service

The End of Beta date for the Decision Optimization service is May 17, 2019. The End of Beta Support date is June 20, 2019.

Continue reading

April 2, 2019

Data Refinery and Profiling Changes in Watson Studio and Watson Knowledge Catalog

We'd like to announce data refinery and profiling changes related to Watson Studio and Watson Knowledge Catalog that will take effect on May 17, 2019.

Continue reading