One Cloud Data Warehouse, Three Ways

by Mona Patel

There’s something very satisfying about using a single, cloud database solution to solve many business problems.  This is exactly what BPM Northwest experiences with IBM dashDB when delivering Data and Analytics solutions to clients worldwide.

The exciting success with dashDB compelled BPM Northwest to share implementations and best practices with IDC.

In the webcast they team up to discuss the value and realities of moving analytical workloads to the cloud.   Challenges around governance, data integration, and skills are also discussed as organizations are very interested and driven to seize the opportunities of a cloud data warehouse.

In the webcast, you will hear three ways that you can utilize IBM dashDB:

  • New applications, with some integration with on-premises systems
  • Self-service, business-driven sandbox
  • Migrating existing data warehouse workloads

After watching the webcast, please think about how IBM dashDB use cases discussed can apply to your challenges and if a hybrid data warehouse is the right solution for you.

Want to give IBM dashDB on Bluemix a try?  Before you sign up for a free trial, take a tutorial tour on the IBM dashDB YouTube channel to learn how to load data from your desktop, enterprise, and internet data sources, and then see how to run simple to complex SQL queries with your favorite BI tool, or integrated R/R Studio. In fact, watch how IBM dashDB integrates with other value added Bluemix services such as Dataworks Lift and Watson Analytics so that you can bring together all relevant data sources for newer insights.

mona_blog

About Mona,

mona_headshotMona Patel is currently the Portfolio Marketing Manager for IBM dashDB, the future of data warehousing.  With over 20 years of experince analyzing data at The Department of Water and Power, Air Touch Communications, Oracle, and MicroStrategy, Mona decided to grow her career at IBM, a leader in data warehousing and analytics.  Mona received her Bachelor of Science degree in Electrical Engineering from UCLA.

dashDB grows and improves in a flash!

By Dennis Duckworth, 

IBM® dashDB™ continues to grow and improve with some announcements made on December 18, 2014.  Additional plans are now available to everyone and new features have been included in dashDB.

New Deployment Options

  • Enterprise Plan available to all – The Enterprise Plan for dashDB is a dedicated cloud infrastructure with tera-scale capacity. This offering is now available to anyone. Contact your IBM Information Management Sales representative to get started!
  • Cloudant deployments of dashDB now offer higher capacity, paid usage plans – We are adding an Entry plan that is fully integrated with Cloudant supporting up to 50 GB of uncompressed data, for $50/month. The freemium offering for data usage below 1 GB will remain.
  • Expanded Geographic Presence – dashDB can now be deployed in our UK availability region in addition to our existing North American region.

New Cool and Useful Features

As a result of input from beta program participants, we have added new features to dashDB to make it even more useful:

  • Improved SQL Editor – The SQL query and editor capabilities have been expanded to allow a full range of SQL to be submitted via the web browser, including the ability to load and save SQL scripts. SQL validation and error checking is also included.

DD 1

  • Better Workload Monitoring – Get a much better idea of what’s running in your dashDB instance, including specific statements and connections. Set it to monitor in near real-time, drill into the details of a session, or terminate a session if needed.

 DD2

  • Command Line Support – Sometimes, you need a command line interface for scripting and automation. dashDB now includes CLPPlus support – so you now get a command line user interface that lets you connect to databases and define, edit, and run statements, scripts, and commands.
  • UDX Support – Some applications or algorithms require user-defined functions (UDFs) and user-defined aggregates (UDAs). dashDB now supports these out of the box so you can implement and run your own algorithms right inside the database.

New Security Features and Capabilities

Data security is always a consideration, and dashDB now includes new security features:

  • SSL Support for all Connections – It’s not enough to automatically encrypt data at rest, we need to encrypt it in motion too. dashDB now supports SSL for all connections to the database.

DD3

  • Select Guardium Reports for all PlansdashDB now has bundled Guardium reports for all plans including the Enterprise and Cloudant integrated plans. This allows for automatic discovery of sensitive data, as well as access reports and details of SQL statements that were run against that data.

DD4

We will continue to add new features and capabilities to dashDB over the coming months, so watch this space!

If you have not started analyzing your data in dashDB, what are you waiting for? Get started with dashDB on Bluemix or Cloudant at dashDB.com.

About Dennis Duckworth

Dennis Duckworth, Program Director of Product Marketing for Data Management & Data Warehousing has been in the data game for quite a while, doing everything from Lisp programming in artificial intelligence to managing a sales territory for a database company. He has a passion for helping companies and people get real value out of cool technology. Dennis came to IBM through its acquisition of Netezza, where he was Director of Competitive and Market Intelligence. He holds a degree in Electrical Engineering from Stanford University but has spent most of his life on the East Coast. When not working, Dennis enjoys sailing off his backyard on Buzzards Bay and he is relentless in his pursuit of wine enlightenment. You can follow Dennis on Twitter