CODEWITHSUNDEEP
web-servicesreporting-servicesreporting
KB22
KB22

Reputation: 6969

Consuming web services with reporting tools

A customer of mine happend to ask me to come up with a technical solution for the following scenario:

--> beeing 'state of the art' my customer want's to use web services for this; which IMHO is definitly not the way to do this; I'd favorize the creation of VIEWS which the crm customers can use to feed their reporting tools via ODBC for example.

So, what's you guys opinion on this, how would you approach this scenario? Any best practices?

Upvotes: 1

Views: 476

Answers (2)

Sudheer
Sudheer

Reputation: 728

How about empowering the customer to be able to write custom modules or plugins to the CRM software? If the built in reports don't suffice, they can quickly roll out their plugin to accomplish their objectives. IMO, exposing APIs is a much better approach. Also. there's nothing wrong with customers accessing the database tables directly. But the latter approach may be more cumbersome to some customers.

Your mileage may vary.

Upvotes: 1

merin
merin

Reputation: 333

I thing that web-services is a nice solution. Using VIEWS - is using db authorization. While using WS you can be more secure :-)

Upvotes: 1

Related Questions