Infrastructure Map Server General

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

FDO - Views/Queries/Stored Procedures

150 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 (150 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 (150 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 (150 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).

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community