Faced with limited budget or resources an Oracle Spatial and Graph developer or DBA may consider ETL one of their biggest pain points. Commercial Spatial ETL tools like Safe Software's FME, ESRI's ArcGIS, and Oracle's Data Integrator unfortunately aren't a real option for all Spatial shops. Shell, Python, and Batch scripts can often proliferate and become redundant if strict discipline is not applied.

If you are faced with imminent resource reductions, are struggling with manual processes and their documentation, or are just plain bored with repetitive ETL procedures, then automation via a flexible tool like Gradle should be seriously considered. Written in Groovy and developed initially as a modern replacement for the build tools Ant and Maven, Gradle is much more than a simple build tool. Its declarative domain specific language (DSL) can take advantage of all the object-oriented goodness of Groovy and Java, thus propelling its adopters into the new age of treating build and automation logic as first-class citizens in the development cycle. Another key value point in using a tool like Gradle is its polyglotism: it can interface with and call almost all existing operating systems and languages, thus maintaining and leveraging your investments in these previously disparate skills and knowledge.

In this presentation Mike Sanchez will focus on the open-source, cross-platform build tool called Gradle and how it can be used to automate and extend your existing manual processes without busting your budget, especially when used with other open-source libraries like GDAL, JTS, OGR, GeoTools, QGIS, GeoKettle, etc. Mike will also touch on reasons why automation may not be so easily embraced and offer alternative outlooks to help overcome fear-driven development (FDD).

Maps communicate data faster and more intuitively than any other data visualization method. Map views are built-in in OBI 11g, but aren’t often used because some additional configuration work is needed. You’ll see how to leverage OBI’s native map views in BI dashboards, add geo spatial calculations to OBI analyses and queries, and determine which…

The ability to display data using an appropriate visualization is key to providing insights to business intelligence users. For data with a geographical dimension, geo-spatial views can often be most appropriate. Wider adoption of geo-spatial analytic visualizations in companies has hampered because of the challenge of acquiring mapping and geospatial data, of integrating mapping applications…

Oracle Locator is available as part of every edition of the Oracle Server, and is extended in Enterprise Edition through the Spatial option. OBIEE 11g is aware of Oracle Spatial and Map Viewer, a component of Fusion Middleware.

This paper takes an in depth look at the integration of OBIEE and Spatial, starting with an overview of Oracle Spatial as a data source, through integrating and troubleshooting the display of spatial data through Map Viewer.