Re: [mapguide-users] .mgp with Feature Source Oracle?
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. Le 09/05/2017 à 05:00, open_saucer a écrit : 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 mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users -- Jérôme Touré STERN 473 route des Dolines Villantipolis 7 06560 VALBONNE Phone : +33 4 92 96 96 01 Mobile : +33 6 27 84 04 30 Fax : +33 4 92 96 96 02 <>___ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] .mgp with Feature Source Oracle?
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 mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] .mgp with Feature Source Oracle?
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. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users
[mapguide-users] .mgp with Feature Source Oracle?
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. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users
