Does IBM offer a tool to migrate my on-premises data to IBM Db2® Warehouse on Cloud?
Yes. IBM Lift will quickly, securely and reliably migrate your on-premises data warehouse from your data center to the IBM Cloud™. Please reference the IBM Data Migration page for more information.
Does IBM Db2 Warehouse on Cloud support NoSQL?
Yes. IBM Db2 Warehouse on Cloud integrates with IBM Cloudant and can easily synchronize your JSON data within Cloudant to structured data within the cloud data warehouse. This process then allows for traditional business intelligence (BI) and analytics common in data warehouses. Since IBM Db2 Warehouse on Cloud has in-database predictive algorithms built in, those clients that are using Cloudant can analyze their JSON document stores hassle free.
What are some examples of the algorithms included with IBM Db2 Warehouse on Cloud?
Included in the cloud data warehouse are algorithms for linear regression, decision tree clustering, k-means clustering and ESRI-compatible geospatial extensions.
What security certifications does IBM Db2 Warehouse on Cloud have?
IBM Db2 Warehouse on Cloud complies with several security standards, including ISO 27001 and SOC 2. See our compliance document for more details.
Does IBM Db2 Warehouse on Cloud support the Health Insurance Portability and Accountability Act (HIPAA)?
Yes. The SMP Medium, SMP Large and MPP Small plans for IBM Db2 Warehouse are HIPAA ready.
Does IBM Db2 Warehouse on Cloud have Oracle compatibility?
Yes. You must indicate on the provisioning form whether or not you require Oracle compatibility.
Is IBM Db2 Warehouse on Cloud compatible with my existing IBM PureData System for Analytics?
Yes. Most of your PureData System for Analytics workload will migrate seamlessly to Db2 Warehouse on Cloud. For the select few edge cases, we offer free tooling to help you make a smooth transition.
How do I connect Db2 Warehouse on Cloud to an analytics application?
In this video (6 minutes), we will show you how to connect your cloud data warehouse to a business analytics tool, such as IBM Cognos Analytics, to access the data and create a simple dashboard.
Does IBM Db2 Warehouse on Cloud have high availability?
Yes. MPP Small and MPP Large plans support node HA. If one node suffers an outage, work will fail over to the remaining nodes of the cloud data warehouse in the cluster. The cluster needs downtime in order to restart the fallen node.
What data visualization and ETL tools can I use with IBM Db2 Warehouse on Cloud?
IBM Db2 Warehouse on Cloud works well with many data visualization and ETL tools including Tableau, Looker, Cognos, IBM Watson Analytics, Watson Studio, Informatica, IBM DataStage, and Aginity Workbench. In addition, IBM Db2 Warehouse on Cloud provides free JDBC and ODBC drivers for download.
How do I provision IBM Db2 Warehouse on Cloud to take advantage of elastic compute and storage resource allocation?
This video (5 minutes) demonstrates the flexibility and power of the Flex Performance plan and will cover the steps to provision the cloud data warehouse and how to independently scale the instance's compute and storage resources, and explore the self-service Backup and Restore feature.
What is the difference between the “Flex” and “Flex Performance” plans?
While both plans offer elastic, independent scaling of storage and compute nodes the “Flex” plan is for storage-dense workloads whereas the “Flex Performance” plan is for compute intensive workloads that favor performance over storage density.
Can my existing IBM Db2 entitlements be used to access selected Db2 on Cloud and Db2 Warehouse on Cloud services?
Yes. For more information, reference Announcement Letter 218-145.
Proof of concepts
Did you know that IBM offers proof of concepts for Db2 Warehouse on Cloud?