[mapguide-users] .mgp with Feature Source Oracle?

[open_saucer]

Is it a requirement to create a .mgp pakage from feature source oracle?

My plan workflow is to connect to Oracle--> choose a spatial table and
create a vector layer definition from the Oracle database --> once I have
the layer then I should able to use that layer to create a web map
application right?

So there is no need to create a .mgp package of the entire Oracle db and
then Load Package from Site Administrator right?

Any pointers would be appreciated. Thanks,



--
View this message in context: http://osgeo-org.1560.x6.nabble.com/mgp-with-Feature-Source-Oracle-tp5319793.html
Sent from the MapGuide Users mailing list archive at Nabble.com.

[Jackie Ng]

Say you have a DEV MapGuide Server and a PROD MapGuide Server, you can author
up all your layers/maps/etc on the DEV instance, create a mgp package that
you can the load into the PROD instance and have all your
data/layers/maps/etc in there without having to repeat all this work.

So an .mgp package is only a requirement if you have the need to move data
from one MapGuide Server to another.

- Jackie



--
View this message in context: http://osgeo-org.1560.x6.nabble.com/mgp-with-Feature-Source-Oracle-tp5319793p5319802.html
Sent from the MapGuide Users mailing list archive at Nabble.com.

[open_saucer]

I don't intend to move data from one server to another. I shouldn't have to,
if there is an Oracle DB that have spatial table right? I can just let any
MapGuide Server access the Oracle DB, read the spatial table and
serve/publish that spatial table as an layers/maps/etcs.

So really there is no need to create an .mgp package right? If I do decide
to create .mgp package of the Oracle DB, then could I just choose one
spatial table to create a package, just for that table? Or do I have to
create a package of the whole Oracle DB with all the spatial tables in it?
that wouldn't be good if the Oracle DB instance is really big, like more
than 30gb with all those spatial tables in it.





--
View this message in context: http://osgeo-org.1560.x6.nabble.com/mgp-with-Feature-Source-Oracle-tp5319793p5319803.html
Sent from the MapGuide Users mailing list archive at Nabble.com.

[Jérôme Touré]

Hi,

It's hard to understand what you're trying to do as what you say does
not really make sense.

Working with Oracle DB is pretty straight forward.

1 - Create a feature source and select the Oracle Provider
2 - Enter the connection parameters
3 - Save
That's done.

When you want to use data from your Oracle database, you just have to
create a new Vector Layer Definition from the Feature Source and select
the table containig the spatial data you want to display.

So packages are definitely not needed to work with an Oracle DB.

Moreover, packages do not store spatial data but the parameters entered
in Maestro.
To make it simple, consider mgp files as ZIP archives with all the
parameters of the resources packaged in XML format.

So if you create a mgp of your Oracle feature source, it will be a 2ko
file, no matter how big your Oracle schema is.


I hope this will help.

Post by open_saucer
I don't intend to move data from one server to another. I shouldn't have to,
if there is an Oracle DB that have spatial table right? I can just let any
MapGuide Server access the Oracle DB, read the spatial table and
serve/publish that spatial table as an layers/maps/etcs.
So really there is no need to create an .mgp package right? If I do decide
to create .mgp package of the Oracle DB, then could I just choose one
spatial table to create a package, just for that table? Or do I have to
create a package of the whole Oracle DB with all the spatial tables in it?
that wouldn't be good if the Oracle DB instance is really big, like more
than 30gb with all those spatial tables in it.
--
View this message in context: http://osgeo-org.1560.x6.nabble.com/mgp-with-Feature-Source-Oracle-tp5319793p5319803.html
Sent from the MapGuide Users mailing list archive at Nabble.com.
_______________________________________________
mapguide-users mailing list
https://lists.osgeo.org/mailman/listinfo/mapguide-users

[open_saucer]

Thanks Jerto, this definitely helps.
It confirms what I'm thinking. Sorry for the confusion guys.



--
View this message in context: http://osgeo-org.1560.x6.nabble.com/mgp-with-Feature-Source-Oracle-tp5319793p5319916.html
Sent from the MapGuide Users mailing list archive at Nabble.com.