Infrastructure Map Server General Discussion

Infrastructure Map Server General Discussion

Reply
Active Member
bhenning
Posts: 10
Registered: ‎10-13-2006
Message 1 of 4 (163 Views)

FDO - Views/Queries/Stored Procedures

163 Views, 3 Replies
01-17-2007 09:04 AM
Does anyone know if there are any plans to include the functionality to use View, Queries, and Stored Procedures as Layer Data Sources in MapGuide Enterprie?

I understand that stored procedures may be a little more complex but connecting to a SQL Server View or exectuing a query would be very close to connecting to a table.
*Jason Birch
Message 2 of 4 (163 Views)

Re: FDO - Views/Queries/Stored Procedures

01-18-2007 12:05 AM in reply to: bhenning
bhenning wrote:
> I understand that stored procedures may be a little more complex but connecting to a SQL Server View or exectuing a query would be very close to connecting to a table.

I'm not sure if this is planned (perhaps ask the FDO Open Source
project?) but I do know that the KING Oracle FDO provider supports views
already, so it's technically possible:

http://www.sl-king.com/fdooracle/

Jason
*Andy Morsell
Message 3 of 4 (163 Views)

Re: FDO - Views/Queries/Stored Procedures

01-18-2007 09:27 AM in reply to: bhenning
This is probably the single most requested feature (or at least view
support) I am hearing from customers and colleagues working with MapGuide
Enerprise and Open Source.


--
Andy Morsell, P.E.
Spatial Integrators, Inc.
http://www.SpatialGIS.com


wrote in message news:5454469@discussion.autodesk.com...
Does anyone know if there are any plans to include the functionality to use
View, Queries, and Stored Procedures as Layer Data Sources in MapGuide
Enterprie?

I understand that stored procedures may be a little more complex but
connecting to a SQL Server View or exectuing a query would be very close to
connecting to a table.
Member
dave.thompson
Posts: 3
Registered: ‎02-07-2007
Message 4 of 4 (163 Views)

Re: FDO - Views/Queries/Stored Procedures

02-07-2007 08:53 AM in reply to: bhenning
Views are definately ESSENTIAL if enterprise is to succeed at all. We have a major MG6.5 application used by a number of global companies but our porting to enterprise was brought to a complete halt because we can not access data from views.
How can Autodesk suggest this product will be a market leader if it can't handle something as simple as data stored in linked tables (ie how a database should be structured).
Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Do you have 60 seconds to spare? The Autodesk Community Team is revamping our site ranking system and we want your feedback! Please click here to launch the 5 question survey. As always your input is greatly appreciated.