PowerPivot Multiple OData Services Related
I'm playing around with OData with PowerPivot and I would like to know can I relate multiple OData services together?
I don't want to have one huge OData service as I want to roll this out for all of our internal systems. I think one service would get messy.
Something like; http://hosting/Sales.svc开发者_运维百科 http://hosting/Clients.svc http://hosting/Finance.svc
With some relationships mapped within.
Anyone know how I can do this?
Thanks, Mike Mengell
I've worked it out.
In the PowerPivot window you have a design tab. Select create relationship and you can select the enity which can be from any service, in my case it's 2 OData services. Then you select the field for the relationship.
At the moment there doesn't seem to be any automatic relationship creation. Which for me is probably a blocker on using this for my business.
But the process is painless if you understand about the relationships.
I'll write a blog post about this soon and post it here.
Easy; create three services with different Contexts / models.
--larsw
精彩评论