GeoIQ Connect – open access to databases

Yesterday we announced the availability of GeoIQ Connect, an integrated component of the GeoIQ platform that enables users to quickly and easily access information stored in relational and NoSQL databases. You can now combine publicly and file-based data with database and internal data regardless of where it is and what database it is using.

GeoIQ is built to make it easy to visualize and analyze data that is openly accessible, regardless of the original format. GeoIQ Connect moves that a huge step forward by connecting into relational and NoSQL data storage engines. With just a few clicks, users can register their data from Oracle, MySQL, or even HBase and access it through the standard GeoIQ explorer interface. You no longer need to write or understand SQL, Map/Reduce, or other API’s in order to leverage that data that is stored in data warehouses or online services.

In the last few years there has been a resurgence in the number of data storage options – beyond the traditional SQL databases new storage such as HBase, MongoDB, Riak, and more now make for a myriad of decisions based on the way you want to store and access your data. Each option has unique characteristics of write and read speeds, latency, consistency, and schema. Following the decision to use a storage option developers and companies must then build unique interfaces to access the data. GeoIQ Connect opens up the options by providing a consistent interface and access across all of these databases, allowing you to make a decision for your storage based on specific characteristics but still allow anyone in your organization to access it easily and securely.

Even more recently, cloud geospatial datastores such as Location Labs and SimpleGeo launched to allow developers to push data into their storage. These powerful engines are focused on specific tasks – and now GeoIQ Connect lets you extend these storage platforms by providing tools to visualize and analyze the data that you’ve stored in the cloud.

GeoIQ Connect is launching with support for Oracle, MySQL, PostgreSQL relational databases, and spatial extensions if evailable; as well as HBase and MongoDB NoSQL data stores. This summer we’ll be releasing additional adapters for cloud storage and streaming media in order to allow users to fuse their social media and realtime data with their enterprise information.

Contact us if you’d like to give GeoIQ Connect a try for visualizing and analyzing your data.