How to use TIBCO Maps with Jaspersoft Studio Pro

The TIBCO Maps component is available in the Professional edition (or better) of Jaspersoft Studio.

In this example we show how to overlay polygons (e.g. "closed" paths or geographical areas) of US States on top of a map available via TIBCO GeoAnalytics. Alternatively you can use "open" paths to represent roads/routes or markers to represent specific points on the map, rather than areas.
This example is based on Jaspersoft Studio 6.1.1. It should work since release 6.1.0.

[PushpendraGangwarr]

Very helpful tutorial.. everyone must watch to get around with TIBCO maps...

[ernestoongaro]

Great tutorial, very helpful. Thank you for posting

[PushpendraGangwarr]

Not able to download the two attachments: proc.sql and ddl.sql from community website, even after logging in. Can you please attach here or somewhere at public area and post the links??

If its proprietary then please explain how can a custom one created.

[feschber]

for some reason the map crashes for me when zooming, moving around the map is fine though

[jonasluersen]

Why does not polygons display when exporting to pdf?

[PushpendraGangwarr]

In file Proc.sql either remove this:

v_vector VectorType;

from DECLARE section in ST_Vectorize(). Or add below lines above:

CREATE TYPE vectortype AS (
startcoord coordtype,
endcoord coordtype
);


As currently its showing error while importing to databaser:

ERROR: type "vectortype" does not exist
LINE 8: v_vector VectorType;
^

And one more thing the given query there is a table name: usa_state_population . Where can i find it ? Can i create it with current data ??

[thetannguyen]

If my shape file does not have longitude and latude fields but only geomatry, how do I declare it? please help me

[kishorekokkisa]

Hi Tutorial is good, but I'm facing one issue that in Tibco jaspersoft professional 6.1.0, I cannot fill the colors for states and 6.2.0 there is some error with Filldata. Can you please let me know, which version are you using ?