Geospatial data types in BI Tools

Third Party Software
Enthusiast

Geospatial data types in BI Tools

Anyone integrated geospatial data into 3rd party tools such as Cognos or Microsoft? I've attempted with Microsoft, but must be missing something in how certain data types translate between the .NET provider and ReportBuilder 3.0.

Thanks in advance
Tags (1)
2 REPLIES
Enthusiast

Re: Geospatial data types in BI Tools

I'm not familiar with any BI tool that includes native support for geospatial data. However, we've begun investigating a product by APOS that integrates with SAP's BusinessObjects BI suite to aid in visualizing and doing analysis with geospatial data.
Teradata Employee

Re: Geospatial data types in BI Tools

Teradata Geospatial types are converted into String. Currently the ADO.NET specification does not support Geospatial data types.

ADO.NET or more specifically Entity-Framework will support Geospatial; see http://blogs.msdn.com/b/efdesign/archive/2011/05/04/spatial-types-in-the-entity-framework.aspx.

The String representation of Teradata Geospatial types can be used with the futuer DB-Geospatial classes.