Tons of great development going on at Quest Software with new database tools and technologies hitting the market every quarter. One tool in particular that I’m really excited about is Toad for Cloud Databases (TCD). TCD was built for developers and DBAs who might not be as familiar working with NoSQL data stores as they are with a RDBMS, and basically lets you use a SQL IDE to translate SQL statements into a language understood by NoSQL cloud databases and returns the results into consumable information.
Toad for Cloud Databases enables users to use SQL to:
- Work with data in a Cloud database.
- Join a Cloud database to a relational database on the personal computer.
- Copy tables from one Cloud database to another or between a Cloud database and a
relational database on the personal computer.
While the market isn’t huge for this type of technology yet, The explosion of data is forcing companies to seek out new database alternatives. The use of cloud technologies like Hadoop, Cassandra, Azure, Mongo DB and SimpleDB enable companies to have highly available, scalable and cost efficient data stores to support data intensive applications. However, accessing and programming these cloud sources can be difficult and time consuming; complicating what should be simple tasks such as querying and analysis.
The latest release of Toad for Cloud Databases 1.3 now supports MongoDB. MongoDB (from “humongous”) is a scalable, high-performance, open source, document-oriented database. Written in C++, MongoDB features: Document-oriented storage, Full Index Support, Replication & High Availability, Auto-Sharding, Querying, Fast In-Place Updates, Map/Reduce, GridFS, and has Commercial Support.
Whether you’re a NoSQL pro or just want to learn more about developing NoSQL databases, we encourage you to download Toad for Cloud Databases. We also have good online resources available at http://nosqlpedia.com/